SQL query fails when adding a text field to the WHERE clause.

chelf

Hi guys,

I just started to learn MySql and php and am relatively new to how databases work. I setup my database and wrote the following code and I get the error:

Quote:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource

Expand|Select|Wrap|Line Numbers

 
mysql_select_db("breedknowledge", $con);
 
$qheight = $_POST["height"];

$qminwgt = $_POST["minwgt"];

$qmaxwgt = $_POST["maxwgt"];

$qexercize = $_POST["exercize"];

$qgrooming = $_POST["grooming"];
 
if ($qheight == "") { $qheight = "99"; }

if ($qminwgt == "") { $qminwgt = "1"; }

if ($qmaxwgt == "") { $qmaxwgt = "999"; }
 
$result = mysql_query("SELECT * FROM breeds WHERE weight >= $qminwgt AND weight <= $qmaxwgt AND exercize = $qexercize ORDER BY breedname");

$numrows = mysql_num_rows($result);

Now when I remove "AND exercize = $qexercize" I don't get the error. The only difference is that this field is a text field. I can run the query just fine in my MySQL admin program through my hosting site. The code looks fine I don't get it! Please help! Thanks!

chelf

Nevermind I figured it out, I found that text variable references need to be delimited by a ' so I created a $sqlbuild variable and built the select code differently

Atli

Hi.

Did you try just adding the single-quotes?

Expand|Select|Wrap|Line Numbers

mysql_query("SELECT ... exercize = '$qexercize' ...");

In any case, glad you found a solution.

P.S.
Please use [code] tags when posting your code examples.
(See How to ask a question)

[code] ... Code goes here... [/code]

P.P.S.
I changed the title of the thread.
Please refrain from using phrases like "need help" as the title. They are of no use at all.
(See Use a good thread title)

Thank you.
Moderator

SQL query fails when adding a text field to the WHERE clause.

re: SQL query fails when adding a text field to the WHERE clause.

re: SQL query fails when adding a text field to the WHERE clause.

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about