RE: PHP and MySQL

Here's at least one of your problems:

<input type="hidden" name="<?php $keycode ?>" value="<?php echo $keycode
?> "/>

Should be:

<input type="hidden" name="keycode" value="<?php echo $keycode ?> "/>

Also, is keycode a numeric column?

Keith Davis (214) 906-5183


-----Original Message-----
From: Gavin Chalkley [mailto:[email protected]] 
Sent: Sunday, April 17, 2011 3:34 PM
To: [email protected]
Subject: [PHP-WIN] PHP and MySQL

Evening all,

I am trying to run an update form but struggerling :(

Think my brain has had enough this weekend....

########################################################################
#
Form:

<form action="update.php" method="post"> <h1><?php echo "$navLink" ?>
Page</h1> <br/><hr/><br/> <script type="text/javascript"> TinyMCE Script
</script> <textarea id="content_2" name="content_2" rows="11"
style="width:400px"> <?php echo "$content" ?> </textarea> <br/><br/>
<input type="submit" name="Button" value="Update Page"/> <input
type="hidden" name="<?php $keycode ?>" value="<?php echo $keycode ?> "/>
</form>

########################################################################
#

Update.php :
<?php
include("_inc\access.inc");
$cxn = mysqli_connect ($host,$user,$passwd,$dbname) or die ("Connection
Failed"); $sql = "UPDATE contenttop SET content='$_POST[content_2]'
WHERE keycode='$_POST[keycode]'";
$result = mysqli_query($cxn,$sql)
or die ("UPDATE Failed " .mysqli_error($cxn)); ?>

It doesn't seem to update the database, which is the last thing i need
to sort out before the CMS is done

Can some one assist??

DB columns:
keycode navLink content
--
Best regards,

Gavin C


This message (including any attachments) may contain confidential or otherwise privileged information and is intended only for the individual(s) to which it is addressed. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secured or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message or that arise as a result of e-mail transmission. If verification is required please request a hard-copy version from the sender.

www.pridedallas.com


-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php