How do ı just select the first row ?

[jeddi]

I am running a quich search on my transaction file to
pick up the client id number.

the transaction file may have several rows for that client
and I can identify them from another field, the subscription number.

This is the php that I have:

PHP Code:

$sql = "select client_id from transactions where subscr_id = '$Db_subscr_id'";
$result = mysql_query($sql) or die("Find Transaction to Modify query failed:". mysql_error());  
$num = mysql_num_rows($result);

if ($num == 0) {
   Handle the error
   } // end if    
else { 


Now there could be many rows with the same subscrition number
and all of them will have the same client id number.

So after this else I want to gab the first row in the result array
and find out what the client_id value is.

How do I get the first on ?

[whizard]

$sql = "select client_id from transactions where subscr_id = '$Db_subscr_id' LIMIT 1";



Dan

[SKDevelopment]

... and then

PHP Code:

$row = mysql_fetch_array($result);
$client_id = $row['client_id']; 


[whizard]

oh good call, I didn't see that part.

Dan

[jeddi]

Thanks for helping