How to pull db info as variable?

[Pragz]

This is probably very simple, but I can't figure it out. How would I pull db info from a database as a variable? Like, let's say I have this SQL query:

SELECT * FROM table_blah

How would I take the info from the rows I choose and put them in variables? Like, if I have a row named "random" and I want to pull that information out. How do I assign that to a variable?

If this is confusing, I'm sorry. I don't really know how to word what I'm going for.

[dagon]

assuming mysql

$query="SELECT * FROM table_blah ";

$result = mysql_query($query);

while ($row = mysql_fetch_assoc($result)) {
    echo $row['random'];
}

you should read the manual page for the above functions, and i left out mysql_connect()

[Pragz]

Awesome! Works perfectly.

[dagon]

please use Thread Tools in the menu above to mark thread resolved

[laserlight]

Incidentally, if you only want the data from a particular column, then select only that column rather than all of them.