Having trouble updating database using php

Question

I have a database called specials with a table called specials, the table has 6 rows, there are 3 records a record with an id of 1,2, and 3. One of the rows is called title. I have data already there but I want to update the data using a form. How ever my mysqli_query is not working.

Here is my code.

mysqli_query($connect, "UPDATE specials SET title=san diego WHERE id='1'");

corrected:- UPDATE specials SET title='san diego' WHERE id='1' — Ramesh_D, May 30 '14 at 05:14
possible duplicate of [UPDATE from SELECT using SQL Server](http://stackoverflow.com/questions/2334712/update-from-select-using-sql-server) — alloc_iNit, May 30 '14 at 08:27

score 1 · Answer 1 · answered May 30 '14 at 05:13

1

Assuming title is varchar and id is int

mysqli_query($connect, "UPDATE specials SET title='san diego' WHERE id=1");

answered May 30 '14 at 05:13

Ing. Michal Hudak

5,338
11
60
91

Rakesh Sharma · Answer 2 · 2014-05-30T05:19:20.000

1

you are inserting a string in varchar field so it should be quoted also try

mysqli_query($connect, "UPDATE specials SET title='san diego' WHERE id=1");

if datatype is varchar string should be quoted like title='san diego'

if int no need to quote (but you can use with quote) id = 1

edited May 30 '14 at 05:19

answered May 30 '14 at 05:13

Rakesh Sharma

13,680
5
37
44

score 1 · Answer 3 · answered May 30 '14 at 05:13

1

Try this :

mysqli_query($connect, "UPDATE specials SET title='san diego' WHERE id = 1");

answered May 30 '14 at 05:13

Tanatos

1,857
1
13
12

score 0 · Answer 4 · answered May 30 '14 at 05:13

0

Try following:

mysqli_query($connect, "UPDATE specials SET title='san diego' WHERE id=1");

If your id is type of Int and title of Varchar

answered May 30 '14 at 05:13

Manwal

23,450
12
63
93

Having trouble updating database using php

4 Answers4