PHP & MySQL - simple question, please help!

[robmarston]

Forgive me, this probably should go into the "Newbies" category.

Quick question, I have a MySQL database I'm using PHP to access.

Is it possible to retrieve information contained a specific row AND column?

Let's say I have text-content in row 3 of column A -- how would I retrieve that data and assign a variable to it?

Thanks in advance for your help!

[sheephat]

SELECT * FROM table WHERE id='1'

[Derick88]

$data = mysql_query("SELECT * FROM table1 WHERE id='$id'");
while ($row=mysql_fetch_assoc($data))
{
$assigned_var = $row['row3'];
}