[PHP-DB] MYSQL Query problem...

2003-09-21 Thread Ian Bert Tusil
is there something wrong with my SQL Query? I didnt get any results neither errors.. ?php $link = mysql_connect('localhost', 'username') or die('Cannot connect to the database.'); mysql_select_db(profiles,$link); $SQLQuery = INSERT INTO profyles (username, fname, mname, lname, address, country,

Re: [PHP-DB] MYSQL Query problem...

2003-09-21 Thread Fedde van Feggelen
is there something wrong with my SQL Query? I didnt get any results neither errors.. ?php $link = mysql_connect('localhost', 'username') or die('Cannot connect to the database.'); mysql_select_db(profiles,$link); $SQLQuery = INSERT INTO profyles (username, fname, mname, lname, address,

Re: [PHP-DB] MYSQL Query problem...

2003-09-21 Thread John W. Holmes
Ian Bert Tusil wrote: is there something wrong with my SQL Query? I didnt get any results neither errors.. [snip] mysql_query($SQLQuery,$link); That's because you're not checking for errors... mysql_query($SQLQuery,$link) or die(mysql_error()); -- ---John Holmes... Amazon Wishlist:

[PHP-DB] MySQL Query problem...

2002-07-08 Thread NIPP, SCOTT V (SBCSI)
I seem to have run into another problem with a query that I am doing exactly like the example in the MySQL documentation, I think. The following query is not working on my PHP page, and it is not working from a MySQL command line either. This looks exactly the same as an example in the

Re: [PHP-DB] mysql query problem

2001-07-26 Thread Paul Burney
on 7/26/01 11:11 AM, Steve Fitzgerald ([EMAIL PROTECTED]) wrote: ran the query in the MySQL client and got the ERROR 1054: Unknown column '$ContactID' in 'where clause'. I know the column ContactID exists. Of course it did. It can't find the text $ContactID in the table. Try putting in a