Jump to content

UPDATE wont work


princeofpersia

Recommended Posts

Hi guys,

 

I have an update page where users can update their information, i have a different update page which works fine with almost the same code, but this one wont update anything.

 

it does show the data but it wont update it,

can u help please?

 

 

<?php
session_start();

include ("../../global.php");
//welcome messaage
$username=$_SESSION['username'];
echo "$username";

$query=mysql_query("SELECT id FROM users WHERE username='$username'");
while($row = mysql_fetch_assoc($query))
{
$user_id = $row['id'];
}



$ref=$_GET['reference'];


if (isset($_POST['register']) && $_POST['register']){



$title = addslashes(strip_tags($_POST['title']));






$update=mysql_query("UPDATE msg SET title ='$title' WHERE reference='$ref'");






}



?>



<html>



<head>
    </head>



<body>



<form action='edit-msgs.php' method='POST' enctype='multipart/form-data'>



  Title:<br />
    <input type='text' name='title'  id='title' value='<?php 



$getdata = "SELECT title FROM msg WHERE reference='$ref' AND referal_id='$user_id'";
$result = mysql_query($getdata);
$row = mysql_fetch_assoc($result);



echo $row['title'];?>'><p />




    <input type='submit' name='register' value='Update'>
</form>
</body>
</html>


 

 

 

 

 

Link to comment
https://forums.phpfreaks.com/topic/223323-update-wont-work/
Share on other sites

Archived

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

×
×
  • Create New...

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.