selection problem 1

[z3phir]

hi ! i use this to get the value of a row from a database

$string = "select * from voci where formid='$formid'";
$result=mysql_query($string);
$row=mysql_fetch_array($result);
$vociid = $row[vociid];

it works great but i have one problem i need to get the smallest value from all rows that works with the select condition. 10x in advance

 

[spookie]

smallet value of what?

Use combination of order by clause and LIMIT.

eg

$string = "select * from voci where formid='$formid' order by formid LIMIT 1";// replace formid with the fieldname of swhich smallest value u want

--------------------------------------------------------------------------
I never set a goal because u never know whats going to happen tommorow.