[SOLVED] Possible Syntax Error in Query

[Bopo]

Hey

 

I have wrote this query for php, however I am not sure if its valid to use so many clauses, or possibly I might have a syntax error, I have tried a few different things such as double quotes around the varible, and percentage signs but no luck so far, help appreciated.

 

$cartype = "BMW 1 Series";
$result = mysql_query("SELECT * FROM cardata WHERE model LIKE = '$cartype' LIMIT 1");

[rhodesa]

depends...do you want it to be an exact match? so the 'model' field is equal to the string in $cartype? if so, use:

$cartype = "BMW 1 Series";
$result = mysql_query("SELECT * FROM cardata WHERE model = '$cartype' LIMIT 1");

 

LIKE should be used when you want to (for instance) find all the models with BMW in the name:

$cartype = "BMW";
$result = mysql_query("SELECT * FROM cardata WHERE model LIKE '%$cartype%'");

[Bopo]

Hi and thanks for you help

 

The Model column doesn't have 'BMW 1 Series' on its own anywhere, and this applies to all the other vechiles within it, for example

 

BMW 1 Series 2dr coupe

BMW 1 Series 2dr convertible

BMW 1 Series 3dr hatchback

BMW 1 Series 5dr hatchback

 

 

So I would like the query to retrive the first record it finds with the words 'BMW 1 Series' within the Model column, I know this might seen vague, but this would be suitable for what I am doing.

 

Cheers

[Maq]

$cartype = "BMW 1 Series";
$result = mysql_query("SELECT * FROM cardata WHERE model LIKE '%$cartype%' LIMIT 1");

[rhodesa]

leave the % off the front of the string if you don't need a wildcard there...

$cartype = "BMW 1 Series";
$result = mysql_query("SELECT * FROM cardata WHERE model LIKE '$cartype%' LIMIT 1");

[Maq]

leave the % off the front of the string if you don't need a wildcard there...

$cartype = "BMW 1 Series";
$result = mysql_query("SELECT * FROM cardata WHERE model LIKE '$cartype%' LIMIT 1");

 

Thanks rhodesa 

[Bopo]

Works perfectly, cheers