A
Anonymous
Guest
Check this out this may solve your problem without changing your code much
Code:
<?php
$link=mysql_connect('localhost','root','mysql');
if(!$link)
{
die("coudn't connect".mysql_error());
}
mysql_select_db("medway",$link);
$result = mysql_query("[b]SELECT * FROM receipt order by ReceiptNo desc limit 1[/b]");
while($row = mysql_fetch_array($result))
{
echo $row['ReceiptNo'];
echo "<br />";
}mysql_close($con);
?>