PhP Query Help

[fonecave]

Hi Guys,

 

I am trying to run a mysql query in PHP,

 

I need it to select all field in the products table where it matches a variable to the string in a field in the table AND the other where statement in there...

 

Could i do something like this? ----- ALSO THIS NEEDS TO BE CASE IN-SENSITIVE

 

$query = "SELECT * FROM products WHERE availability ='A' AND instr(['search_terms'],'test')<>0";

 

[DeanWhitehouse]

So you want to get all the records that have the a certain word any where in them like?

tester has the word test in it

or

i am a tester testing this test has the word test in it once?

If the latter then you can use the SQL clause LIKE

 

[flyhoney]

Maybe you should look into using "LIKE".

 

<?php
$query = "SELECT * FROM products WHERE availability ='A' AND description LIKE '%".mysql_real_escape_string($product_description)."%'";
?>

[revraz]

FYI, by default, it is.

 

 

ALSO THIS NEEDS TO BE CASE IN-SENSITIVE

 

 

[fonecave]

Thanks matey,

 

Ill give it a go and see if it does the job! Thanks