Updating an integer defined column in a MySQL DB with PHP
- by Zloy Smiertniy
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);
