[SOLVED] Small SQL Syntax Problem

[eRott]

It's the strangest error. When ever I use the code:

 

	$query = "SELECT $fld_email FROM $tbl_name WHERE $fld_email = '$email'";
	$result = mysql_query($query, $conn);
	return (mysql_num_rows($result) > 0);

 

I always get a syntax error:

 

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/~/public_html/~/~/FILE.php on line 100

 

However, if i choose to substitute the variables for their direct values, it seems to work:

 

	$query = "SELECT email FROM clients WHERE email = '$email'";
	$result = mysql_query($query, $conn);
	return (mysql_num_rows($result) > 0);

 

The variable's look like:

 

$tbl_name = "clients";
$fld_email = "email";

 

I've tried single quoting the variable names (in the sql query), as well as changing the names of the variables. It's not really a problem, however, I am curious as to why. So, any ideas?

[Barand]

First step is always something like

$result = mysql_query($query, $conn) or die (mysql_error() . "<pre>$query</pre>");

[GingerRobot]

No doubt you'll find one or both of the variables are undefined.

[eRott]

So it would appear. Thanks for your help guys .

 

I simply forgot to declare them as global variables along with my connection variable. Woops .

 

global $conn, $tbl_name, $fld_email;

 

Thank you once again.