Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: yigalm
- Order by date
-
-
Cannot start phpMyAdmin
It is funny, but I was trying to play with PHP without actually installing PHP itself. I was just thinking in terms of ASP, where nothing extra had to be installed, and the server knew automatically what to do with the script. Now I downloaded and installed PHP installer from php.net. Trying to... -
Cannot start phpMyAdmin
I installed (I think) IIS from Win XP CD. It doesn't mention anything about informing it in the phpMyAdmin documentation... -
Cannot start phpMyAdmin
Hi I am trying to start phpMyAdmin, but so far witout success. I unzipped it into a directory(phpMyAdmin) inside my root directory(wwwroot) on Win XP Pro. I changed the variable in the configuration file to point to this directory (http://localhost/phpMyAdmin/). I never created any... -
ASP or PHP
Hi, I want to create a website with a MySQL DB at the back end. And I am being told that I'd be better off using PHP rather than ASP for this purpose. So far, I only know some ASP, but no PHP. Are there any advantages to using ASP instead of PHP for the website? Thank you!- yigalm
- Thread
- Replies: 2
- Forum: Microsoft: ASP (Active Server Pages)
-
PWS on Win XP
Thanks for the reference to that article. It says that I have installed IIS instead of PWS. This is cool! But I still can't get it to process ASP pages. Is the server automatically started with Windows? Maybe I am mistyping the URL... What would the URL be for mypage.asp located in the wwwroot...- yigalm
- Post #6
- Forum: Microsoft: ASP (Active Server Pages)
-
PWS on Win XP
It is XP Professional. Does it make a difference though? I remember doing the same on Win 98 and I had no trouble starting the server. Thanx, IM- yigalm
- Post #3
- Forum: Microsoft: ASP (Active Server Pages)
-
ASP or PHP
Hi I want to create a website with a MySQL DB. I need it to perform basic things like adding, deleting, modifying and seaching user records by means of web forms. Also, I want users to be able to anonimously email other users through a web form, and also keep a copy of all correspondence on the... -
PWS on Win XP
Hi I think I have installed PWS on Win XP. I even have the Inetpub folder and the wwwroot directory inside it. But I cannot find a way to start the server, and also, (or therefore?) IE does not display any .asp pages in the wwwroot directory. How can I run ASP on Win XP? Thaks a lot!- yigalm
- Thread
- Replies: 7
- Forum: Microsoft: ASP (Active Server Pages)
-
Concatenate records
I am new to MySQL. Probably that is why I don't understand what you mean. What is 'a' and 'b' in the following?: "select concat(a.Software, b.Software) from" What is 'x' and 'xxx' in the following?: x a inner join x b on a.ID = b.ID and a.xxx != b.xxx..... -
Concatenate records
Let me clarify what I am trying to do. I have a table like so: Software ID word 55 excel 55 access 55 winzip 55 photoshop 55 powerpoint 55 And I want to put all this data into here: ID Name E-Mail Software 55 Joe joe@joe.com... -
Concatenate records
Hi, Is it possible to concatenate records into one? I mean, that if I have a table of software titles, is it possible to put them all into one record? Thank you. -
Make a column unique
I got it! I will use one insert like above, to only copy joined records. And I will use another insert with the IGNORE option to copy the rest of the records, ignoring the duplicates. Thank you, cDevX99 !!! -
Make a column unique
I guess you are right. It would make sence because REPLACE would delete the entire old record and put the entire new record in it's place. Therefore, if the new record does not have values for some fields, they will be set to default. I need to update some columns in one table with data from... -
Change column status
Hi, I need to make one field unique in a table. The table description (show create table_name) already lists this field as being a KEY. I don't know what this means, but when I say: "alter table table_name add unique (field_name);" I get an error: "ERROR 1061: Duplicate key... -
Make a column unique
...| | | | | +-------+----------+------+-----+---------+----------------+ 2 rows in set (0.00 sec) mysql> select * from testa; +----+-------+ | id | name | +----+-------+ | 1 | igor | | 2 | tom | | 3 | keith | +----+-------+ 3 rows in set (0.00 sec)... -
Make a column unique
I got it. When replacing you have to select the fields which you want to replace AND the unique field which you want to use as a common denominator. -
REPLACE quirie
I believe that UPDATE will not update from another table in MySQL, and REPLACE should be used in it's place. http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#REPLACE I tried to UPDATE in Access and it worked, but in MySQL it gives errors when you try to update from... -
Make a column unique
I only want to change t1.str2 to the value of t2.str2 with the following result: mysql> select * from t1; +------+------+------+ | str1 | str2 | str3 | +------+------+------+ | abc | poi | bac | | zxc | cxz | xzc | +------+------+------+ 2 rows in set (0.01 sec) -
Make a column unique
Here I tried it your way, making primary keys for two tables. And it appended again. How is this wrong? mysql> select * from t1; +------+------+------+ | str1 | str2 | str3 | +------+------+------+ | abc | cba | bac | | zxc | cxz | xzc | +------+------+------+ 2 rows in set (0.01 sec)...
