...

View Full Version : mysql select 3 id



t6werserv
04-02-2010, 03:03 PM
hi all how r u ?

i want code : select another 3 id form table mysql ??

abduraooft
04-02-2010, 03:09 PM
select another 3 id form table mysql ?? Please show what you've done so far.

t6werserv
04-02-2010, 05:50 PM
i want display 3 image desc only form table


$sql2 = "select TOP 3 image from tbl_data order by id desc";
$result2 = mysql_query($sql2);
while ($display= mysql_fetch_array($result2))
{
echo'
<table border="0" width="95%" id="table1" cellspacing="4" cellpadding="0">
<tr>
<td width="174" class=address >'.$display['image'].'</td>
</tr>
</table>
';
}


example:

Attach Files

MattF
04-02-2010, 06:08 PM
$sql2 = "SELECT image FROM tbl_data ORDER BY id DESC LIMIT 3";

Dormilich
04-03-2010, 06:48 AM
<td width="174" class=address >'.$display['image'].'</td>
you are aware that images in HTML are displayed differently?



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum