Help in Php?

[pakilala]

bhut hi acha forum hy.
mara ak masala hy vo yeh k mera database mysql ma hy js ka nam "dw" hy awr table ka nam "tmo" hy. is a 2 field hy ak ka nam "id" awr dosray ka nam "amount" hy. my ny informmation to php page par display to kar di par ma chata ho ka ka display page ma "amount" field k sath ak coloum "S.No" ka bi ho jis ma numbers ascending order ma display ho. ar agar user delete karna chay to vo khud ba khud ascending order ma ay.

thanks

[ahmedameer]

copy and paste the following Code....[INSHALLAH aapka kaam ho jaeega]


---------------------------------------------------------------------
<?php
mysql_connect('localhost','root','') or die("Database not connected");
mysql_select_db('dw') or die("Database not fount");

$query = mysql_query("SELECT * FROM tmo Order by id Asc Limit 0, 10");
echo "<table>
<tr>
<th align='center' width='50%'><b>Serial #</b></th>
<th align='center' width='50%'>&nbsp;<b>Amount</b></th>
</tr>
";
while($row = mysql_fetch_assoc($query)){
$id = $row['id'];
$amount = $row['amount'];
echo "
<tr>
<td>".$id."</td>
<td>".$amount."</td>
</tr>
";
}
echo "</table>";

?>

-------------------------------------------------------------------------

[BossisBack]

Moved to AAE