dont forget mysql_fetch_object() then you will have $line->lastname;
Maureen Roihl wrote:
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
-- ------------------------------------------------------------------- =================================================================== ----------- :::==== ::: :::==== :::==== :::=== :::======= ----------- ::: === ::: :: === :: === === ::: === === ----------- === === === ==== ==== ===== === === === ----------- === === === === === === === === ----------- ======= === ======== ======== ====== === === ========================================www.dunkfordyce.co.uk====== --------------------------------------------------------------------- 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
