PHP While loop / MySQL Data

[advancedfuture]

So the below is my attempt at pulling multiple bits of data from the database.... so far the only value that is returning anything useful is $RESUME. What am I doing wrong here? Thankx!

 

$query = "SELECT resume, firstname, lastname, interests FROM profile WHERE username = '$username'";
$results = mysql_query($query);
$num = mysql_num_rows($results);
while($row = mysql_fetch_array($results))
{
$RESUME = $row[0]; //GLOBAL RESUME
$FIRSTNAME = $row[1];
$LASTNAME = $row[2];
$INTERESTS = $row[3];
}

[simcoweb]

Since you're running the 'while' loop you don't need to also assign the results to variables unless that's what you want. Are you wanting to print the results?

[advancedfuture]

Yes i am wanting to print the results that is why I am assigning variables to them... this is just a snippet of the code.

[Ken2k7]

<?php
$query = "SELECT resume, firstname, lastname, interests FROM profile WHERE username = '$username'";
$results = mysql_query($query);
$num = mysql_num_rows($results);
while($row = mysql_fetch_array($results))
{
echo $row[0].", ".$row[1].", ".$row[2].", ".$row[3];
}
?>

Does that do any good?

[revraz]

Post the code after it too.

[simcoweb]

Ken2k7's snippet will print them out on a single line if that's good enough. Otherwise you'd need in integrate some HTML into the 'echo' to have it return in table cells/rows.

[Ken2k7]

Ken2k7's snippet will print them out on a single line if that's good enough. Otherwise you'd need in integrate some HTML into the 'echo' to have it return in table cells/rows.

Yeah, I was just seeing if it prints out any results. If it does, the problem is solved.