unexpected error

php, mysql form

[armaganonur]

- pHpMyAdmin SQL Dump
-- version 2.9.0.2
-- [phpmyadmin.net...]
--
-- Anamakine: localhost
-- Üretim Zamanı: 21 Nisan 2007 saat 01:55:07
-- Sunucu sürümü: 4.1.20
-- PHP Sürümü: 4.4.2
--
-- Veritabanı: `hz_site`
--

-- --------------------------------------------------------

--
-- Tablo yapısı: `Siteler`
--

CREATE TABLE `Siteler` (
`id` int(10) unsigned NOT NULL auto_increment,
`pass` tinytext NOT NULL,
`adi` mediumtext NOT NULL,
`sektor` mediumtext,
`hizmet` mediumtext,
`tarihce` mediumtext,
`referans` text,
`iletisim` mediumtext NOT NULL,
`diger` mediumtext,
`not` mediumtext,
`ip` int(11) NOT NULL default '0',
`tarih` date NOT NULL default '0000-00-00',
`saat` time NOT NULL default '00:00:00',
PRIMARY KEY (`id`),
KEY `tarih` (`tarih`)
) ENGINE=MyISAM DEFAULT CHARSET=latin5 AUTO_INCREMENT=1 ;

--
-- Tablo döküm verisi `Siteler`
--

--------------------------------------------------form--------------------

<?php echo"
<div align='center'><h3>Site içeriği Oluşturma Formu</h3></div><br />
<form action='yaz.php' method='post' class='Form' name='form' lang='tr'><table width='800' border='1' cellpadding='0' cellspacing='0' bordercolor='#999999' bgcolor='#CCCCCC' name='cosar'>

<tr>
<td colspan='4' ><input size='10' name='tablo' type='hidden' maxlength='10' value='Siteler' />
<strong>Site İçeriği yaratma formundaki ilgili alanları mümkün olduğu kadar doldurunuz. </strong> Şifre:
<input size='10' name='pass' type='password' maxlength='10' />
</td>
</tr>

<tr>
<td>Firmanın Adı, varsa eski web sitesi </td>
<td colspan='3' width='418'><textarea name='adi' rows='2' cols='130'>boş olamaz</textarea> </td>
</tr>

<tr>
<td width='52' height='65'>Sektör bilgileri</td>
<td colspan='3'><textarea name='sektor' rows='5' cols='130'></textarea></td>
</tr>

<tr>
<td>Hizmet alanları </td>
<td colspan='3' width='418'><textarea name='hizmet' rows='5' cols='130'></textarea>
</td>
</tr>

<tr>
<td>Tarihçe</td>
<td colspan='3' width='418'><textarea name='tarihce' rows='5' cols='130'></textarea>
</td>
</tr>
<tr>
<td>Referanslar</td>
<td colspan='3' width='418'><textarea name='referans' rows='5' cols='130'></textarea>
</td>
</tr>
<tr>
<td>İletişim</td>
<td colspan='3' width='418'><textarea name='iletisim' rows='5' cols='130'>boş olamaz</textarea></td>
</tr>
<tr>
<td>Diğer</td>
<td colspan='3' width='418'><textarea name='diger' rows='5' cols='130'></textarea></td>
</tr>
<tr>
<td>Not-Ek</td>
<td colspan='3' width='418'><textarea name='not' rows='5' cols='130'></textarea><br />
<input size='10' name='ip' type='text' readonly='read-only' value='$ip' />
<input size='10' name='tarih' type='text' readonly='read-only' value='$tarih' />
<input size='10' name='saat' type='text' readonly='read-only' value='$saat' />
</td>
</tr>
</table><input name='submit' value='Gönder' type='submit' /><input type='reset' value='Sil' name='sil' />
</form><br />";

?>

--------------------------------------------------yaz.php------------------------------

<?php

require_once("ayar.php");
require_once("bagla.php");
$pass=strtolower($_POST[pass]);
if ($pass=="m3t" ¦¦ "k1t")
{
$sql="INSERT INTO $_POST[tablo] (pass, adi, sektor, hizmet, tarihce, referans, iletisim, diger, not, ip, tarih, saat)
VALUES
('$_POST[pass]','$_POST[adi]','$_POST[sektor]','$_POST[hizmet]','$_POST[tarihce]', '$_POST[referans]','$_POST[iletisim]','$_POST[diger]','$_POST[not]','$_POST[ip]', '$_POST[tarih]','$_POST[saat]')";

if (!mysql_query($sql,$bagla))
{
die('Error: ' . mysql_error());
}
echo "<meta http-equiv='refresh' CONTENT='0.5;URL= /?sayfa=iki' /><div style='margin-top:300px;font-size:20px;
color:#993333'
align='center'>Kayıt Yapıldı</div>";
}
else {
echo "<meta http-equiv='refresh' CONTENT='0.5;URL= /?sayfa=bir' /><div style='margin-top:300px;font-size:20px;
color:#993333'
align='center'>Geçersiz Şifre</div>";
}
mysql_close($bagla);

?>

--------------------------------------------------error---------------------
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'not, ip, tarih, saat) VALUES ('k1t','boş olamaz','','','','','boş olamaz','',' at line 1
------------------------------
i think very easy problem, but i cannot seeing.

[edited by: eelixduppy at 3:36 am (utc) on April 22, 2007]
[edit reason] fixed side scroll [/edit]

[eelixduppy]

NOT is a reserved word. Try something like this:

$sql="INSERT INTO $_POST[tablo] (pass, adi, sektor, hizmet, tarihce, referans, iletisim, diger, `not`, ip, tarih, saat)...

Notice the prime character around not in the above example.

And welcome to webmasterworld! :)

[armaganonur]

thank you so much,
but 'not' is not working,
noti is working
:)

[eelixduppy]

hehe...glad you figured it out!

Incorrect spelling seems to cause most error ;)