Ad:

PHP Discussion Thread
Unsolved
Views: 1250

Dec 8th, 2008

Warning: mysql_numrows()

Expand Post »

HI All,

I am currently following a tutorial on mysql and php and I am getting this error on displaying results ready for an update in a form.

Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /home/site/update.php on line 11

PHP Syntax (Toggle Plain Text)
<?
$id=$_GET['id'];
$username="web183-sql";
$password="sqlpassword";
$database="web183-sql";
mysql_connect(localhost,$username,$password);
 
$query=" SELECT * FROM contacts WHERE id='$id'";
$result=mysql_query($query);
 
$num=mysql_numrows($result);
 
mysql_close();
 
$i=0;
while ($i < $num) {
 
$first=mysql_result($result,$i,"first");
$last=mysql_result($result,$i,"last");
$phone=mysql_result($result,$i,"phone");
$mobile=mysql_result($result,$i,"mobile");
$fax=mysql_result($result,$i,"fax");
$email=mysql_result($result,$i,"email");
$web=mysql_result($result,$i,"web");
?>
 
<form action="updated.php" method="post">
<input type="hidden" name="ud_id" value="<? echo $id; ?>">
First Name: <input type="text" name="ud_first" value="<? echo $first; ?>"><br>
Last Name: <input type="text" name="ud_last" value="<? echo $last; ?>"><br>
Phone Number: <input type="text" name="ud_phone" value="<? echo $phone; ?>"><br>
Mobile Number: <input type="text" name="ud_mobile" value="<? echo $mobile; ?>"><br>
Fax Number: <input type="text" name="ud_fax" value="<? echo $fax; ?>"><br>
E-mail Address: <input type="text" name="ud_email" value="<? echo $email; ?>"><br>
Web Address: <input type="text" name="ud_web" value="<? echo $web; ?>"><br>
<input type="Submit" value="Update">
</form>
 
<?
++$i;
}
?>
<?
$id=$_GET['id'];
$username="web183-sql";
$password="sqlpassword";
$database="web183-sql";
mysql_connect(localhost,$username,$password);

$query=" SELECT * FROM contacts WHERE id='$id'";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

$i=0;
while ($i < $num) {

$first=mysql_result($result,$i,"first");
$last=mysql_result($result,$i,"last");
$phone=mysql_result($result,$i,"phone");
$mobile=mysql_result($result,$i,"mobile");
$fax=mysql_result($result,$i,"fax");
$email=mysql_result($result,$i,"email");
$web=mysql_result($result,$i,"web");
?>

<form action="updated.php" method="post">
<input type="hidden" name="ud_id" value="<? echo $id; ?>">
First Name: <input type="text" name="ud_first" value="<? echo $first; ?>"><br>
Last Name: <input type="text" name="ud_last" value="<? echo $last; ?>"><br>
Phone Number: <input type="text" name="ud_phone" value="<? echo $phone; ?>"><br>
Mobile Number: <input type="text" name="ud_mobile" value="<? echo $mobile; ?>"><br>
Fax Number: <input type="text" name="ud_fax" value="<? echo $fax; ?>"><br>
E-mail Address: <input type="text" name="ud_email" value="<? echo $email; ?>"><br>
Web Address: <input type="text" name="ud_web" value="<? echo $web; ?>"><br>
<input type="Submit" value="Update">
</form>

<?
++$i;
}
?>

Any ideas.

Thanks
Sam

Similar Threads

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in PHP

samtwilliams

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Dec 2008

Permalink

Dec 8th, 2008

Re: Warning: mysql_numrows()

Maybe try this... Its What I've used.
$num = mysql_num_rows($result);
it might help.

PomonaGrange

Reputation Points: 10

Solved Threads: 3

Junior Poster in Training

Offline

67 posts
since Jun 2008

Permalink

Dec 8th, 2008

Re: Warning: mysql_numrows()

this most likely means your query failed.

change:

PHP Syntax (Toggle Plain Text)
$query=" SELECT * FROM contacts WHERE id='$id'";
$result=mysql_query($query);
$query=" SELECT * FROM contacts WHERE id='$id'";
$result=mysql_query($query);

