[PHP] MySQL error

[GWAD Mailinglist]

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