Update Command Not working mysqli

Asked Nov 20 '17 at 18:31

Active Nov 20 '17 at 18:40

Viewed 30 times

<?php include('header.php'); 
include('config.php');
if (isset($_POST['submit']))
{
    $link1=mysqli_real_escape_string($cone,$_POST['link1']);
    $link2=mysqli_real_escape_string($cone,$_POST['link2']);
    $link3=mysqli_real_escape_string($cone,$_POST['link3']);
    $link4=mysqli_real_escape_string($cone,$_POST['link4']);
    $link5=mysqli_real_escape_string($cone,$_POST['link5']);
    $sql = "update path set 1='hello' where id=1";
    if (mysqli_query($cone,$sql))
    {
        header("location:section_6.php?done");
    }
}
?>

What am i doing wrong here ? The Cone variable is defined in config.php but i can't get the update working and there's no error.

edited Nov 20 '17 at 18:33

hnefatl

5,860
2
27
49

asked Nov 20 '17 at 18:31

Ashish Choudhary

2

`set 1` - is `1` the actual column name? – Funk Forty Niner Nov 20 '17 at 18:33
yes there are 5 columns named as 1,2,3,4,5 respectively. – Ashish Choudhary Nov 20 '17 at 18:34
Consult the duplicate the question was closed with. – Funk Forty Niner Nov 20 '17 at 18:35
Related: [When to use single quotes, double quotes, and backticks in MySQL](https://stackoverflow.com/questions/11321491/when-to-use-single-quotes-double-quotes-and-backticks-in-mysql) – FirstOne Nov 20 '17 at 18:37
2

@AshishChoudhary You should rename those columns for sure. – GrumpyCrouton Nov 20 '17 at 18:38
@FirstOne why is that? I don't see anything related to this. See the duplicate; that's the reason here. – Funk Forty Niner Nov 20 '17 at 18:39
1

Don't use numbers as column names. – chris85 Nov 20 '17 at 18:50

Update Command Not working mysqli

0 Answers0