query field names?

[pennyw1s3]

Hi, newbie here
been playing with PHP & MySQL for about a day and a half now-

my question is in regards to the query and result abilities of PHP

with coldfusion, the data from a returned query could be parsed out with a CFQUERY_NAME.TABLE_FIELD_NAME format.

Does PHP have the same capibilities?

example with CF -
results from CFQuery=findit
on table alpha with rows named x y z
could be called to be displayed in html with

finit.x <-that would display the returned value in table alpha
row x

I saw something about making arrays out of query results, but couldn't find much information on this.

thx

[Drakla]

There are a few ways to get the data back in a way that'll be pretty close to what you want:

$query="SELECT filetype, fileid, data FROM blahh blahh....";

$res=mysql_query($query, $dbh);

//this fetches into an array where you access the values with an index
$row=mysql_fetch_row($res);

$ftype=$row[0]; $id=$row[1];  //etc

//OR fetch into an associative array

$row=mysql_fetch_assoc($res);

$ftype=$row['filetype'];

//Or you can get it to do both with
$row=mysql_fetch_array($res, ARRAY_TYPE);

//ARRAY_TYPE can be MYSQL_ASSOC, MYSQL_NUM or MYSQL_BOTH.  Both let's you use numbers or names