[SOLVED] Rows displaying randomly in php

[rnb_cassanova]

Hi guys,

 

I have got a mysql database displaying in PHP but everytime a row is added, they do not order by the auto increment ID, but all random instead. Can anyone have an idea how to put them in descending order?

 

My Code -

 

<?php

While($row = mysql_fetch_array($result))

{ ?>

    <tr>

      <td width="78"><div align="center"><?php echo $row['ProposalID']?></div></td>

      <td width="103"><div align="center"><?php echo $row['Name']?>

      </div></td>

 

Thanks Guys

[themistral]

You will need to add the order by option on your query

 

$query = SELECT * FROM table ORDER BY fieldname DESC

[rnb_cassanova]

Brilliant! Thanks for the reply.