mysql_fetch_array() does the same thing as mysql_fetch_assoc(), both will return the record as an associative array, which is how you're trying to access it.
> -----Original Message----- > From: Victor Pendleton [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 15, 2003 9:49 AM > To: 'Maureen Roihl'; 'C. Reeve'; MySQL List > Subject: RE: Notice: Undefined index: > > > It that does not work. You could try the following snippet: > > if ($result = mysql_query ($query);) > { > while ($row = mysql_fetch_array ($result)) > { > ... > } > > mysql_free_result($result); > } > else > { > ... > } > > -----Original Message----- > From: Maureen Roihl [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 15, 2003 7:49 AM > To: 'C. Reeve'; MySQL List > Subject: RE: Notice: Undefined index: > > > > 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 > --------------------------------------------------------------------- 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
