note 40658 deleted from function.mysql-query by nlopess
| From: | nlopess@php.net | Date: | Thu, 11 Mar 2004 15:02:01 +0000 |
| Subject: | note 40658 deleted from function.mysql-query by nlopess | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-66658@lists.php.net to get a copy of this message | ||
Note Submitter: gringogirl
----
i am new to PHP and having some basic difficulties trying to retrieve info from my dbase! I keep
getting error saying 'query is empty'
<?php
$dbase= mysql_connect("localhost", "", "") or die("Unable to
connect to SQL server");
mysql_select_db("",$dbase) or die("Unable to select database");
mysql_query($result, $dbase) or die (mysql_error());
$result= mysql_query("SELECT * FROM tblCategory");
if($myrow = mysql_fetch_array($result)) do{
$catname = $myrow["vchrCategoryName"];
$catdescr = $myrow["vchrCategoryDescr"];
$bodystring .= "$catname - $catdesc";
} while ($myrow = mysql_fetch_array($result));
print <<<EOF
can anyone spot what i'm doing wrong? sorry if sound stupid