SQL query ?

[developer]

Hello! 🙂

I do have this.

$Query = "SELECT * FROM tabs WHERE artist OR title LIKE '%$search%' AND type = '$type' ORDER BY artist;" or die (mysql_error());

I would like it to find, all rows where type is like '$type' and the artist or title is like '%$search%'

Thanks.

[laserlight]

Could try:

$query = "SELECT * FROM tabs WHERE artist LIKE '%$search%' AND type='$type' ORDER BY artist";

Then you use the "OR die()" part when actually sending the query.

[developer]

This solved the problem 🙂

$Query = "SELECT * FROM tabs WHERE (artist LIKE '%$search%' OR title LIKE '%$search%') AND type = '$type' ORDER BY artist;" or die (mysql_error());

[laserlight]

oh, my mistake, I forgot about the title.

you dont need the or die (mysql_error()) part though

[developer]

Originally posted by laserlight
oh, my mistake, I forgot about the title.

you dont need the or die (mysql_error()) part though

Okey, thanks. 🙂