Одну проблему решили но теперь ищё бадяга (((
ERROR 0 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 '' at line 4
mod.
php
<?php
require_once ('bd_conect.php');
echo "ERROR ".mysql_errno()." ".mysql_error()."\n";
mysql_query ("SELECT * FROM `GPS_table`");
$q = mysql_query ("SELECT * FROM GPS_table");
if ( empty($row['data']))
$name=trim($_POST['name']);
$data=trim($_POST['data']);
$smena=trim($_POST['smena']);
$nomerpytevogolista=trim($_POST['nomerpytevogolista']);
$nomertabelnogo=trim($_POST['nomertabelnogo']);
$driver=trim($_POST['driver']);
$probegpytevogolista=trim($_POST['probegpytevogolista']);
$probegGPS=trim($_POST['probegGPS']);
$ostatoktoplivaprivuezde=trim($_POST['ostatoktoplivaprivuezde']);
$zapravka=trim($_POST['zapravka']);
$ispolzovanoGPS=trim($_POST['ispolzovanoGPS']);
$ispolzovanopytevka=trim($_POST['ispolzovanopytevka']);
$ostatokvozvrata=trim($_POST['ostatokvozvrata']);
$pererabotkachasov=trim($_POST['pererabotkachasov']);
$ekonomia=trim($_POST['ekonomia']);
$pererasxod=trim($_POST['pererasxod']);
$kmproideno=trim($_POST['kmproideno']);
$litrovpotracheno=trim($_POST['litrovpotracheno']);
$procentzimaleto=trim($_POST['procentzimaleto']);
$insert_sql = "INSERT INTO card_run (data,smena,nomerpytevogolista,nomertabelnogo,driver,probegpytevogolista,probegGPS,ostatoktoplivapriv uezde,zapravka,ispolzovanoGPS,ispolzovanopytevka,ostatokvozvrata,pererabotkachasov,ekonomia,pererasxo d,kmproideno,litrovpotracheno,procentzimaleto) VALUES
('$data','$smena','$nomerpytevogolista','$nomertabelnogo','$driver','$probegpytevogolista','$probegGPS','$ostatoktoplivaprivuezde',
'$zapravka','$ispolzovanoGPS','$ispolzovanopytevka','$ostatokvozvrata','$pererabotkachasov','$ekonomia','$pererasxod','$kmproideno',
'$litrovpotracheno','$procentzimaleto',";
mysql_query($insert_sql)
or die(mysql_error());
?>
и
<form action="php/mod.php" method ="POST">
<fieldset>
<label for="data" > Дата :</label>
<input type = "text" name='data' size="50"/></br>
<label for="smena" > smena :</label>
<input type = "text" name='smena' size="50"/></br>
<label for="nomerpytevogolista" > nomerpytevogolista :</label>
<input type = "text" name='nomerpytevogolista' size="50"/></br>
<label for="nomertabelnogo" > nomertabelnogo :</label>
<input type = "text" name='nomertabelnogo' size="50"/></br>
<label for="driver" > driver :</label>
<input type = "text" name='driver' size="50"/></br>
<label for="probegpytevogolista" > probegpytevogolista :</label>
<input type = "text" name='probegpytevogolista' size="50"/></br>
<label for="probegGPS" > probegGPS :</label>
<input type = "text" name='probegGPS' size="50"/></br>
<label for="ostatoktoplivaprivuezde" > ostatoktoplivaprivuezde :</label>
<input type = "text" name='ostatoktoplivaprivuezde' size="50"/></br>
<label for="zapravka" > zapravka :</label>
<input type = "text" name='zapravka' size="50"/></br>
<label for="ispolzovanoGPS" > ispolzovanoGPS :</label>
<input type = "text" name='ispolzovanoGPS' size="50"/></br>
<label for="ispolzovanopytevka" > ispolzovanopytevka :</label>
<input type = "text" name='ispolzovanopytevka' size="50"/></br>
<label for="ostatokvozvrata" > ostatokvozvrata :</label>
<input type = "text" name='ostatokvozvrata' size="50"/></br>
<label for="pererabotkachasov" > pererabotkachasov :</label>
<input type = "text" name='pererabotkachasov' size="50"/></br>
<label for="ekonomia" > ekonomia :</label>
<input type = "text" name='ekonomia ' size="50"/></br>
<label for="pererasxod" > pererasxod :</label>
<input type = "text" name='pererasxod ' size="50"/></br>
<label for="kmproideno" > kmproideno :</label>
<input type = "text" name='kmproideno ' size="50"/></br>
<label for="litrovpotracheno" > litrovpotracheno :</label>
<input type = "text" name='litrovpotracheno ' size="50"/></br>
<label for="procentzimaleto" > procentzimaleto :</label>
<input type = "text" name='procentzimaleto ' size="50"/></br>
</fieldset>
</br>
<fieldset class="center">
<input type = "submit" value="отправить" />
<input type = "reset" value="очистить" />
</fieldset>
</form>