wattsup88 Posted January 6, 2007 Share Posted January 6, 2007 what is the correct way of stating this query?[code]SELECT * FROM jobs WHERE (jbcategory = '$value' AND jbstate = '$value1') AND (jbdateexpire > CURRENT_DATE()) ORDER BY $sortby LIMIT $from, $max_results[/code] Link to comment https://forums.phpfreaks.com/topic/33132-solved-mysql-query/ Share on other sites More sharing options...
ToonMariner Posted January 6, 2007 Share Posted January 6, 2007 providing all your field names are correct, variables are set and the string is double quoted then that shoudl be fine - you can even lose the braces.I personally place `` around table and field names it helps both you and the server a little but other wise there is nothing glaringly wrong with that query. Link to comment https://forums.phpfreaks.com/topic/33132-solved-mysql-query/#findComment-154381 Share on other sites More sharing options...
wattsup88 Posted January 6, 2007 Author Share Posted January 6, 2007 Thanks for the "little thing here and there" advice... i kept getting an error that i thought was related to that line but really wasn't... Link to comment https://forums.phpfreaks.com/topic/33132-solved-mysql-query/#findComment-154386 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.