Retrieving 20 Newest Results

OrionTensi

Ok, I'm trying to make a trading program, but I can't get the script to retrieve the results. There are no apparent errors, so I'm not sure. This is the cody I have:

elseif ($action == "newest20")
 {
  $ti = mysql_query("SELECT * FROM el_inventory, trading WHERE trading.username='$username'  AND el_inventory.itemid= trading.itemid ORDER BY trading.tradetime DESC LIMIT 1,20"); 
  /*$t=mysql_query("SELECT * FROM trading ORDER BY tradetime DESC LIMIT 1,20");
  $tit=mysql_fetch_array($t);
  $ti=mysql_query("SELECT * FROM el_inventory WHERE itemid='$tit[itemid]'");*/
  echo "<table border=1 bordercolor=336699 cellpadding=0 cellspacing=0 align=center>
          <tr align=center>
           <td width=100 align=center>
            <b>Username:</b>
           </td>
           <td width=100 align=center>
            <b>Item:</b>
           </td>
           <td width=100 align=center>
            <b>Message:</b>
           </td>
          </tr>";
  //displays the results
  while ($time = mysql_fetch_array($ti))
  {
if ($time[traderequest] == "") { $traderequest = "No request"; }
else { $traderequest = $time[traderequest]; }
   echo "<tr>
          <td>
           <a href=profile.php?username=$time[username]>$time[username]</a>
          </td>
          <td>
           <a href=trading.php?action=trade&tradeid=$time[tradenumber]>$time[item]</a>
          </td>
          <td>
           $traderequest
          </td>";

  }
 }

It just doesn't display the results on the page.

OrionTensi

Nevermind. I figured it out on my own. But thanks for not paying attention anyways.

pjleonhardt

well thank you for giving us time to come home from our own damn lifes to help you out in yours....

also, thank you for coming into our community and insulting us..

and thank you for posting a question probably after you ran it once and it didnt work, and didnt look at it at all to figure out what was wrong with it in the first place.. Then you finally do take a look at it after you dont get an immediate response from here, and realize how simple of a problem it was.. and then you get all pissy because we didn't see it.

Hmm... it's not like we sit on the boards all day getting paid to help people.. We're here volunteering our knowledge of PHP to those who are actually interested in learning, and perhaps giving back to the community.. I'm sick and tired of people like you, hmm.. theres a board here, ill post my problem. 2 minutes later..
WTF!! NOBODY HAS ANSWERED MY QUESTION YET!! THEY ALL SUCK! THEYRE THE BIGGEST LOSERS ON THE INTERNET! IM GOING TO GET ALL PISSED OFF AT THEM FOR NO DAMN REASON!!

yeah.... shut up.

Shrike

Wurfle 🙂