[RESOLVED] Retrieve only one record.

[mar_zim]

Guys good day. How can I retrieve one record?

$query="select empid from dtrlog where name='$name' and password='$pass'"; 

I want to get the empid value. How can I do that? I only know how to fetch a recordset not a single record.

[penagate]

A slight kludge, but

$record = mysql_fetch_assoc(mysql_query(
  'select distinct `empid` from `dtrlog` '.
  'where `name` = \''.$name.'\' and `password` = \''.$pass.'\''
)); 

[mar_zim]

Does it mean the $record variable is holding the empid value?

[penagate]

Nah, $record will hold the row, you need to do $record['empid'] to get the field value.

Or alternatively you could do this

 $empid = mysql_result(mysql_query(
  'select distinct `empid` from `dtrlog` '.
  'where `name` = \''.$name.'\' and `password` = \''.$pass.'\''
), 0); 

which does it in one go.

[mar_zim]

Thank you pen. Now I have a basic knowledge in php.

[john tindell]

Just for further reference you can use the LIMIT
keyword to limit the amount of records that you want returned, athough in this case it isn't advised.