aasmith26 Posted April 4, 2009 Share Posted April 4, 2009 Hello folks, trying to figure this out, it is not working. I am trying to display data in two tables, sorted by status. I am running two queries, and my results continue ($i++) til there are no more results for each query. I am making sure to do mysql_close(); at the end of each query, however, it does not display data in the 2nd table. Only the first, it seems like the server is only sending results for the first query. It's really aggrivating, hahaha. $query="SELECT * FROM help WHERE Status='Done. See notes.'"; // Notice $queryA $querya="SELECT * FROM help WHERE Status='PreDiagnosis' OR Status='Acknowledged'"; //Notice $queryB What is the problem??? Thanks guys for your input. Link to comment https://forums.phpfreaks.com/topic/152489-cannot-execute-double-queries/ Share on other sites More sharing options...
fenway Posted April 4, 2009 Share Posted April 4, 2009 Huh? That makes no sense -- are you actually executing all of them separately? And why have separate queries anyway? Link to comment https://forums.phpfreaks.com/topic/152489-cannot-execute-double-queries/#findComment-800886 Share on other sites More sharing options...
xtopolis Posted April 4, 2009 Share Posted April 4, 2009 On top of what fenway said, having the status as actual text will slow things down. If they are canned responses, why not use a numerical value stored in another table? (create a "status" table with things like id:1 text: done. see notes ... id:2 text: prediagnosis.. etc) Link to comment https://forums.phpfreaks.com/topic/152489-cannot-execute-double-queries/#findComment-800893 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.