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
