Update records -- error comes up

careym1989

Hello everyone!

I'm trying to update records on my MySQL database. Everything loads fine and data is displayed. I change a field and click submit and this error comes up:

Warning: mysql_affected_rows(): supplied argument is not a valid MySQL-Link resource in /home/content/s/r/a/srasoul/html/content_Management/ff_VetProcess.php on line 20

Then nothing is displaying in the form.

Here's my code:

<?php

include("connectdb.php");

if($_POST['Submit']){


$id=$_POST['id'];
$n=$_POST['n'];
$cc=$_POST['cc'];
$st=$_POST['st'];
$ea=$_POST['ea'];
$cd=$_POST['cd'];
$url=$_POST['url'];
$approved=$_POST['approved'];


$updateResult = mysql_query("update candidatesubmit set n='$n', cc='$cc', st='$st', ea='$ea', cd='$cd', url='$url', approved='$approved' where id='$id'");

if (mysql_affected_rows($updateResult) > 0)
{
   header("location:ff_View.php");
   exit;
}
else
{
     echo mysql_error();
}
}


$id=$_GET['id'];

$result=mysql_query("select * from candidatesubmit where id='$id'");

$row=mysql_fetch_assoc($result);

mysql_close();
?>


<html>
<body>
<form method="post" action="<? echo $PHP_SELF; ?>">
<p>Name : 
<input name="n" type="text" id="n" value="<? echo $row['n']; ?>"/>
<br />
<p>City County Come From : 
<input name="cc" type="text" id="cc" value="<? echo $row['cc']; ?>"/>
<br />
<p>State : 
<input name="st" type="text" id="st" value="<? echo $row['st']; ?>"/>
<br />
<p>Email : 
<input name="ea" type="text" id="ea" value="<? echo $row['ea']; ?>"/>
<br />
<p>Office Held / Currently Running For : 
<input name="cd" type="text" id="cd" value="<? echo $row['cd']; ?>"/>
<br />
<p>URL : 
<input name="url" type="text" id="url" value="<? echo $row['url']; ?>"/>
<br />
<p>Approved : 
<input name="approved" type="text" id="approved" value="<? echo $row['approved']; ?>"/>
<br />

</p>
<p>
<input type="submit" name="Submit" value="Submit" />
</p>
</form> 
</body>
</html>

Help would be greatly appreciated.

Thanks a lot,
C

NogDog

The argument to mysql_affected_rows() is your connection (link) resource (from mysql_connect()), not your query result resource. (If you are only using one connection, you can just leave its argument list empty.)

careym1989

Hey NogDog!

Thanks for responding so quickly -- I appreciate it.

However, I am a pretty big noob and I do not quite understand what you're saying. Would you mind putting it into layman's terms?

Regards,
C

NogDog

$updateResult is a query result "resource" (a special type of variable in PHP). But the mysql_affected_rows() function does not want a query result resource as its function argument (a.k.a. "parameter"). Instead, it wants the mysql connection (link) resource which is returned by mysql_connect(). So instead of...

mysql_affected_rows($updateResult)

...you need to either replace $updateResult with the variable that holds the result of your mysql_connect() call (presumably in that include file), or just remove $updateResult and leave it empty, since mysql_affected_rows() will use the last opened connection by default if none is specified.

careym1989

FYI:

I hope this doesn't change anything, but I'm running PHP 4.x. I see your signature, NogDog.

Appreciate the help.

I'm trying to understand and I hate to wear thin on your patience.

Here's my code so far:

<?php

include("cdb.php");

if($_POST['Submit']){


$id=$_POST['id'];
$n=$_POST['n'];
$cc=$_POST['cc'];
$st=$_POST['st'];
$ea=$_POST['ea'];
$cd=$_POST['cd'];
$url=$_POST['url'];
$approved=$_POST['approved'];

if (mysql_affected_rows($cdb) > 0)
{
   mysql_query("UPDATE candidatesubmit SET n='$n', cc='$cc', st='$st', ea='$ea', cd='$cd', url='$url', approved='$approved' WHERE id='$id'");
   header("location:ff_View.php");
   exit;
}
else
{
     echo mysql_error();
}
}


$id=$_GET['id'];

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

$row=mysql_fetch_assoc($result);

mysql_close();
?>


<html>
<body>
<form method="post" action="<? echo $PHP_SELF; ?>">
<p>Name : 
<input name="n" type="text" id="n" value="<? echo $row['n']; ?>"/>
<br />
<p>City County Come From : 
<input name="cc" type="text" id="cc" value="<? echo $row['cc']; ?>"/>
<br />
<p>State : 
<input name="st" type="text" id="st" value="<? echo $row['st']; ?>"/>
<br />
<p>Email : 
<input name="ea" type="text" id="ea" value="<? echo $row['ea']; ?>"/>
<br />
<p>Office Held / Currently Running For : 
<input name="cd" type="text" id="cd" value="<? echo $row['cd']; ?>"/>
<br />
<p>URL : 
<input name="url" type="text" id="url" value="<? echo $row['url']; ?>"/>
<br />
<p>Approved : 
<input name="approved" type="text" id="approved" value="<? echo $row['approved']; ?>"/>
<br />

</p>
<p>
<input type="submit" name="Submit" value="Submit" />
</p>
</form> 
</body>
</html>

My connect function in cdb.php is related to $cdb.

Here's cdb.php (my database connect include) with the info blanked out:

<?

$cdb = mysql_connect("xxx", "xxx", "xxx"); 
	   mysql_select_db("xxx"); 

?>

Now, I submit and it redirects me to a blank form page -- not the header.

Sorry I'm such a noob guys! :-p

Regards,
C