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: www.amazon.co
is there something wrong with my SQL Query? I didnt get any results
neither errors..
$link = mysql_connect('localhost', '') or die('Cannot connect to
the database.');
mysql_select_db("profiles",$link);
$SQLQuery = "INSERT INTO profyles (username, fname, mname, lname, address,
country, gender,
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
ContactID is setup as a tinyint so I dropped the single ticks. No luck. I
ran the query in the MySQL client and got the ERROR 1054: Unknown column
'$ContactID' in 'where clause'. I know the column ContactID exists.
Steve
"Josh Hoover" <[EMAIL PROTECTED]> wrote in message
E973048AB322D411AE9900
In your query, do you need the single ticks around the $ContactID? Is the
ContactID column a char/varchar field which would require the single ticks?
I'm wondering if that's causing your problem. Also, what if you do that
query via the MySQL client? What do you get then?
Josh Hoover
KnowledgeS
