Re: mysql query problem (very important for me...)

[Reham G]

hiiii...........

as i understand u want the id(or the primary key) of those records which u get from ur search ..

if i'm right then..

$question = "select * from data_table where ".$finding_method." like '%".$phrase."%' ORDER BY nr DESC ";
$result = mysql_query($question);
$howmany_founded = mysql_num_rows($result);
-------------------------------------------------------------------------------
if ur primary key is nr then u will add

while($rs=mysql_fetch_array($result))
{
//u will get one record at a time from those u select
//this will give u the id of the current record

$id=$rs["nr"];

// do what u want with $id


}


------------------------------------------------------------------------------

try and if it doesn't work explain ur problem more