MySQL help - Selecting id's

[kazuki]

I need some little help, here's my sample code that works from my database.

// Mysql


$myHost = "localhost"; // usually 'localhost'
$myUN   = "root"; // username for mysql
$myPW   = ""; // password for mysql
$myDB   = "book"; // name of mysql-database we are going to use

$myConn = mysql_connect($myHost, $myUN, $myPW);

$Query = "SELECT id, title, downloads FROM dl_links LIMIT 4 ";

$Result = mysql_db_query ($myDB, $Query, $myConn);

while ($Row = mysql_fetch_array($Result)) {

echo "<td align=\"left\">downloads: <b>$Row[downloads]</b></td>\n"; == this one here

}

mysql_close($myConn);

I want to create a table that displays only 4 columns per row,

I was wondering on how to display the next items on the [downloads] list?

<tr>

echo "<td align=\"left\">downloads: <b>$Row[downloads]</b></td>\n"; == this one here

</tr>

<tr>

<td> the next four items displays here</td>

help!

</tr>😕

[leatherback]

Hi,

Leave out the limit in your query.
After the query add $i = 0;

Then, in your while loop add:

$i++;
if ($i>4)
{
echo "</tr><tr>" ;
$i=0;
}

J.

[kazuki]

Thanks,

It did work, but I have images on the table rows

image 1 image 2 image 3

downloads 12 downloads 5 downloads: 10

image 4 image 5 image 6

downloads 23 downloads 4 downloads 3

Images are not from database....

I'm a newbie at mysql how to create a code like this one?

Help leatherback, anybody!
😕 😕