kvnirvana Posted November 21, 2010 Share Posted November 21, 2010 When I use this query $sql1="select * from fagudtryk_muskler where latinsk like \"$trimmed%\" order by latinsk UNION ALL select * from fagudtryk_knogler where latinsk like \"$trimmed%\" order by latinsk"; //-run the query against the mysql query function $result=mysql_query($sql1); //-count results $numrows=mysql_num_rows($result); I get this error Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given How can I fix this? Quote Link to comment Share on other sites More sharing options...
BlueSkyIS Posted November 21, 2010 Share Posted November 21, 2010 check for errors when you run the query: $result=mysql_query($sql1) or die(mysql_error() . " IN $sql1"); Quote Link to comment Share on other sites More sharing options...
kvnirvana Posted November 21, 2010 Author Share Posted November 21, 2010 I get this error Incorrect usage of UNION and ORDER BY IN select * from fagudtryk_muskler where latinsk like "g%" order by latinsk UNION ALL select * from fagudtryk_knogler where latinsk like "g%" order by latinsk Quote Link to comment Share on other sites More sharing options...
BlueSkyIS Posted November 21, 2010 Share Posted November 21, 2010 yes: Incorrect usage of UNION and ORDER BY Quote Link to comment Share on other sites More sharing options...
kvnirvana Posted November 21, 2010 Author Share Posted November 21, 2010 I think I should do it this way instead $sql1="SELECT * FROM kasper.fagudtryk_muskler LEFT OUTER JOIN kasper.fagudtryk_knogler ON fagudtryk_muskler.latinsk or fagudtryk_knogler.latinsk like \"$trimmed%\" "; I don't think I can do like this "fagudtryk_muskler.latinsk or fagudtryk_knogler.latinsk" So how should I do it? I want it to say 'where fagudtryk_muskler.latinsk or fagudtryk_knogler.latinsk is like the word searched for' Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.