Jump to content

Archived

This topic is now archived and is closed to further replies.

spikes1

UPDATE problems

Recommended Posts

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 SET
birthday='$_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 anyway

Spikes1

Share this post


Link to post
Share on other sites
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]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.