Bug #10456: Warning: Supplied argument is not a valid MySQL result resource in c:\inetpub\w
| From: | joris_van_boven at hotmail dot com | Date: | Mon, 23 Apr 2001 11:39:42 +0000 |
| Subject: | Bug #10456: Warning: Supplied argument is not a valid MySQL result resource in c:\inetpub\w | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-52189@lists.php.net to get a copy of this message | ||
From: joris_van_boven@hotmail.com
Operating system: win 2000
PHP version: 4.0.4pl1
PHP Bug Type: MySQL related
Bug description: Warning: Supplied argument is not a valid MySQL result resource in c:\inetpub\w
<html><body>
<h1>Kijk hier een database!</h1>
<a href='Prob01.PHP'>Prob 01 (PHP)</a>
<?
$SQLhost = "localhost";
$SQLgebruiker = "Administrator";
$SQLpassword = "xxxxxxxxx";
// connect
database-------------------------------------------------------------------------------------------------
@$objconn = mysql_connect($SQLhost,$SQLgebruiker,$SQLpassword)
or die("Da is hier mis gelopen! Kan niet inloggen op de database: ".$SQLhost."
".$SQLgebruiker." ".$SQLpassword );
// Basis
SQL-string-------------------------------------------------------------------------------------------------
$Sqlstring = "SELECT id, naam, com FROM prob";
// Ophalen data en in tabel
steken----------------------------------------------------------------------------------
echo "<table
border=1><TR><TH>ID</TH><TH>Persoon</TH><TH>Commentaar</TH></TR>";
$dbRecordSet = mysql_db_query($SQLgebruiker, $Sqlstring);
while ($dbRecord = mysql_fetch_array($dbRecordSet))
{
echo
"<TR><TD>".$dbRecord[id]."</TD><TD>".$dbRecord[naam]."</TD><TD>".$dbRecord[com]."</TD></TR>";
}
echo "</table>";
// Sluiten
database--------------------------------------------------------------------------------------------------
$dbRecord=null;
mysql_close($objconn);
$objconn=null;
?>
</body></html>
--
Edit Bug report at: http://bugs.php.net/?id=10456&edit=1