quick simple question

[run_GMoney]

I just want to set the value of a PHP variable to the values of one item in my database. I've got one item in one column. So let's call my column name phpE1. I just wanna say something like $phpE1 = the one item in phpE1. I know it's something along the lines of "SELECT phpE1 FROM table" but I'm not exactly positive. So, to review, I just need $phpE1 to equal the value in the column phpE1. Thanks!!!

[cgraz]

you're on the right track.

// run your query. will only select phpE1 field
$query = mysql_query("SELECT phpE1 FROM your_table");

while($row = mysql_fetch_assoc($query)) { // fetch the records into an array
   $phpE1 = $row["phpE1"]; // assing the db value from field to $phpE1
   echo $phpE1 . "<br>"; // echo it
}

It comes out as a variable as it is; no need to assign a new variable name. Instead of doing

$phpE1 = $row["phpE1"];

you can just use

$row["phpE1"]

Cgraz