That means either your $result doesn't exist or the query you used to get
$result failed.
Use something like this (at least in PHP) to see what MySQL's error was:
if ($result=mysql_query($query))
{
//worked
//echo mysql_num_rows($result);
}
else
{
//didn't work
$errMsg=Failed Query:
Here is the full error I am getting when running the query included:
Failed Query: SELECT * FROM customers WHERE Customer_No = CMET3558539239
1054 : Unknown column 'CMET3558539239' in 'where clause'
Here's the problem, I know that Customer_No exists. I can see it in the
database. This code
?
Ryan Shrout
-Original Message-
From: Bill Elvis Gibbs [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 18, 2001 3:20 PM
To: Shrout, Ryan
Subject: RE: Unknown column in 'where clause' error
WHERE Customer_No = 'CMET3558539239'
you need to use quotes when trying to reference data