Next 60 items from DB

[gwildor]

hey! 🙂

i have about 300 items in my db.. and i'm just trying to list a certain number at a time, 60 at the moment.. But i want to add a next button to my page so that people can see the next 60 items..

helllp..

this is the code i have so far..

<? 
mysql_connect ("localhost", "user" , "pwd") or die ('I cannot connect to the database.'); 
mysql_select_db ("gwildor_gwildormagic"); 


$SQL = mysql_query("SELECT * FROM magic_cards LIMIT 0,60"); 



$tableData = mysql_fetch_array($SQL); 


echo "<table border=1>\n";
echo "<tr><td>Qty</td><td>Card Name</td><td>Rarity</td><td>Set</td><td>Card #</td><tr>\n";

do { 

   echo "<tr><td>\n";
   echo("$tableData[Qty]");

   echo "</td><td>\n";
   echo("$tableData[Card_Name]");

   echo "</td><td>\n";
   echo("$tableData[Rarity]");

   echo "</td><td>\n";
   echo("$tableData[Set]");

   echo "</td><td>\n";
   echo("$tableData[No]");

   echo "</td></tr>\n";

} while ($tableData = mysql_fetch_array($SQL));  

echo "</table>\n";

thank you thank you thank you.

[vig0]

Originally posted by gwildor

<? 
mysql_connect ("localhost", "user" , "pwd") or die ('I cannot connect to the database.'); 
mysql_select_db ("gwildor_gwildormagic"); 

$SQL = mysql_query("SELECT * FROM magic_cards LIMIT 0,60"); 

$tableData = mysql_fetch_array($SQL); 

echo "<table border=1>\n";
echo "<tr><td>Qty</td><td>Card Name</td><td>Rarity</td><td>Set</td><td>Card #</td><tr>\n";

do { 

   echo "<tr><td>\n";
   echo("$tableData[Qty]");

   echo "</td><td>\n";
   echo("$tableData[Card_Name]");

   echo "</td><td>\n";
   echo("$tableData[Rarity]");

   echo "</td><td>\n";
   echo("$tableData[Set]");

   echo "</td><td>\n";
   echo("$tableData[No]");

   echo "</td></tr>\n";

} while ($tableData = mysql_fetch_array($SQL));  

echo "</table>\n";

[/B]

try something like this....

$cnt_num = 60; //-------------------------- number you want to be viewed on page
if (!$num) {
  $num = 0;
}

$SQL = mysql_query("SELECT * FROM magic_cards LIMIT $num,$cnt_num"); 

$tableData = mysql_fetch_array($SQL); 

echo "<table border=1>\n";
echo "<tr><td>Qty</td><td>Card Name</td><td>Rarity</td><td>Set</td><td>Card #</td><tr>\n";

do { 

   echo "<tr><td>\n";
   echo("$tableData[Qty]");

   echo "</td><td>\n";
   echo("$tableData[Card_Name]");

   echo "</td><td>\n";
   echo("$tableData[Rarity]");

   echo "</td><td>\n";
   echo("$tableData[Set]");

   echo "</td><td>\n";
   echo("$tableData[No]");

   echo "</td></tr>\n";

} while ($tableData = mysql_fetch_array($SQL));  

echo "</table>\n";

$pnum = $num - $num_cnt; //------------------------------------- Previous Number
$nnum = $num + $num_cnt; //----------------------------------------- Next Number
echo "<table border=1>\n";
echo "<tr>\n";
if ($pnum > 0) {
  echo "<td>";
  echo "<a href=\"pagename.php?num=$pnum\">";
  echo "Previous $cnt_num";
  echo "</a>";
  echo "</td>";
}
if ($nnum > 0) {
  echo "<td align=right>";
  echo "<a href=\"pagename.php?num=$nnum\">";
  echo "Next $cnt_num";
  echo "</a>";
  echo "</td>";
}

echo "</tr>\n";
echo "</table>\n";

[gwildor]

i tried out your code vig0..

i'll let you know i changed it from 60 to 30..

and i changed the code at the bottom to magic3.php..

now when i display the page.. it displays 30 results. however i'm not getting the previous & next table at the bottom..

however when i type magic?num=1 then the table at the bottom does come up..

check it out..

http://www.gwildor.com/magic3.php
or
http://www.gwildor.com/magic3.php?num=1

[vig0]

oops, sorry about that.
try this....

$cnt_num = 30; //-------------------------- number you want to be viewed on page
if (!$num) {
  $num = 0;
} else {
  $num = $num + $cnt_num; 
}

$SQL = mysql_query("SELECT * FROM magic_cards LIMIT $num,$cnt_num"); 

$tableData = mysql_fetch_array($SQL); 

echo "<table border=1>\n";
echo "<tr><td>Qty</td><td>Card Name</td><td>Rarity</td><td>Set</td><td>Card #</td><tr>\n";

do { 

   echo "<tr><td>\n";
   echo("$tableData[Qty]");

   echo "</td><td>\n";
   echo("$tableData[Card_Name]");

   echo "</td><td>\n";
   echo("$tableData[Rarity]");

   echo "</td><td>\n";
   echo("$tableData[Set]");

   echo "</td><td>\n";
   echo("$tableData[No]");

   echo "</td></tr>\n";

} while ($tableData = mysql_fetch_array($SQL));  

echo "</table>\n";

$pnum = $num - $num_cnt; //------------------------------------- Previous Number
$nnum = $num + $num_cnt; //----------------------------------------- Next Number
echo "<table border=1>\n";
echo "<tr>\n";
if ($num > 0) {
  echo "<td>";
  echo "<a href=\"magic3.php?num=$pnum\">";
  echo "Previous $cnt_num";
  echo "</a>";
  echo "</td>";
}
if ($num >= 0) {
  echo "<td align=right>";
  echo "<a href=\"magic3.php?num=$nnum\">";
  echo "Next $cnt_num";
  echo "</a>";
  echo "</td>";
}

echo "</tr>\n";
echo "</table>\n";

Hopefully this'll work for you. 🙂

[gwildor]

getting better..

but for some reason it's sitting at zero.. when i press next i still get the same 30 cards.. 🙁

i've updated
http://www.gwildor.com/magic3.php

[vig0]

get rid of the else here.

if (!$num) {
  $num = 0;
} else {
  $num = $num + $cnt_num; 
}

have it read

if (!$num) {
  $num = 0;
}

Sorry, I haven't been testing the code before posting. Hopefully this'll work for ya.

[gwildor]

NONONO.. I reaally appreciate the help..

i made the slight change... same problem.. 🙁

i'm sorry to harrass you..

[gwildor]

I FOUND THE PROBLEM!! hehehe Your code was flawless... cept for one type where it was doing the adding..

i changed

$pnum = $num - $num_cnt; //------------------------------------- Previous Number
$nnum = $num + $num_cnt; //----------------------------------------- Next Number

to

$pnum = $num - $cnt_num; //------------------------------------- Previous Number 
$nnum = $num + $cnt_num; //----------------------------------------- Next Number 

thanks again sooo much!!

[vig0]

doh.

I'm always making stupid mistakes like that. I'm glad you figured out the problem.