Deivas Posted March 12, 2010 Share Posted March 12, 2010 For example I have: $data123 = mysql_query("SELECT * FROM servers WHERE type = '$type' LIMIT $offset, $rowsPerPage") or die(mysql_error()); If the type is not selected nothing prints out. What can I do to make it if nothing is selected all results print out? Quote Link to comment https://forums.phpfreaks.com/topic/195054-you-have-an-error/ Share on other sites More sharing options...
schilly Posted March 12, 2010 Share Posted March 12, 2010 like what? Quote Link to comment https://forums.phpfreaks.com/topic/195054-you-have-an-error/#findComment-1025348 Share on other sites More sharing options...
Deivas Posted March 12, 2010 Author Share Posted March 12, 2010 I fixed it all. Thanks for all your help Quote Link to comment https://forums.phpfreaks.com/topic/195054-you-have-an-error/#findComment-1025350 Share on other sites More sharing options...
Deivas Posted March 12, 2010 Author Share Posted March 12, 2010 For example I have: $data123 = mysql_query("SELECT * FROM servers WHERE type = '$type' LIMIT $offset, $rowsPerPage") or die(mysql_error()); If the type is not selected nothing prints out. What can I do to make it if nothing is selected all results print out? FIXED. Quote Link to comment https://forums.phpfreaks.com/topic/195054-you-have-an-error/#findComment-1025354 Share on other sites More sharing options...
Maq Posted March 12, 2010 Share Posted March 12, 2010 Your WHERE clause is invalid, please read the manual for proper syntax. Quote Link to comment https://forums.phpfreaks.com/topic/195054-you-have-an-error/#findComment-1025355 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.