PHP/MYSQL syntax question

1

Hey there…
I am tearing my hair out over a problem with displaying some data from a MYSQL database. The data is not stored in nice, convenient rows. That would be too easy.

So my question is, is it possible to use a WHERE statement in a variable? Something like this:


$sql = mysql_query ("SELECT value, fid, uid  FROM $table2 WHERE uid=1") or die (mysql_error ());
$row = mysql_fetch_assoc ($sql);
$info = $row['value'] WHERE ['fid']=1;

I know that isn’t it, but is it possible at all? This is a limited, shortened piece of what I am working on, and it will eventually be looped…

Thanks!

Chris