djfox

Sorry to keep bothering but I`m still learning about php. <?php include("dbcon.php"); include("func.php"); require_once "auth.php"; require_once "includes/defines.php"; if (!isLoggedIn()) { Redirect("index.php"); } $log = $_SESSION['sess_name']; $res3 = mysql_query("Select id,echo_count FROM userdata WHERE id='$s''")or die( mysql_error() ); $sel = mysql_fetch_row($res3); mysql_free_result($res3); if ($_SESSION['echos'] >= $p) { $_SESSION['echos'] = $echos = $echos - $p; mysql_query("UPDATE userdata SET echo_count = $echos WHERE login = '".$log."' ") or die(mysql_error()); mysql_query("UPDATE coll_inven SET user='$log' WHERE id=$id"); mysql_query("INSERT INTO coll_inven (user,item,price) VALUES ( '$log', '$id', '$pr' )"); mysql_query("DELETE FROM coll_sell WHERE id=$id"); } header("Location: vendor_grovepark.php"); else { header("Location: vendor_grovepark.php?alert=noechos"); } ?> I know the code is incomplete. I`m stumped with something. I have in there to take currency (echos) from the echo_count of the logged in person buying the item. How do I add this number to the seller? I have in the query to call on the seller`s info, but how do I get $p added to the seller`s echos? I`m basically looking for $p added to $sel[1] a simple math thing to add $p to whatever number is already in $sel[1]

Oh goodness. It`s always the simple things that slip past me. That did the trick. Thanks for the big help guys.

You mean " )" needs to entered somewhere in that line?

