INSERT INTO
`options` SET
`usr` = \'$log\',
`chat` = \'yes\',
`paty` = \'yes\',
`foot` = \'pic\',
`theme` = \'style\',
`pic` = \'yes\',
`privat` = \'yes\';
Не обрабатывает запрос в foot , почему ??
Добавлено 29.12.13 в 03:06:29:
#1054 - Unknown column \'foot\' in \'field list\'
Добавлено 29.12.13 в 03:06:37:
Пишет так
////////////////////////////////////////////////////////////////////////////////
$req = mysql_query(\"SELECT * FROM `options` where `usr`=\'$log\' LIMIT 1\"
$avto=mysql_num_rows($req);
if($avto==0) // создаем юзеру таблицу настроек если нет её
{ mysql_query(\"INSERT INTO
`options` SET
`usr` = \'$log\',
`chat` = \'yes\',
`paty` = \'yes\',
`foot` = \'pic\',
`theme` = \'style\',
`pic` = \'yes\',
`privat` = \'yes\'\"}
////////////////////////////////////////////////////////////////////////////////
<?
mysql_query(\"INSERT INTO
`options` SET
`usr` = \'$log\',
`chat` = \'yes\',
`paty` = \'yes\',
`foot` = \'pic\',
`theme` = \'style\',
`pic` = \'yes\',
`privat` = \'yes\'\"
?>
<?
$req = mysql_query(\"SELECT * FROM `options` where `usr`=\'$log\' LIMIT 1\"
?>