that up!
Kip Gordon
- Original Message -
From: Michael Stassen
To: Kip Gordon
Cc: [EMAIL PROTECTED]
Sent: Saturday, May 08, 2004 10:05 PM
Subject: Re: Another Stupid Newbie Question ^.^
Kip Gordon wrote:
I connect to my data base...
$dbh=mysql_connect (localhost
$query=SELECT * FROM women WHERE 'id=$id';
This would result in something like:
SELECT * FROM women WHERE 'id=1'
Do you see the error here?
$query=SELECT * FROM women WHERE id=$id;
or
$query=SELECT * FROM women WHERE id='$id';
would be better...
Tips for debugging this in PHP:
- print the
Query failed : You have an error in your SQL syntax. Check the manual
that corresponds to your MySQL server version for the right syntax to
use near 'index = 21' at line 3
I believe 'index' is a reserved word, usually used for creating indexes.
Using it as a field in a table could quite likely
I connect to my data base...
$dbh=mysql_connect (localhost, kipples_women, ) or die ('I cannot connect to
the database because: ' . mysql_error());
mysql_select_db (kipples_hotwomen);
and then I issue a query..
$query=SELECT *
FROM women
WHERE index = $id;
Kip Gordon wrote:
I connect to my data base...
$dbh=mysql_connect (localhost, kipples_women, ) or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db (kipples_hotwomen);
and then I issue a query..
$query=SELECT *
FROM women
WHERE