PHP Syntax (Toggle Plain Text)
$query="SELECT * FROM contacts WHERE id='$id'";
$result=mysql_query($query) or die( 'Error: ' . mysql_error() );
$query="SELECT * FROM contacts WHERE id='$id'";
$result=mysql_query($query) or die( 'Error: ' . mysql_error() );

you had an extra space in the query which might make it fail, but I am not sure.

Last edited by kkeith29; Dec 8th, 2008 at 7:05 pm.

kkeith29

Reputation Points: 235

Solved Threads: 193

Nearly a Posting Virtuoso

Offline

1,315 posts
since Jun 2007

Permalink

Dec 9th, 2008

Re: Warning: mysql_numrows()

Click to Expand / Collapse Quote originally posted by PomonaGrange ...

Maybe try this... Its What I've used.
$num = mysql_num_rows($result);
it might help.

i think the above is the solution....

Shanti C

Reputation Points: 137

Solved Threads: 162

Posting Virtuoso

Offline

1,641 posts
since Jul 2008

Permalink

Dec 10th, 2008

Re: Warning: mysql_numrows()

Use this..

PHP Syntax (Toggle Plain Text)
$num = mysql_num_rows($result);
$num = mysql_num_rows($result);

Aamit

Reputation Points: 3

Solved Threads: 15

Posting Whiz

Offline

341 posts
since Apr 2008

Permalink

Dec 10th, 2008

Re: Warning: mysql_numrows()

hi,
the above all solutions looks right...

still u didnt get this try to do this...

echo $id;

i think id value is null....

sarithak

Reputation Points: 10

Solved Threads: 7

Junior Poster

Offline

183 posts
since Aug 2008

Permalink

Dec 11th, 2008

Re: Warning: mysql_numrows()

2 things...

First in your sql query...
There is a space in your sql query..
" Select ......"
change it to :
$sql = "Select ....... ";

Secondly... u are using mysql_result just above the form thing,,

But before using the mysql_result thing, you have already closed the mysql connection.. i.e. mysql_close();

Remove it and move it to last of the page, after the <form>

php Syntax (Toggle Plain Text)
<?
$id=$_GET['id'];
$username="web183-sql";
$password="sqlpassword";
$database="web183-sql";
mysql_connect(localhost,$username,$password);
 
$query=" SELECT * FROM contacts WHERE id='$id'";
$result=mysql_query($query);
 
$num=mysql_numrows($result);
 
mysql_close();
 
$i=0;
while ($i < $num) {
 
$first=mysql_result($result,$i,"first");
$last=mysql_result($result,$i,"last");
$phone=mysql_result($result,$i,"phone");
$mobile=mysql_result($result,$i,"mobile");
$fax=mysql_result($result,$i,"fax");
$email=mysql_result($result,$i,"email");
$web=mysql_result($result,$i,"web");
?>
 
<form action="updated.php" method="post">
<input type="hidden" name="ud_id" value="<? echo $id; ?>">
First Name: <input type="text" name="ud_first" value="<? echo $first; ?>"><br>
Last Name: <input type="text" name="ud_last" value="<? echo $last; ?>"><br>
Phone Number: <input type="text" name="ud_phone" value="<? echo $phone; ?>"><br>
Mobile Number: <input type="text" name="ud_mobile" value="<? echo $mobile; ?>"><br>
Fax Number: <input type="text" name="ud_fax" value="<? echo $fax; ?>"><br>
E-mail Address: <input type="text" name="ud_email" value="<? echo $email; ?>"><br>
Web Address: <input type="text" name="ud_web" value="<? echo $web; ?>"><br>
<input type="Submit" value="Update">
</form>
 
<?
++$i;
}
?><?
$id=$_GET['id'];
$username="web183-sql";
$password="sqlpassword";
$database="web183-sql";
mysql_connect(localhost,$username,$password);
 
$query=" SELECT * FROM contacts WHERE id='$id'";
$result=mysql_query($query);
 
