Use of 'expand' command

[AWilliams]

In my database, I need to get all of the database fields into variables. I do this using the expand command, like this:

$result = mysql_query("select Product_Type, Product_Name FROM products where Product_ID=$pid"); 

extract(mysql_fetch_array($result)); 

This command seems to easy to me... is it inefficent, or bad in anyway?

[Defender1]

you could also just use the array that mysql_fetch_array() creates by doing something like

$row = mysql_fetch_array($sql); 

then you can use $row['column_name'] in your code.

[eddiembabaali]

It is another cool way to extract array values... The first time I saw it too I was like "WOW PHP sure rocks !!"