That looks like a PHP problem to me. Have you tried mysql_fetch_assoc()? I believe mysql_fetch_row() gets you an array with a numeric index (in which case lastname would be in $line[0]).
> Notice: Undefined index: lastname in E:\IIS Webs\index.php on line 29 > > <? > > PRINT "<HTML>"; > PRINT "<HEAD>"; > PRINT "<TITLE>ADDRESSES</title>"; > > PRINT "</HEAD>"; > > PRINT "<BODY BGCOLOR=white TEXT=#000000 LINK=#FF0000 VLINK=#000066 > aLINK=#FF0000>"; > > mysql_pconnect("127.0.0.1:3308", "user", "pass") or > die("could not connect"); > mysql_select_db("address"); > > $query = "SELECT lastname, firstname, city FROM data"; > $result = mysql_query ($query); > > while ($line = mysql_fetch_row($result)) { > > echo "<BR>".$line['lastname']; > echo "<BR>".$line['firstname']; > echo "<BR>".$line['city']."<BR>"; > > } > > ?> > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php