error check

[Colin-Roberts]

anyone find errors?

<?php
include 'config.php';

$query  = "SELECT name, lname, age, color, friend, pet, sib, ftown, htown, stat, sex, gr, school FROM profile";
$result = mysql_query($query);

while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
    echo "First Name:{$row['name']} <br>" .
         "Last Name: {$row['lname']} <br>" .
"Age:{$row['age']} <br>" .
         "Status: {$row['stat']} <br>" .
"Grade:{$row['gr']} <br>" .
         "School: {$row['school']} <br>" .         
           "Gender:{$row['sex']} <br>" .
         "Fav Town: {$row['ftown']} <br>" .
"Hometown:{$row['htown']} <br>" .
         "Fav Color: {$row['color']} <br>" .
"Best Friend(s):{$row['friend']} <br>" .
         "Pets: {$row['pets']} <br>" .
"Siblings: {$row['sib']} <br><br>";
}
?>

it works fine like this:

$query  = "SELECT name, lname , age, stat, sex, gr, ftown, htown, sib FROM profile";
$result = mysql_query($query); 

but when i add the rest it doenst?

Edited by Lµke (Forum Moderator): Thread Moved From Website Designing. Please post in the correct section next time, Thanks .

[Drompo]

Don't know why but

while($row = mysql_fetch_array($result, MYSQL_ASSOC))

Doesn't look right. Also do you need the {} around the rows.

[Colin-Roberts]

all that is fine?
it just gives errors if i change:

$query = "SELECT name, lname , age, stat, sex, gr, ftown, htown, sib FROM profile";
$result = mysql_query($query);

to

$query = "SELECT name, lname, age, color, friend, pet, sib, ftown, htown, stat, sex, gr, school FROM profile";
$result = mysql_query($query);