SQL: get row num

[alpha02]

Hello!I want to make a function to return the row number. Example:table: orders|_____ID_____|_________NAME__________||_____4______|______NOBODY__________||_____3______|_______NONE____________||_____5______|_______NONAME__________||_____2______|_______NOBODY__________|something like:$resource = mysql_query ("SELECT * FROM orders WHERE id = '5'");$rownum = getrownum ($resource);echo $rownum; //write 2I need this for my forum, please help!

[aspnetguy]

Hello!I want to make a function to return the row number. Example:table: orders|_____ID_____|_________NAME__________||_____4______|______NOBODY__________||_____3______|_______NONE____________||_____5______|_______NONAME__________||_____2______|_______NOBODY__________|something like:$resource = mysql_query ("SELECT * FROM orders WHERE id = '5'");$rownum = getrownum ($resource);echo $rownum; //write 2I need this for my forum, please help!

<{POST_SNAPBACK}>

$rownum = 0;$i = 0;$resource = mysql_query ("SELECT * FROM orders");$numberOfRecords = mysql_numrows($resource);while($i < $numberOfRecords){     if(mysql_result($resource,$i,'id') == '5');          $rownum = $i;     $i++;}

[alpha02]

Thanks, fixed it now!

[justsomeguy]

11 years later, that's probably a record.

[alpha02]

7 hours ago, justsomeguy said:

11 years later, that's probably a record.

I take pride in what I do.