Insert Specific MySQL Row

kdoggy

Hi,

How would I go about printing a specific MySQL row?

My query looks something like this:

SELECT id, name FROM categories WHERE parent = '$cat' ORDER BY name ASC

This returns about six rows. Now in my code I do some calculations. The caculation will return a number, for example "4" Now I need to print the 4th row of the result.

Anybody know how this could be done?

Thanks for your help!

procoder

say your result is stored in $result

echo mysql_result($result, 4,field_name)

second var is the row #
third is the field name

kdoggy

Originally posted by procoder
say your result is stored in $result

echo mysql_result($result, 4,field_name)

second var is the row #
third is the field name

Hi,

See, I knew it had to be something REALLY simple, I was just missing it :rolleyes:

Thanks for your help 😉