frost110 Putting in your code, the page is blank with just this message: Parse error: syntax error, unexpected T_BOOLEAN_AND, expecting ',' or ')' in /home/secrett1/public_html/testing/vendor_grovepark.php on line 99 Line 99 is: if (isset($_GET['alert'] && $_GET['alert'] == "noechos") {

These pop up: Notice: Undefined index: alert in /home/secrett1/public_html/testing/vendor_grovepark.php on line 101 Notice: Undefined variable: offset in /home/secrett1/public_html/testing/vendor_grovepark.php on line 107 Warning: mysql_fetch_row(): 22 is not a valid MySQL result resource in /home/secrett1/public_html/testing/vendor_grovepark.php on line 111 Line 101 if ($_GET['alert'] == "noechos") { Line 107 if(!$offset) $offset=0; Line 111 while( $row = mysql_fetch_row($res) ){

<? if ($_GET['alert'] == "noechos") { echo "<script language=\"javascript\" type=\"text/javascript\"> alert(\"You don't have enough echos for this!\"); </script>"; } if(!$offset) $offset=0; $recent = 0; $res = mysql_query("Select id,seller,item,sellprice,price,sellerid FROM coll_sell ORDER BY id DESC")or die( mysql_error() ); echo ""; while( $row = mysql_fetch_row($res) ){ if( $recent >= $offset && $recent < ($offset + 25 )){ if( $recent%1 == 0 ){ echo "<tr><td bgcolor='312D37'><td bgcolor='312D37'><td bgcolor='312D37'><td bgcolor='312D37'><tr>"; } ?> <? $res = mysql_query("SELECT id, name, description, url, price, preview FROM collection WHERE id='$row[2]'"); $item = mysql_fetch_row($res); mysql_free_result($res); ?> <td><img src="stamps/<? echo "$item[6]" ?>"> <? echo "$item[1]" ?> <td><a href="trancer.php?g=<? echo"$row[5]" ?>"><? echo "$row[1]" ?></a> <td><? echo "$row[3]" ?> Echos <td><a href="sellbuy.php?id=<? echo "$row[0]" ?>&p=<? echo "$row[3]" ?>&pr=<? echo "$row[4]" ?>">Buy</a> <? } $recent = $recent + 1; } echo ""; ?> All the information is properly displaying. However, after all the displayed information, I get this error message: Warning: mysql_fetch_row(): 22 is not a valid MySQL result resource in /home/secrett1/public_html/testing/vendor_grovepark.php on line 109 And, it only lists one item. It will not list the other items in the coll_sell table. Line 109 is this line: while( $row = mysql_fetch_row($res) ){ Why is this error coming up? What can I do to fix it?

Thank you very much!

Here`s what I have for my code: <? $res = mysql_query("SELECT subject,content,date,id,sender FROM artistcomment WHERE userID=$gall ORDER BY id DESC"); while($r = mysql_fetch_row($res) ) $comments[] = $r; if ($comments) foreach($comments as $c){ ?> <? $res = mysql_query("SELECT id, icon FROM userdata WHERE id='$c[4]'"); $comico = mysql_fetch_row($res); mysql_free_result($res); ?> <table border=0 width=100%> <tr> <td> <tr> <td> <table border=0 width=100% bgcolor="000000"> <tr><td bgcolor="312D37" colspan=2><a href="trancer.php?g=<? echo $c[4] ?>"><img src="<? echo "$comico[1]" ?>" border=0 height=50 width=50><a href="trancer.php?g=<? echo $c[4] ?>"><? echo $c[0] ?></a> Date: <? echo $c[2] ?> #<a href="comment.php?id=<? echo $c[3] ?>"><? echo $c[3] ?></a> <tr><td colspan=2 bgcolor="4A4553"><? echo $c[1] ?> </table> </table> <? } ?> How do tell the code to show just the latest 10 comments? At the moment it will list every single one. And, after a while that will be too much to scroll though. So how can I put the limit to 10?

Ah that`s what it was. I was calling the price value from the wrong table. Thanks much.

Hm, ok, it must be something elsewhere in the code then. I`ll check over the whole file and see what I can find. Thanks for checking it over.

No error message appears.

Here is my code: $res = mysql_query("SELECT id, name, description, url, price, preview FROM collection WHERE id='$c[2]'"); $comico = mysql_fetch_row($res); mysql_free_result($res); { echo "<a href='sell7.php?id=$comico[0]&p=$comico[4]'>"; echo "<img src='collection/$comico[5]' border=0></a>"; } Here is my problem: $comico[0] and $comico[5] appear fine but $comico[4] is not showing up. Can someone look me over and see if I messed up somewhere?

My god, I feel incredibly stupid now. But I`m so glad you were able to point that out to me. (Having another set of eyes always helps!) Thanks a lot!

The same thing occurs. id is sent but not p.

I have links set up as thus: explore7.php?id=7&p=4 Where when the link is clicked on, id will always be 7 and p will always be 4. id is being sent fine but p isn`t. How can I get p sent? Here`s ex_thereefs.php: <? $option = "link"; $sites[0] = array("javascript:location.reload()", "</a>You found nothing.<p><a href='javascript:location.reload()'>Keep Searching</a>", 10); $sites[1] = array("explore7.php?id=1&p=4", "</a>You Found a Dark Blue Shell! Click the image to add it to your inventory.<br><a href='explore7.php?id=1'><img src='collection/darkblueshell.png' border=0></a><p><a href='javascript:location.reload()'>Keep Exploring.</a>", 4); $sites[2] = array("explore7.php?id=2&p=1", "</a>You Found a Light Blue Shell! Click the image to add it to your inventory.<br><a href='explore7.php?id=2'><img src='collection/lightblueshell.png' border=0></a><p><a href='javascript:location.reload()'>Keep Exploring.</a>", 9); $sites[3] = array("explore7.php?id=4&p=1", "</a>You Found a Light Purple Shell! Click the image to add it to your inventory.<br><a href='explore7.php?id=4'><img src='collection/lightpurpleshell.png' border=0></a><p><a href='javascript:location.reload()'>Keep Exploring.</a>", ; $sites[4] = array("explore7.php?id=3&p=4", "</a>You Found a Dark Purple Shell! Click the image to add it to your inventory.<br><a href='explore7.php?id=3'><img src='collection/darkpurpleshell.png' border=0></a><p><a href='javascript:location.reload()'>Keep Exploring.</a>", 4); $sites[5] = array("explore7.php?id=5&p=5", "</a>You Found a Dark Red Shell! Click the image to add it to your inventory.<br><a href='explore7.php?id=5'><img src='collection/darkredshell.png' border=0></a><p><a href='javascript:location.reload()'>Keep Exploring.</a>", 3); $sites[6] = array("explore7.php?id=6&p=2", "</a>You Found a Light Red Shell! Click the image to add it to your inventory.<br><a href='explore7.php?id=6'><img src='collection/lightredshell.png' border=0></a><p><a href='javascript:location.reload()'>Keep Exploring.</a>", 7); $sites[7] = array("javascript:location.reload()", "</a>You found nothing.<p><a href='javascript:location.reload()'>Keep Searching</a>", 10); $sites[8] = array("javascript:location.reload()", "</a>You found nothing.<p><a href='javascript:location.reload()'>Keep Searching</a>", 10); $sites[9] = array("javascript:location.reload()", "</a>You found nothing.<p><a href='javascript:location.reload()'>Keep Searching</a>", 10); $sites[10] = array("javascript:location.reload()", "</a>You found nothing.<p><a href='javascript:location.reload()'>Keep Searching</a>", 10); $sites[11] = array("explore7.php?id=7&p=4", "</a>You Found a Dark Green Shell! Click the image to add it to your inventory.<br><a href='explore7.php?id=7'><img src='collection/darkgreenshell.png' border=0></a><p><a href='javascript:location.reload()'>Keep Exploring.</a>", 4); $sites[12] = array("explore7.php?id=8&p=2", "</a>You Found a Light Green Shell! Click the image to add it to your inventory.<br><a href='explore7.php?id=8'><img src='collection/lightgreenshell.png' border=0></a><p><a href='javascript:location.reload()'>Keep Exploring.</a>", ; $sites[13] = array("javascript:location.reload()", "</a>You found nothing.<p><a href='javascript:location.reload()'>Keep Searching</a>", 10); $sites[14] = array("explore7.php?id=9&p=6", "</a>You Found a Black Shell! Click the image to add it to your inventory.<br><a href='explore7.php?id=9'><img src='collection/blackshell.png' border=0></a><p><a href='javascript:location.reload()'>Keep Exploring.</a>", 3); $sites[15] = array("javascript:location.reload()", "</a>You found nothing.<p><a href='javascript:location.reload()'>Keep Searching</a>", 10); $sites[16] = array("javascript:location.reload()", "</a>You found nothing.<p><a href='javascript:location.reload()'>Keep Searching</a>", 10); $sites[17] = array("javascript:location.reload()", "</a>You found nothing.<p><a href='javascript:location.reload()'>Keep Searching</a>", 10); $sites[18] = array("explore7.php?id=10&p=10", "</a>You Found a Gold Shell! Click the image to add it to your inventory.<br><a href='explore7.php?id=10'><img src='collection/goldshell.png' border=0></a><p><a href='javascript:location.reload()'>Keep Exploring.</a>", 1); $sites[19] = array("explore7.php?id=11&p=10", "</a>You Found a Silver Shell! Click the image to add it to your inventory.<br><a href='explore7.php?id=11'><img src='collection/silvershell.png' border=0></a><p><a href='javascript:location.reload()'>Keep Exploring.</a>", 1); $sites[20] = array("explore7.php?id=2&p=1", "</a>You Found a Light Blue Shell! Click the image to add it to your inventory.<br><a href='explore7.php?id=2'><img src='collection/lightblueshell.png' border=0></a><p><a href='javascript:location.reload()'>Keep Exploring.</a>", 9); $sites[21] = array("explore7.php?id=4&p=1", "</a>You Found a Light Purple Shell! Click the image to add it to your inventory.<br><a href='explore7.php?id=4'><img src='collection/lightpurpleshell.png' border=0></a><p><a href='javascript:location.reload()'>Keep Exploring.</a>", ; $sites[22] = array("explore7.php?id=6&p=2", "</a>You Found a Light Red Shell! Click the image to add it to your inventory.<br><a href='explore7.php?id=6'><img src='collection/lightredshell.png' border=0></a><p><a href='javascript:location.reload()'>Keep Exploring.</a>", 7); $sites[23] = array("explore7.php?id=8&p=2", "</a>You Found a Light Green Shell! Click the image to add it to your inventory.<br><a href='explore7.php?id=8'><img src='collection/lightgreenshell.png' border=0></a><p><a href='javascript:location.reload()'>Keep Exploring.</a>", ; $sites[24] = array("javascript:location.reload()", "</a>You found nothing.<p><a href='javascript:location.reload()'>Keep Searching</a>", 10); $sites[25] = array("javascript:location.reload()", "</a>You found nothing.<p><a href='javascript:location.reload()'>Keep Searching</a>", 10); $countsites = count($sites); for($i=0; $i<$countsites; $i++) { for($x=0; $x<$sites[$i][2]; $x++) { if($option != null) { $mylist[] = array($sites[$i][0],$sites[$i][1],$sites[$i][3]); } else { echo("Error deciding option."); exit(); } } } $countlist = count($mylist); $countlist = $countlist - 1; $picker = rand(0, $countlist); if($option == "link") { echo("<a href='" . $mylist[$picker][0] . "'>" . $mylist[$picker][1] . "</a>"); } else if($option == "banner") { echo("<a href='" . $mylist[$picker][0] . "'><img alt='" . $mylist[$picker][1] . "' src='" . $mylist[$picker][2] . "' /></a>"); } else { echo("Error deciding option."); exit(); } ?> Here is explore7.php: <? include("dbcon.php"); include("func.php"); require_once "auth.php"; require_once "includes/defines.php"; $log = $_SESSION['sess_name']; mysql_query("INSERT INTO coll_inven (user,item,price) VALUES ( '$log', '$id', '$p' )"); header("Location: ex_thereefs.php"); ?>

I figured out how to do it. I feel really stupid since it was just so simple any easy to do. The code ended up being: <? $res = mysql_query("SELECT subject,content,date,id,sender FROM comment WHERE imageID=$id ORDER BY id DESC"); while($r = mysql_fetch_row($res) ) $comments[] = $r; if ($comments) foreach($comments as $c){ ?> <? $res = mysql_query("SELECT id, icon FROM userdata WHERE id='$c[4]'"); $comico = mysql_fetch_row($res); mysql_free_result($res); ?> <table border=0 width=100%> <tr> <td> <tr> <td> <table border=0 width=100% bgcolor="000000"> <tr><td bgcolor="312D37" colspan=2><img src="<? echo "$comico[1]" ?>"><a href="trancer.php?g=<? echo $c[4] ?>"><? echo $c[0] ?></a> Date: <? echo $c[2] ?> #<a href="comment.php?id=<? echo $c[3] ?>"><? echo $c[3] ?></a> <tr><td colspan=2 bgcolor="4A4553"><? echo $c[1] ?> </table> </table> <? } ?>

Ok, I have this system setup where for a submission put on the server, registered users can comment on it. I`ve tried repeatedly trying to get the thing to display icons from userdata with each comment. I`ll let my code speak for itself. These two sections of code I`m displaying are from the file trances.php. I`m not displaying each every piece of the code because I feel most of it is not necessary to show because they are unrelated to the problem. <? $lev=$_SESSION['level2']; $res = mysql_query("SELECT id,name,gallNum,URL,rating,numRates,description,views,cat,addDate, feature, literature, favnum, nomi, keyw FROM image WHERE id=$id"); $rows = mysql_fetch_row($res); mysql_free_result($res); if($submit){ $s = $sub." by ".$name; $b= emote($bod); mysql_query("INSERT INTO comment (imageID,subject,content,date,sender) VALUES ( '$id', '$s', '$b', NOW(),$send)")or die ( mysql_error()); $_SESSION['echos'] = $echos = $echos + 10; mysql_query("UPDATE userdata SET echo_count = $echos WHERE login = '".$log."' ") or die(mysql_error()); mysql_query("INSERT INTO messagedata (recBoxID, sendBoxID, content, subject, isNew, date) VALUES ($rows[2], '1', 'You have a new comment on one of your trances that you have submitted.<br><a href=trances.php?id=$id>Click here to read the comment</a>.<br>This is automated message please do not reply.', 'New Comment!', 1, NOW() )"); } if($policy && ($lev>6)){ mysql_query("UPDATE userdata SET violations=SUM(violations,1) WHERE login='$name'"); } $res = mysql_query("SELECT login FROM userdata WHERE id='$rows[2]'"); $by = mysql_fetch_row($res); mysql_free_result($res); $res = mysql_query("SELECT icon FROM userdata WHERE id='$rows[2]'"); $icon = mysql_fetch_row($res); mysql_free_result($res); $res = mysql_query("SELECT name, id FROM imagecats WHERE id=$rows[8]"); $catName = mysql_fetch_row($res); mysql_free_result($res); $res = mysql_query("SELECT COUNT(*) FROM comment WHERE imageID='$id'"); $numCom = mysql_fetch_row($res); mysql_free_result($res); //Update unique pageview counter if( !$_SESSION["sess_$id"] ){ $_SESSION["sess_$id"] = "visited"; $v = $rows[7] + 1; mysql_query("UPDATE image SET views=$v WHERE id='$id'"); } ?> And in the same file we have: <? $res = mysql_query("SELECT subject,content,date,id,sender FROM comment WHERE imageID=$id ORDER BY id DESC"); while($r = mysql_fetch_row($res) ) $comments[] = $r; if ($comments) foreach($comments as $c){ ?> <table border=0 width=100%> <tr> <td> <tr> <td> <table border=0 width=100% bgcolor="000000"> <tr><td bgcolor="312D37" colspan=2><a href="trancer.php?g=<? echo $c[4] ?>"><? echo $c[0] ?></a> Date: <? echo $c[2] ?> #<a href="comment.php?id=<? echo $c[3] ?>"><? echo $c[3] ?></a> <tr><td colspan=2 bgcolor="4A4553"><? echo $c[1] ?> </table> </table> <? } ?> sender has the id number of the person who makes the comment. Clicking on their name will take you to their profile. What I`m looking for is that the icon from userdata will appear with the person. userdata id should equal to sender from comment How is this accomplished? I`m totally stumped.

What do you mean by efficiently?

Someone contacted me off forum and gave me this little piece: sort($favs); I put that in and that did the trick.

Array ( [0] => 1 [1] => Dark Blue Shell [2] => A dark blue shell found at the sea floor of the reefs at the edge of Pacinity. [3] => darkblueshell.png [4] => 7 [5] => [6] => darkblueshell_pre.png ) Array ( [0] => 1 [1] => Dark Blue Shell [2] => A dark blue shell found at the sea floor of the reefs at the edge of Pacinity. [3] => darkblueshell.png [4] => 7 [5] => [6] => darkblueshell_pre.png ) Array ( [0] => 2 [1] => Light Blue Shell [2] => A light blue shell found in the reefs near Pacinity. [3] => lightblueshell.png [4] => 7 [5] => [6] => lightblueshell_pre.png ) Array ( [0] => 2 [1] => Light Blue Shell [2] => A light blue shell found in the reefs near Pacinity. [3] => lightblueshell.png [4] => 7 [5] => [6] => lightblueshell_pre.png ) Array ( [0] => 2 [1] => Light Blue Shell [2] => A light blue shell found in the reefs near Pacinity. [3] => lightblueshell.png [4] => 7 [5] => [6] => lightblueshell_pre.png ) Array ( [0] => 2 [1] => Light Blue Shell [2] => A light blue shell found in the reefs near Pacinity. [3] => lightblueshell.png [4] => 7 [5] => [6] => lightblueshell_pre.png ) Array ( [0] => 4 [1] => Light Purple Shell [2] => A shell found on the sea floor in the reefs near Pacinity. [3] => lightpurpleshell.png [4] => 7 [5] => [6] => lightpurpleshell_pre.png ) Array ( [0] => 1 [1] => Dark Blue Shell [2] => A dark blue shell found at the sea floor of the reefs at the edge of Pacinity. [3] => darkblueshell.png [4] => 7 [5] => [6] => darkblueshell_pre.png ) Array ( [0] => 2 [1] => Light Blue Shell [2] => A light blue shell found in the reefs near Pacinity. [3] => lightblueshell.png [4] => 7 [5] => [6] => lightblueshell_pre.png ) Array ( [0] => 2 [1] => Light Blue Shell [2] => A light blue shell found in the reefs near Pacinity. [3] => lightblueshell.png [4] => 7 [5] => [6] => lightblueshell_pre.png )

I just posted it in my post.

There is no need to insult me or talk that way to me when you have volunteered to help me. Apparently I didn`t get what you saying until just a moment ago. (I couldn`t even post the whole thing because the forum says it`s too big): Array ( [0] => 1 [1] => Dark Blue Shell [2] => A dark blue shell found at the sea floor of the reefs at the edge of Pacinity. [3] => darkblueshell.png [4] => 7 [5] => [6] => darkblueshell_pre.png )

The only other way I can think to show you the output is this: <table border=0> <tr><td><a href=collectionview.php?id=1><img src='collection/darkblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=1><img src='collection/darkblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=1><img src='collection/darkblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=3><img src='collection/darkpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=3><img src='collection/darkpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=3><img src='collection/darkpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=1><img src='collection/darkblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=1><img src='collection/darkblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=3><img src='collection/darkpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><tr><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=3><img src='collection/darkpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=3><img src='collection/darkpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=3><img src='collection/darkpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=3><img src='collection/darkpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=5><img src='collection/darkredshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><tr><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=1><img src='collection/darkblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=3><img src='collection/darkpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=5><img src='collection/darkredshell_pre.png' border=0></a><td><a href=collectionview.php?id=3><img src='collection/darkpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=5><img src='collection/darkredshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><tr><td><a href=collectionview.php?id=5><img src='collection/darkredshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=5><img src='collection/darkredshell_pre.png' border=0></a><td><a href=collectionview.php?id=6><img src='collection/lightredshell_pre.png' border=0></a><td><a href=collectionview.php?id=6><img src='collection/lightredshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=6><img src='collection/lightredshell_pre.png' border=0></a><td><a href=collectionview.php?id=1><img src='collection/darkblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=3><img src='collection/darkpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=5><img src='collection/darkredshell_pre.png' border=0></a><td><a href=collectionview.php?id=3><img src='collection/darkpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=5><img src='collection/darkredshell_pre.png' border=0></a><td><a href=collectionview.php?id=3><img src='collection/darkpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=1><img src='collection/darkblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=6><img src='collection/lightredshell_pre.png' border=0></a><td><a href=collectionview.php?id=5><img src='collection/darkredshell_pre.png' border=0></a><tr><td><a href=collectionview.php?id=6><img src='collection/lightredshell_pre.png' border=0></a><td><a href=collectionview.php?id=6><img src='collection/lightredshell_pre.png' border=0></a><td><a href=collectionview.php?id=3><img src='collection/darkpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=5><img src='collection/darkredshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=1><img src='collection/darkblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=5><img src='collection/darkredshell_pre.png' border=0></a><td><a href=collectionview.php?id=3><img src='collection/darkpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=1><img src='collection/darkblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=5><img src='collection/darkredshell_pre.png' border=0></a><td><a href=collectionview.php?id=5><img src='collection/darkredshell_pre.png' border=0></a><td><a href=collectionview.php?id=1><img src='collection/darkblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=1><img src='collection/darkblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=3><img src='collection/darkpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=1><img src='collection/darkblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=1><img src='collection/darkblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><tr><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=6><img src='collection/lightredshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=3><img src='collection/darkpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=6><img src='collection/lightredshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=5><img src='collection/darkredshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=7><img src='collection/darkgreenshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=6><img src='collection/lightredshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=8><img src='collection/lightgreenshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=8><img src='collection/lightgreenshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><tr><td><a href=collectionview.php?id=6><img src='collection/lightredshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=1><img src='collection/darkblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=5><img src='collection/darkredshell_pre.png' border=0></a><td><a href=collectionview.php?id=6><img src='collection/lightredshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=1><img src='collection/darkblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=1><img src='collection/darkblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=1><img src='collection/darkblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=1><img src='collection/darkblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=1><img src='collection/darkblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=10><img src='collection/goldshell_pre.png' border=0></a><td><a href=collectionview.php?id=8><img src='collection/lightgreenshell_pre.png' border=0></a><td><a href=collectionview.php?id=1><img src='collection/darkblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=6><img src='collection/lightredshell_pre.png' border=0></a><td><a href=collectionview.php?id=6><img src='collection/lightredshell_pre.png' border=0></a><tr><td><a href=collectionview.php?id=9><img src='collection/blackshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=3><img src='collection/darkpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=9><img src='collection/blackshell_pre.png' border=0></a><td><a href=collectionview.php?id=8><img src='collection/lightgreenshell_pre.png' border=0></a><td><a href=collectionview.php?id=9><img src='collection/blackshell_pre.png' border=0></a><td><a href=collectionview.php?id=6><img src='collection/lightredshell_pre.png' border=0></a><td><a href=collectionview.php?id=5><img src='collection/darkredshell_pre.png' border=0></a><td><a href=collectionview.php?id=6><img src='collection/lightredshell_pre.png' border=0></a><td><a href=collectionview.php?id=6><img src='collection/lightredshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=6><img src='collection/lightredshell_pre.png' border=0></a><td><a href=collectionview.php?id=3><img src='collection/darkpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=6><img src='collection/lightredshell_pre.png' border=0></a><td><a href=collectionview.php?id=7><img src='collection/darkgreenshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=6><img src='collection/lightredshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><tr><td><a href=collectionview.php?id=10><img src='collection/goldshell_pre.png' border=0></a><td><a href=collectionview.php?id=7><img src='collection/darkgreenshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=6><img src='collection/lightredshell_pre.png' border=0></a><td><a href=collectionview.php?id=5><img src='collection/darkredshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=5><img src='collection/darkredshell_pre.png' border=0></a><td><a href=collectionview.php?id=7><img src='collection/darkgreenshell_pre.png' border=0></a><td><a href=collectionview.php?id=9><img src='collection/blackshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=8><img src='collection/lightgreenshell_pre.png' border=0></a><td><a href=collectionview.php?id=3><img src='collection/darkpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=9><img src='collection/blackshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=8><img src='collection/lightgreenshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=8><img src='collection/lightgreenshell_pre.png' border=0></a><tr><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=3><img src='collection/darkpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=8><img src='collection/lightgreenshell_pre.png' border=0></a><td><a href=collectionview.php?id=1><img src='collection/darkblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=8><img src='collection/lightgreenshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=7><img src='collection/darkgreenshell_pre.png' border=0></a><td><a href=collectionview.php?id=1><img src='collection/darkblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=7><img src='collection/darkgreenshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=6><img src='collection/lightredshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=3><img src='collection/darkpurpleshell_pre.png' border=0></a><td><a href=collectionview.php?id=9><img src='collection/blackshell_pre.png' border=0></a><td><a href=collectionview.php?id=1><img src='collection/darkblueshell_pre.png' border=0></a><tr><td><a href=collectionview.php?id=6><img src='collection/lightredshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=5><img src='collection/darkredshell_pre.png' border=0></a><td><a href=collectionview.php?id=8><img src='collection/lightgreenshell_pre.png' border=0></a><td><a href=collectionview.php?id=6><img src='collection/lightredshell_pre.png' border=0></a><td><a href=collectionview.php?id=7><img src='collection/darkgreenshell_pre.png' border=0></a><td><a href=collectionview.php?id=6><img src='collection/lightredshell_pre.png' border=0></a><td><a href=collectionview.php?id=7><img src='collection/darkgreenshell_pre.png' border=0></a><td><a href=collectionview.php?id=2><img src='collection/lightblueshell_pre.png' border=0></a><td><a href=collectionview.php?id=11><img src='collection/silvershell_pre.png' border=0></a><td><a href=collectionview.php?id=9><img src='collection/blackshell_pre.png' border=0></a><td><a href=collectionview.php?id=11><img src='collection/silvershell_pre.png' border=0></a><td><a href=collectionview.php?id=5><img src='collection/darkredshell_pre.png' border=0></a><td><a href=collectionview.php?id=5><img src='collection/darkredshell_pre.png' border=0></a><td><a href=collectionview.php?id=11><img src='collection/silvershell_pre.png' border=0></a><td><a href=collectionview.php?id=9><img src='collection/blackshell_pre.png' border=0></a><td><a href=collectionview.php?id=7><img src='collection/darkgreenshell_pre.png' border=0></a><td><a href=collectionview.php?id=9><img src='collection/blackshell_pre.png' border=0></a><td><a href=collectionview.php?id=4><img src='collection/lightpurpleshell_pre.png' border=0></a><tr><td><a href=collectionview.php?id=11><img src='collection/silvershell_pre.png' border=0></a><td><a href=collectionview.php?id=9><img src='collection/blackshell_pre.png' border=0></a><td><a href=collectionview.php?id=9><img src='collection/blackshell_pre.png' border=0></a><td><a href=collectionview.php?id=9><img src='collection/blackshell_pre.png' border=0></a><td><a href=collectionview.php?id=9><img src='collection/blackshell_pre.png' border=0></a><td><a href=collectionview.php?id=9><img src='collection/blackshell_pre.png' border=0></a><td><a href=collectionview.php?id=10><img src='collection/goldshell_pre.png' border=0></a><td><a href=collectionview.php?id=10><img src='collection/goldshell_pre.png' border=0></a><td><a href=collectionview.php?id=11><img src='collection/silvershell_pre.png' border=0></a><td><a href=collectionview.php?id=9><img src='collection/blackshell_pre.png' border=0></a><td><a href=collectionview.php?id=9><img src='collection/blackshell_pre.png' border=0></a><td><a href=collectionview.php?id=10><img src='collection/goldshell_pre.png' border=0></a><td><a href=collectionview.php?id=7><img src='collection/darkgreenshell_pre.png' border=0></a><td><a href=collectionview.php?id=9><img src='collection/blackshell_pre.png' border=0></a><td><a href=collectionview.php?id=9><img src='collection/blackshell_pre.png' border=0></a><td><a href=collectionview.php?id=5><img src='collection/darkredshell_pre.png' border=0></a><td><a href=collectionview.php?id=10><img src='collection/goldshell_pre.png' border=0></a><td><a href=collectionview.php?id=8><img src='collection/lightgreenshell_pre.png' border=0></a><td><a href=collectionview.php?id=8><img src='collection/lightgreenshell_pre.png' border=0></a><td><a href=collectionview.php?id=9><img src='collection/blackshell_pre.png' border=0></a><tr><td><a href=collectionview.php?id=7><img src='collection/darkgreenshell_pre.png' border=0></a><td><a href=collectionview.php?id=8><img src='collection/lightgreenshell_pre.png' border=0></a><td><a href=collectionview.php?id=8><img src='collection/lightgreenshell_pre.png' border=0></a></table> </table> Unless you mean something else.

I can`t give you a link to the page itself (because you have to be logged in and have entries to the field) but I do have a screenshot made: http://i174.photobucket.com/albums/w120/beloveddoll/screen.jpg

It`s still not ordering them. id is an auto increment int primary.