[Resolved] MYSQL Results- Please Help!

erikhillis

Im trying to limit the number of results per page... here is what I want to do: http://forums.devshed.com/t36525/s.html ... can someone please change my php so it will limit the results to 25 results/ page, and show previous and next pages...

my php is below... Thanks. 🙂

<?php
// Connect to the database
$db = mysql_connect("localhost","dhillis_site","password");
mysql_select_db (dhillis_site);
// Ask the database for the information from the games table
$sql = "SELECT id, title, price, description, shorttext, imageurl, company, platform, sale, console, shipping, yousave FROM games WHERE console='{$_REQUEST['console']}' ORDER by title asc";
if (!$result = mysql_query($sql)) {
print "Invalid query ($sql) : " . mysql_error();
exit;
}
while ($row = mysql_fetch_assoc($result)) {

print "<table width= '100%' cellspacing= '0' cellpadding ='1'><tr>
<td width= '45%'><a href= 'game.php?id={$row['id']}'>{$row['title']}</a> ${$row['price']}</td>
<td width= '30%'>{$row['company']}</td>
<td width= '15%'>{$row['console']}</td>
<td width= '10%'>{$row['price']}</td>
</tr></table>

}

Please, please change that so I can have 25 results/ page, with next/ previous pages...

Pittperson

Check out this tutorial, it is exactly what you are looking for...

http://www.phpfreaks.com/tutorials/73/1.php

HTH

Chris

erikhillis

Thanks, But I still have 1 problem...

while($row = mysql_fetch_array($sql)){
// Build your formatted results here.
echo $row['title']." ";
}

what I want there is
<td width=\"40%\">$row['title']</td>
<td width=\"30%\">$row['company]</td>
<td width=\"15%\">$row['console']</td>
<td width=\"30%\">$row['price']</td>

But it always gives me a phase error... How can I get that into there w/o getting an error...

What are formatted results? It wont let me change that w/o getting some type of error.

Heres my page http://www.etreasures.org/games.php?console=PC.

cgraz

while($row = mysql_fetch_array($sql)) { 

   echo "<td width=\"40%\">" . $row["title"] . "</td>"; 
   echo "<td width=\"30%\">" . $row["company"] . "</td>"; 
   echo "<td width=\"15%\">" . $row["console"] . "</td>"; 
   echo "<td width=\"30%\">" . $row["price"] . "</td>"; 

}

Cgraz

Pittperson

What cgraz said. 🙂

erikhillis

thanks 😃
1 more thing though...

can you add a link to games.php?id=game id to the game title? I keep getting errors.

<a href=\"game.php?id=$row["id"]\">$row["title"]</a>

That dosnt work... 🙂

cgraz

echo "<a href=\"game.php?id=".$row["id"]."\">".$row["title"]."</a>";

Cgraz

erikhillis

Thanks alot 😃 works great

http://www.etreasures.org/games.php?console=PC

camullins

Just to point something out it is printing 26 items per page and not 25...

Also instead of

$sql = "SELECT id, title, price, description, shorttext, imageurl, company, platform, sale, console, shipping, yousave FROM games WHERE console='{$_REQUEST['console']}' ORDER by title asc";

It could be better to write that as:

$sql = "SELECT * FROM games WHERE console='{$_REQUEST['console']}' ORDER by title asc";

If you are selecting most of the rows then use the above, as it will make it a lot easier to add rows, delete rows whatever you need without having to change that line of code

Pittperson

Looks good.

chris