"; else die("SELECT query failed

"); //More advanced logic can also be done based on success or failure if($result) { //Start a table echo ""; echo ""; while($row=mysqli_fetch_assoc($result)) { //Store each SQL row's column name/value pair in a PHP variable foreach($row as $key=>$value) ${$key}=$value; //Construct a table row where "; echo "$sql"; } //End the table echo "

User ID	First Name	Last Name	E-mail
= table division, i.e. a single column echo "
$person_id['	$fname	$lname	$email

"; //Commented code below for DEBUGGING ONLY - Comment out the code for table above if this is being used. while($row=mysql_fetch_assoc($result)) { //Store each SQL row's column name/value pair in a PHP variable foreach($row as $key=>$value) ${$key}=$value; echo "$person_id is the first column returned in my example query.
"; echo "$fname is the second column returned in my example query.
"; echo "$lname is the third column returned in my example query.
"; } } ?>