displaying items from database

[irishgirl2004]

hi,
i am using the following code........

$db = mysql_connect("localhost", "newuser","xli231dffd0");



mysql_select_db("acctest",$db);




$result = mysql_query("SELECT * from clients where id = '$clientid'", $db);

while ($myrow = mysql_fetch_row($result)) {
                echo("<font size\=5>");
                echo("Company Name            ".$myrow["name"]."<br>");

}

nothing displays, but when u use $myrow[0] it displays fine, all my database is lower case aswell, seems bizarre, has anybody come accross this??????

[Pig]

mysql_fetch_row returns an array with only numeric keys (0,1,2,3,etc.)

Use mysql_fetch_assoc if you have only one row, or mysql_fetch_array if you have multiple.

[lazzerous]

Also...

NEVER post usernames and passwords for ANYTHING ANYWHERE

gotta keep security in mind at all times, IrishGirl