Tuesday, 13 August 2013

Insert captured data from html form in mysql in all caps

Insert captured data from html form in mysql in all caps

is there a way that i can insert entered data from the html form in mysql
table all in caps so that when my table is displayed it is all in the same
format? For example how can i re-write this statement to insert data in
all caps.
$sql2 = "INSERT INTO `area`(name, hub, fk_hub_id) VALUES
('$areaname',(SELECT `name` from hub WHERE name = '$hub'),
(SELECT `id` from hub WHERE name = '$hub'))";

No comments:

Post a Comment