Updating the DB

[Chris2k]

Well here's my code:

                    $newName = $_POST['sName'];
                    $newUrl = $_POST['sURL'];
                    $newRate = $_POST['sRate'];
                    $newEmail = $_POST['sEmail'];
                    $reason = $_POST['sReason'];
                    
                    mysql_query("update wcddl_sites set name='$newName',url='$newUrl',rate='$newRate',email='$newEmail' WHERE id='". mysql_real_escape_string($sid) ."'"); 

It's just not doing that..........?

Any ideas?

Chris2k Reviewed by Chris2k on 25th Mar 2012. Updating the DB Well here's my code: $newName = $_POST; $newUrl = $_POST; $newRate = $_POST; $newEmail = $_POST; $reason = $_POST; mysql_query("update wcddl_sites set name='$newName',url='$newUrl',rate='$newRate',email='$newEmail' WHERE id='". mysql_real_escape_string($sid) ."'"); Rating: 5

[soft2050]

Replace query code with:

mysql_query("update wcddl_sites set name='$newName',url='$newUrl',rate='$newRate',email='$newEmail' WHERE id='". mysql_real_escape_string($sid) ."'") or die ("Error: " . mysql_error()); 

It should give show the error in query

[Chris2k]

added, didn't give me an error..

[CJ]

add this to ur file
error_reporting(E_ALL);
& u might see the error which is stoping it from working

[Lock Down]

Where is the $sid coming from you are basing your update on??

[Chris2k]

$sid is from:

            while($sInfo = mysql_fetch_assoc($get)) {
                $sid = $sInfo['id'];            
                $sname = $sInfo['name'];
                $srate = $sInfo['rate'];
                $semail = $sInfo['email'];

form data here....................
} 

[deAthbLisS]

mysql_query("update wcddl_sites set name='" . $newName . "',url='" . $newUrl . "',rate='" . $newRate . "',email='" . $newEmail . "' WHERE id='". mysql_real_escape_string($sid) ."'"); 

try this

[Lock Down]

So you can see the query and try it in phpmyadmin change your code to this:

$newName = $_POST['sName']; 
                    $newUrl = $_POST['sURL']; 
                    $newRate = $_POST['sRate']; 
                    $newEmail = $_POST['sEmail']; 
                    $reason = $_POST['sReason']; 
                    $q = "update wcddl_sites set name='$newName',url='$newUrl',rate='$newRate',email='$newEmail' WHERE id='". mysql_real_escape_string($sid) ."'";
                    echo "query is : $q";
                    mysql_query($q);