Well, are you getting a valied response from the database?
Perhaps it would be nice to add some error handling into your code...
i.e.:
$mysql_result = mysql_query($query, $mysql_link)
or die("Invalid query: $query");
or echo out mysql_error();
GWAD Mailinglist wrote:
> Hi,
>
> I have following problem:
>
> list.php3
>
> <?
>
> // connect to db
> include("connect_db.php3");
>
> // get everything from catalog table
>
> $query = "SELECT * FROM yritykset ORDER BY ynimi ASC";
>
> $mysql_result = mysql_query($query, $mysql_link);
>
> // get each row
>
> --> line 36 while($row = mysql_fetch_row($mysql_result))
>
> {
>
> //get columns
>
> $id = $row[0];
> $ynimi = $row[1];
> $ylahi = $row[2];
> $ypostios = $row[3];
> $ypostitmp = $row[11];
>
> print("<TABLE WIDTH=\"750\" BORDER=\"0\">\n");
> print("<TR>\n");
>
> print("<TD WIDTH=\"550\">$ynimi, $ylahi, $ypostios
> $ypostitmp<TD>\n");
> print("<TD WIDTH=\"200\"><A
> HREF=\"tarkenna.php3?id=$id\">MUOKKAA></A> - <A
> HREF=\"poista.php3?id=$id\">POISTA></A><TD>");
>
> print("</TR>\n");
> print("</TABLE>\n");
>
> }
>
> // disconnect
> mysql_close($mysql_link);
> ?>
>
> when run, i'll following error messages:
>
> Warning: mysql_fetch_row(): supplied argument is not a valid MySQL
> result resource in /www/domains/lammidb.phnet.fi/public_html/kaikki.php3
> on line 36
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
