I need help with a SQL query

vigour

I'm sending a query to mySQL. It looks like this:

$result = mysql_query("SELECT * FROM products WHERE verksamhet LIKE '$motivkategori1' OR grupportratt LIKE '$motivkategori2' OR landskap LIKE '$motivkategori3' OR foremal LIKE '$motivkategori4' OR portratt LIKE '$motivkategori5' OR stadsvy LIKE '$motivkategori6' OR byggnad LIKE '$motivkategori7'");

That gives me the right rows. No problem so far.

But I want to extend this so I only get the rows for a certain artist. Where do I put the $artist string in my query to do that?

cgraz

SELECT * FROM PRODUCTS WHERE artist = $artist AND ( remaining conditions here )

vigour

You mean like this?

$result = mysql_query("SELECT * FROM products WHERE artist LIKE $artist AND (verksamhet LIKE '$motivkategori1' OR grupportratt LIKE '$motivkategori2' OR landskap LIKE '$motivkategori3' OR foremal LIKE '$motivkategori4' OR portratt LIKE '$motivkategori5' OR stadsvy LIKE '$motivkategori6' OR byggnad LIKE '$motivkategori7')");

cgraz

yeah that should work. Have you tried it?

vigour

cgraz wrote:
yeah that should work. Have you tried it?

Yes I have tried it now and it does not work, it gives me no rows.

cgraz

Try this

$strSQL = "SELECT * FROM products WHERE artist LIKE '%" . $artist . "%' AND (verksamhet LIKE '%" . $motivkategori1 . "%' OR grupportratt LIKE  '%" . $motivkategori2 . "%' OR landskap LIKE  '%" . $motivkategori3 . "%' OR foremal LIKE  '%" . $motivkategori4 . "%' OR portratt LIKE '%" . $motivkategori5 . "%' OR stadsvy LIKE '%" . $motivkategori6 . "%' OR byggnad LIKE '%" . $motivkategori7 . "%')"; 

$result = mysql_query( $strSQL) or die( mysql_error( ) );
print "Query String: " . $strSQL;

There may be a parse error somewhere, but otherwise, give it a try and see what it returns. This should be much more useful then just running the query.