serio Posted October 10, 2009 Share Posted October 10, 2009 I want a user to be able to specify DESC or ASC int he url like: index.php?page=avatars/index&sort=DESC index.php?page=avatars/index&sort=ASC but I want if sort is blank or not there at all like index.php?page=avatars/index&sort= or index.php?page=avatars/index to display if($sort == "") { $sql .= "ORDER BY rdate DESC LIMIT 0, 10"; } But, i get an error Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home3/bammehco/public_html/jhudorascurse/avatars/index.php on line 36 Line 36 is claling my query, which is the query posted above. Quote Link to comment https://forums.phpfreaks.com/topic/177237-various-help-problems-i-need-help-with-as-i-encounter-them/ Share on other sites More sharing options...
serio Posted October 10, 2009 Author Share Posted October 10, 2009 fixed that problem Quote Link to comment https://forums.phpfreaks.com/topic/177237-various-help-problems-i-need-help-with-as-i-encounter-them/#findComment-934538 Share on other sites More sharing options...
serio Posted October 17, 2009 Author Share Posted October 17, 2009 Another problem: Let's Say I wanted to have multiple values for one field in a table. Like: Seasonal, Items Because the avatar falls under multiple categories. How would I "seperate" those two so it could be called differently? Quote Link to comment https://forums.phpfreaks.com/topic/177237-various-help-problems-i-need-help-with-as-i-encounter-them/#findComment-938796 Share on other sites More sharing options...
fenway Posted October 17, 2009 Share Posted October 17, 2009 You don't -- you create a new record for each pairing. Quote Link to comment https://forums.phpfreaks.com/topic/177237-various-help-problems-i-need-help-with-as-i-encounter-them/#findComment-938869 Share on other sites More sharing options...
serio Posted October 18, 2009 Author Share Posted October 18, 2009 Seriously? D: ehhh. Quote Link to comment https://forums.phpfreaks.com/topic/177237-various-help-problems-i-need-help-with-as-i-encounter-them/#findComment-938956 Share on other sites More sharing options...
fenway Posted October 18, 2009 Share Posted October 18, 2009 What do you have now -- table structure? Show us, and we can show you what to change? Quote Link to comment https://forums.phpfreaks.com/topic/177237-various-help-problems-i-need-help-with-as-i-encounter-them/#findComment-939126 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.