Select a specific row

MattReider

Hi Everyone,

Very new to php, and have a question: How do I select a specific row of information?

For example: I have the filename of an image i want to display in the field "Img" and it's in the third row.

Right now I'm coding like this:

$files = mysql_query("SELECT Img, Txt, Id FROM db");

$row = mysql_fetch_array($files);

The result gives me a blank space in the outputted html.

How can I select the third entry in the field Img?

PLEASE help asap. I appreciate any ideas!!

Matt

ir4z0r

just use the name of the row:

<img src="<?=$row['img']?>" />

its usual to do it like this:

$res = mysql_query("SELECT col1, col2 FROM table");
while ($row = mysql_fetch_array($res))
{
  echo $row['col1'] . $row['col2'];
}

MattReider

Thanks for the response, but:

The code you gave me is where I'm at. I know how to select a field, and load it and all that.

After I load a field/column though, I want to get the information from a specific row - Right now I can only get teh info from the first row, but i want information from the third, and only the third.

How can I do that?

MattReider

I just discovered the WHERE function 🙂 Now I call Img WHERE Id = '3'

Thanks for the help!

ir4z0r

g it's hard to explain sth you dont' know 😃

Traduim

You can also use

mysql_result($query, $record, $field)

But, obviously, is better to optimize your MySQL query.