Search results for query: *

You were right. It works now. Thanks a lot!!

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...

I installed (I think) IIS from Win XP CD. It doesn't mention anything about informing it in the phpMyAdmin documentation...

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...

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!

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...

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

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...

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!

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.....

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...

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.

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 !!!

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...

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...

I just tried it and it worked. You CAN replace only one field, leaving the rest of the record intact. You just have to select your unique key together with other fields that you want to modify: mysql> describe testa; +-------+----------+------+-----+---------+----------------+ | Field | Type...

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.

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...

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)

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)...