Log in or Sign up

Convert this SQL result to show up in TABLES. How?

Discussion in 'MySQL' started by Personal Gamers, Jan 14, 2011.

Personal Gamers Peon

Messages:

10

Likes Received:

0

Best Answers:

0

Trophy Points:

0

#1

Can you show me how to edit this SQL to show up in Tables and rows.
I want to have it like this

Result1 Result2 Result3 Result4 Result5
Result6 Result7 Result8 Result9 Result10
and so on... till result 50...

<?php
echo '<ul>';

$sql = mysql_query("SELECT * FROM ----- WHERE published=1 ORDER BY id desc LIMIT 10");
while($row = mysql_fetch_array($sql)) {

$url = GameUrl($row['id'], $row['name'], $row['category_id']);

$name = shortenStr($row['name'], $template['module_max_chars']);

if ($setting['module_thumbs'] == 1) {
$image_url = GameImageUrl($row['image'], $row['import']);
$image = '<img src="'.$image_url.'" width= 25 height= 25 style="vertical-align: middle;" /> ';
}
else {
$image = '';
}

echo '<li>'.$image.'<a href="'.$url.'">'.$name.'</a></li>';
}

echo '</ul>';
?>
Click to expand...

Personal Gamers, Jan 14, 2011 IP

(You must log in or sign up to reply here.)