$num=mysql_numrows($result);
 
 
$i=0;
while ($i < $num) {
 
$first=mysql_result($result,$i,"first");
$last=mysql_result($result,$i,"last");
$phone=mysql_result($result,$i,"phone");
$mobile=mysql_result($result,$i,"mobile");
$fax=mysql_result($result,$i,"fax");
$email=mysql_result($result,$i,"email");
$web=mysql_result($result,$i,"web");
?>
 
<form action="updated.php" method="post">
<input type="hidden" name="ud_id" value="<? echo $id; ?>">
First Name: <input type="text" name="ud_first" value="<? echo $first; ?>"><br>
Last Name: <input type="text" name="ud_last" value="<? echo $last; ?>"><br>
Phone Number: <input type="text" name="ud_phone" value="<? echo $phone; ?>"><br>
Mobile Number: <input type="text" name="ud_mobile" value="<? echo $mobile; ?>"><br>
Fax Number: <input type="text" name="ud_fax" value="<? echo $fax; ?>"><br>
E-mail Address: <input type="text" name="ud_email" value="<? echo $email; ?>"><br>
Web Address: <input type="text" name="ud_web" value="<? echo $web; ?>"><br>
<input type="Submit" value="Update">
</form>
 
<?
++$i;
}
 
mysql_close();
?>
<?
$id=$_GET['id'];
$username="web183-sql";
$password="sqlpassword";
$database="web183-sql";
mysql_connect(localhost,$username,$password);

$query=" SELECT * FROM contacts WHERE id='$id'";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

$i=0;
while ($i < $num) {

$first=mysql_result($result,$i,"first");
$last=mysql_result($result,$i,"last");
$phone=mysql_result($result,$i,"phone");
$mobile=mysql_result($result,$i,"mobile");
$fax=mysql_result($result,$i,"fax");
$email=mysql_result($result,$i,"email");
$web=mysql_result($result,$i,"web");
?>

<form action="updated.php" method="post">
<input type="hidden" name="ud_id" value="<? echo $id; ?>">
First Name: <input type="text" name="ud_first" value="<? echo $first; ?>"><br>
Last Name: <input type="text" name="ud_last" value="<? echo $last; ?>"><br>
Phone Number: <input type="text" name="ud_phone" value="<? echo $phone; ?>"><br>
Mobile Number: <input type="text" name="ud_mobile" value="<? echo $mobile; ?>"><br>
Fax Number: <input type="text" name="ud_fax" value="<? echo $fax; ?>"><br>
E-mail Address: <input type="text" name="ud_email" value="<? echo $email; ?>"><br>
Web Address: <input type="text" name="ud_web" value="<? echo $web; ?>"><br>
<input type="Submit" value="Update">
</form>

<?
++$i;
}
?><?
$id=$_GET['id'];
$username="web183-sql";
$password="sqlpassword";
$database="web183-sql";
mysql_connect(localhost,$username,$password);

$query=" SELECT * FROM contacts WHERE id='$id'";
$result=mysql_query($query);

$num=mysql_numrows($result);


$i=0;
while ($i < $num) {

$first=mysql_result($result,$i,"first");
$last=mysql_result($result,$i,"last");
$phone=mysql_result($result,$i,"phone");
$mobile=mysql_result($result,$i,"mobile");
$fax=mysql_result($result,$i,"fax");
$email=mysql_result($result,$i,"email");
$web=mysql_result($result,$i,"web");
?>

<form action="updated.php" method="post">
<input type="hidden" name="ud_id" value="<? echo $id; ?>">
First Name: <input type="text" name="ud_first" value="<? echo $first; ?>"><br>
Last Name: <input type="text" name="ud_last" value="<? echo $last; ?>"><br>
Phone Number: <input type="text" name="ud_phone" value="<? echo $phone; ?>"><br>
Mobile Number: <input type="text" name="ud_mobile" value="<? echo $mobile; ?>"><br>
Fax Number: <input type="text" name="ud_fax" value="<? echo $fax; ?>"><br>
E-mail Address: <input type="text" name="ud_email" value="<? echo $email; ?>"><br>
Web Address: <input type="text" name="ud_web" value="<? echo $web; ?>"><br>
<input type="Submit" value="Update">
</form>

<?
++$i;
}

mysql_close();
?>

sikka_varun

Reputation Points: 11

Solved Threads: 12

Junior Poster in Training

Offline

94 posts
since Dec 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: header problems

Next Thread in PHP Forum Timeline: problem passing a NULL value to MySQL using a php variable

DaniWeb Message

Cancel Changes

User Name
Password