php and Mysql

hecheng · Jul 6, 2003

this is my PHP code

<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<?php
$mylink=mysql_connect("localhost", "root", "12456&quot

;
mysql_select_db("elementary", $mylink);
$sql="select * from elementary";
$result=mysql_query($sql);
while($myarray=mysql_fetch_array($result))
{
}
?>
</body>
</html>

web server gives me an error
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in f:\database\test.php
on line 13 while($myarray=mysql_fetch_array($result))

how can i solve this problem??
thanks for your help

vbkris · Jul 6, 2003

try this:
$result=mysql_query($sql) or die(mysql_error());

the problem may be in the query execution....

Known is handfull, Unknown is worldfull

Mellegem · Jul 7, 2003

I'm thinking of the top of my head here but try

while ($result.next()){}
otherwise

while($myarray==mysql_fetch_array($result))
{
}
where == is logical equals and = assigns, or am I reading this wrong??

vbkris · Jul 8, 2003

the while loop is meant to assign, so == is not the problem...

Known is handfull, Unknown is worldfull

Mellegem · Jul 8, 2003

Oh well, I'm abit of a newb myself

I have a similar problem and put it down to trying to read an empty set of results. Add a couple of dbase entries and see if that fixes it, otherwise I have no idea.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

php and Mysql

hecheng

Programmer

vbkris

Programmer

Mellegem

Technical User

vbkris

Programmer

Mellegem

Technical User

Similar threads

Part and Inventory Search

Sponsor