Can someone please tell me what I am missing. the following sql query returns only the first letter of strings it fetched from the my database:\[code\] $result = mysql_query("SELECT * FROM users) or die("error in the query");\[/code\]thanks.Update\[code\]$result = mysql_query("SELECT * FROM properties JOIN users USING(UserId) WHERE Level <> 'Admin' $pages->limit") or die("could not load all the properties"); $i=0; while($row = mysql_fetch_array($result)) { $fn[$i] = $row ['FN']; $ln[$i] = $row ['LN']; $phone[$i] = $row ['Phone']; $Email[$i] = $row ['Email']; } \[/code\]...the part of the code that giving me head ache since yesterday. \[code\]$fn\[/code\], \[code\]$ln\[/code\], \[code\]$email and\[/code\]$phone` all contain only one character. I think the error is on my own page but i just can't see it. anything concerning property contains the rite value