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!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

php and Mysql

Status
Not open for further replies.
hecheng

hecheng

Programmer
Jun 23, 2003
7
CA
this is my PHP code

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

<body>
<?php
$mylink=mysql_connect(&quot;localhost&quot;, &quot;root&quot;, &quot;12456&quot;);
mysql_select_db(&quot;elementary&quot;, $mylink);
$sql=&quot;select * from elementary&quot;;
$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

 
Sort by date Sort by votes
try this:
$result=mysql_query($sql) or die(mysql_error());

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


Known is handfull, Unknown is worldfull
 
Upvote 0 Downvote
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??
 
Upvote 0 Downvote
the while loop is meant to assign, so == is not the problem...

Known is handfull, Unknown is worldfull
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

E
  • Locked
  • Question
MySQL calculator tools
Replies
0
Views
228
EdZzy
E
lupidol
  • Locked
  • Question
Cannot create new table in mySQL 3
Replies
6
Views
445
lupidol
lupidol
lupidol
  • Locked
  • Question
mysql cannot add rows with &quot;UNION&quot; 1
Replies
5
Views
406
Chris Miller
Chris Miller
penguinspeaks
  • Locked
  • Question
Stored Procedures and triggers
Replies
9
Views
416
penguinspeaks
penguinspeaks
dylim
  • Locked
  • Question
Why MySQL 5.7 is still getting updates
Replies
3
Views
333
spamjim
spamjim

Part and Inventory Search

Sponsor

Back
Top