spikes1 Posted May 19, 2006 Share Posted May 19, 2006 Well, if someone can please help me with this : I tried about everything, but, it won't work, no error message either.First page (publication and modifying the date[code]<input type="hidden" name="id" value="<? echo $_POST['id']; ?>"><input type="hidden" name="birthday" value="<? echo $_POST['birthday']; ?>"><input type="hidden" name="phone" value="<? echo $_POST['phone']; ?>"><input type="hidden" name="fax" value="<? echo $_POST['fax']; ?>"><input type="hidden" name="cellularPhone" value="<? echo $_POST['cellularPhone']; ?>"><input type="hidden" name="actif" value="<? echo $_POST['actif']; ?>"><input type="hidden" name="approuved" value="<? echo $_POST['approuved']; ?>">[/code]and this is my procedure :[code]<? require("session.php"); require("connection_data.php"); require("mysql_func.php"); connect(); $sql = "UPDATE maillist SETbirthday='$_POST['birthday']',phone='$_POST['phone']',fax='$_POST['fax']',cellularPhone='$_POST['cellularPhone']',actif='$_POST['actif']',approuved='$_POST['approuved']'WHERE id='$_POST['id']'";mysql_query ($sql); header("Location: administration.php");?>[/code]What am I doing wrong ?Thanks anywaySpikes1 Quote Link to comment https://forums.phpfreaks.com/topic/9987-update-problems/ Share on other sites More sharing options...
Honoré Posted May 19, 2006 Share Posted May 19, 2006 try the following SQL statement:[code]$sql = "UPDATE maillist SET birthday='" .$_POST['birthday']. "', phone='" .$_POST['phone']. "', fax='" .$_POST['fax']. "', cellularPhone='" .$_POST['cellularPhone']. "', actif='" .$_POST['actif']. "', approuved='" .$_POST['approuved']. "' WHERE id='" .$_POST['id']. "'";[/code] Quote Link to comment https://forums.phpfreaks.com/topic/9987-update-problems/#findComment-37106 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.