All pastes #770672 Raw Edit

kosjak

public text v1 · immutable
·published 2007-11-12 14:20 UTC
rendered paste body
CREATE TABLE `houses` (
`house_id` SMALLINT( 4 ) NOT NULL ,
`house_name` VARCHAR( 30 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL 
) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci;

	mysql_query("SET NAMES utf8");
	mysql_query("insert into houses (house_id, house_name) values ($hid, mysql_escape_string($hname))") or die('Unable to execute query'.mysql_error().''.mysql_errno());