serio

Seriously? D: ehhh.

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?

fixed that problem

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.

Let's say I wanted the user to be able to choose ASC or DESC Could i do this with this code? <? $sort = $_REQUEST['sort']; // Gets the id of the shop from the URL. Ex: http://localhost/lols.php?id=1337 $shop would be equal to 1337 $sql = "SELECT * FROM avatars ORDER BY rdate"; $query = mysql_query($sql); echo error_reporting(E_ALL); $i = 0; if($sort) == "ASC" { $sql .= " ASC LIMIT 0, 10"; } else { $sql .= " DESC LIMIT 0, 10"; } } while($results = mysql_fetch_array($query)) { if($i == 0) { echo ""; } $desc = $results['desc']; $id = $results['id']; $category = $results['category']; $cost = $results['cost']; $name = $results['name']; $image = $results['image']; $release = $results['rdate']; echo "<div class='abox2'><div class='aheader2'>$name</div><div class='acontent2'><table border='0' cellpadding='5' cellspacing='1'><tr><td><a href=javascript:openpopup('avatars/avatars.php?id=$id')><img src='$image' border='0'></a></td><td valign='top'><a href=javascript:openpopup('avatars/avatars.php?id=$id')>$name - (click here for solution)</a></td></tr></table></div></div>"; $i++; if($i == 4) { echo ""; $i = 0; } } echo ""; ?> i've never done this before and I know the "=" or "==" on line 25 gives an error. but if i wanted it to be like index.php?page=avatars/index&=sort=ASC it would display ASC and if it was DESC it would display DESC

It works fine Thank you so much!

alright, I can try that.

Using echo error_reporting(E_ALL); the error seems to be 6135

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'release DESC LIMIT 0, 10' at line 1 <h1>Avatar Directory</h1> <br> Here you can find all of the avatars that have been released to date. You can sort them by release date or category. More functions and features will be added soon. <br> <br> Note: Avatar Information pops-up in a new window. <br> <br> <a href="">Newest</a> | <a href="">Battledome</a> | <a href="">Clickables</a> | <a href="">Items</a> | <a href="">Pets/Petpets</a> | <a href="">Other</a> | <a href="">Retired</a> | <br> <br> <? mysql_connect("localhost", "MY USER", "MYPASS"); mysql_select_db("MYDB"); ?> <? $id = $_REQUEST['id']; // Gets the id of the shop from the URL. Ex: http://localhost/lols.php?id=1337 $shop would be equal to 1337 $sql = "SELECT * FROM avatars ORDER BY release DESC LIMIT 0, 10"; $query = mysql_query($sql); echo mysql_error(); $i = 0; while($results = mysql_fetch_array($query)) { if($i == 0) { echo ""; } $desc = $results['desc']; $id = $results['id']; $category = $results['category']; $cost = $results['cost']; $name = $results['name']; $image = $results['image']; $release = $results['release']; echo "<div class='abox2'><div class='aheader2'>$name</div><div class='acontent2'><table border='0' cellpadding='5' cellspacing='1'><tr><td><a href=javascript:openpopup('/avatars/avatars.php?id=$id')><img src='$image' border='0'></a></td><td valign='top'><a href=javascript:openpopup('avatars/avatars.php?id=$id')>$name - (click here for solution)</a></td></tr></table></div></div>"; $i++; if($i == 4) { echo ""; $i = 0; } } echo ""; ?>

Even with that, it still gives the error.

I am trying to order a list by the row "release" which is a DATE row. But when I use: $sql = "SELECT * FROM avatars ORDERBY release DESC LIMIT 0, 10"; I get: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home3/XXXXXXXX/public_html/XXXXXXX/avatars/index.php on line 24 i've tried everything!