Updating an integer defined column in a MySQL DB with PHP
Posted
by Zloy Smiertniy
on Stack Overflow
See other posts from Stack Overflow
or by Zloy Smiertniy
Published on 2010-05-08T21:09:05Z
Indexed on
2010/05/08
21:18 UTC
Read the original article
Hit count: 147
I have a table defined like this:
create table users (
id int(10),
age int(3),
name varchar (50)
)
I want to use a query to update just age, which is an integer, that comes from an html form.
When it arrives to the method that updates it, it comes as a string, so I change it to integer with PHP and try to update the table, but it doesn't work
$age = intval($age);
$q2 = "UPDATE users SET age='$age' where username like '$username';";
mysql_query($q2,$con);
© Stack Overflow or respective owner
