mysql query question.....legitamate?

juschillinnow

$gone = '<br><font size="4" color="#FF0000">GONE</font><br>';

$numresults=mysql_query("select * from storeProduct where storeProduct.productCategory = '$categoryID' and productDescription != '$gone' order by productName");
$numrows=mysql_num_rows($numresults);

Is this a legitamate mysql query, and should it work. It doesn't seem to be doing what it's suppose to be doing.

Oh yeah....and it's not returning any errors though.

Wait a second. I just thought about it.

I don't need " != " I need " !like '%$gone%' " or maybe 'does not contain '$gone'";

How would you word this?

stolzyboy

its not spitting any errors cuz you didn't tell it to spit errors, use the or die()

$numrows=mysql_num_rows($numresults) or die(mysql_error());

juschillinnow

ok, forget the error part.

How do I do what I'm asking?

$gone = '<br><font size="4" color="#FF0000">GONE</font><br>';

$numresults=mysql_query("select * from storeProduct where storeProduct.productCategory = '$categoryID' and productDescription  [I]DOES NOT CONTAIN[/I] '$gone' order by productName");
$numrows=mysql_num_rows($numresults);

DOES NOT CONTAIN

stolzyboy

the mysql manual say use != or <>

juschillinnow

I already looked at that. But that is only if the entire field does not equal that.

I need to know if the field CONTAINS $gone.

It would be ok if I could do it with php and then send the query to mysql, but I have to do this "inside the mysql query" in order for it to do what I need.

stolzyboy

then use like or not like

juschillinnow

right......but that takes me back to my first post.

I need NOT LIKE

I don't want to select the rows that contain that info, so it needs to be NOT LIKE '%$gone%' but I don't think it works like this

so what would be the wording

stolzyboy

read my reply before this one, i was editing it when you submitted your reply, use not like i tested it on a database i have and it works

juschillinnow

cool. Thanks. I thought that's what I had, but I must have typed something wrong.