update record error-mysql_numrows(): supplied argument is not a valid MySQL

[san_cash]

Hi!, I am trying to update record but an error is coming. Can any one help.
error is - mysql_numrows(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\xampp\Test\Report\Despatch\update.php on line 10
here is the script

<?
$id=$_GET['id'];
$username="root";
$password="mysql";
$database="service";
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");

++$i;
}
?>

First Name:

Last Name:

Phone Number:

Mobile Number:

Fax Number:

[Shanti C]

just echo this line and execute that query on your database area

$query = "SELECT * FROM contacts WHERE id = '$id'";

or post your table structure..

[Aamit]

hi,
problem is here you have forget to write (_)

$num = mysql_numrows($result);

change it to

$num = mysql_num_rows($result);

hope will help u..

[Shanti C]

ya exactly,, i even don't see this before..

[Aamit]

ya exactly,, i even don't see this before..

thanks..mark thread as solved

[san_cash]

hi, problem is here you have forget to write (_)

$num = mysql_numrows($result);

change it to

$num = mysql_num_rows($result);

hope will help u..

I tried but still the following errar is coming

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\xampp\Test\Report\Despatch\update.php on line 10

[Aamit]

If you are not setting password then left blank or write your password

$con = mysql_connect("localhost","root","");
	if (!$con)
	  {
	  die('Could not connect: ' . mysql_error());
	  }
	  else
	  {
	 // echo('Connected with Mysql');
	  }
		@mysql_select_db("service", $con);

$id=$_GET['id'];
echo $query = "SELECT * FROM contacts WHERE id = '$id'";
$result = mysql_query($query);
echo "num of rows".$num = mysql_num_rows($result);

check what result you get..

[san_cash]

hi amith, i tried that too but still its telling the error.

hi, problem is here you have forget to write (_)

$num = mysql_numrows($result);

change it to

$num = mysql_num_rows($result);

hope will help u..

[Aamit]

If you are not setting password then left blank or write your password

$con = mysql_connect("localhost","root","");
	if (!$con)
	  {
	  die('Could not connect: ' . mysql_error());
	  }
	  else
	  {
	 // echo('Connected with Mysql');
	  }
		@mysql_select_db("service", $con);

$id=$_GET['id'];
echo $query = "SELECT * FROM contacts WHERE id = '$id'";
$result = mysql_query($query);
echo "num of rows".$num = mysql_num_rows($result);

check what result you get..

please check the post and tell me the result...

[kkeith29]

You most likely have a problem with your query.
Replace:

$result = mysql_query($query);

with

$result = mysql_query($query) or die(mysql_error());

This will show the error.

[nav33n]

You are not selecting any database :) mysql_select_db("Databasename");

[san_cash]

Amith, it says database not selected. Sorry but i am just started with learning php & mysql. following is the script

<?
$id=$_GET['id'];
$username="root";
$password="mysql";
$database="service";
mysql_connect(localhost,$username,$password);

$query = "SELECT * FROM contacts WHERE id = '$id'";
$result = mysql_query($query) or die(mysql_error());$result = mysql_query($query) or die(mysql_error());
$num = mysql_num_rows($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");

++$i;
}
?>

First Name:

Last Name:

Phone Number:

Mobile Number:

Fax Number: