changing data in a table

[manupr]

Hi im tring to change the confrmation from a row from no to yes when it is clicked on. This is the code i have to change no to yes but its not working.

any help is apprsheateted

<?php
include ('config.php');
 
$con = mysql_connect("$mysql_host", "$mysql_user", "$mysql_password");
 
mysql_select_db($mysql_database, $con);
 
$id=$_GET['bookid'];
 
$confirmquery = mysql_query(" UPDATE names SET conformation = now(), confirm = 'Yes' WHERE bookid=" .$id);
mysql_query($confirmquery);
 
header ("Location: bookingtable.php");
exit();
 
?>

[ThumbtackMedia]

Try double checking the field names to the table, I see on line 10 your have

conformation = now()

should that be confirmation? ('i' instead of 'o')?

[manupr]

thanks the problem was i wanted to set conformation as yes not confirm so changed that word and it work thanks mate

[Andelys]

other great php toturials are found here.
http://807563a3.linkgalleries.net