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. 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 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? 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. 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. 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? 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
Archived
This topic is now archived and is closed to further replies.