[SOLVED]SQL query not working
Posted: Wed Feb 16, 2005 1:16 pm
Code: Select all
<?
require_once('config1.php');
$db = mysql_connect($host, $dbusername, $dbpassword) or die("No connection to MySQL Server");
mysql_select_db($dbname,$db) or die("Can't select database ".mysql_error() . ") ");
printf('<form method="post">
<table width="1013" height="732" border="1">
<tr>
<th width="177" scope="col">MATERIAAL</th>
<th width="8" scope="col"> </th>
<th width="65" scope="col">AANTAL</th>
<th width="64" scope="col">LENGTE(mm)</th>
<th width="75" scope="col"><p>BREEDTE(mm)</p>
</th>
<th width="68" scope="col">KANT LENGTE </th>
<th width="68" scope="col">KANT LENGTE </th>
<th width="75" scope="col">KANT BREEDTE</th>
<th width="75" scope="col">KANT BREEDTE</th>
<th width="274" scope="col">REFERENTIE</th>
</tr>
<tr>
<th scope="row"><select name="MATERIAAL" size="1">
<option selected value="wit 18mm">wit 18mm</option>
<option value="wit 8mm">wit 8mm</option>
<option value="unikleur 18mm">unikleur 18mm</option>
<option value="unikleur 8mm">unikleur 8mm</option>
<option value="structuurL 18mm">structuurL 18mm</option>
<option value="structuurL 8mm">structuurL 8mm</option>
<option value="structuurB 18mm">structuurB 18mm</option>
<option value="structuurB 8mm">structuurB 8mm</option>
<option value="formica 2620/1300 UNIkleur">formica 2620/1300 UNIkleur</option>
<option value="formica 2620/1300 STRUCTUURL">formica 2620/1300 STRUCTUURL</option>
<option value="formica 2620/1300 STRUCTUURB">formica 2620/1300 STRUCTUURB</option>
<option value="formica UNIkleur 3050/1300">formica UNIkleur 3050/1300</option>
<option value="formica 3050/1300 STRUCTUURL">formica 3050/1300 STRUCTUURL</option>
<option value="formica 3050/1300 STRUCTUURB">formica 3050/1300 STRUCTUURB</option>
<option value="formica 3550/1300 UNIkleur">formica 3550/1300 UNIkleur</option>
<option value="formica 3550/1300 STRUCTUURL">formica 3550/1300 STRUCTUURL</option>
<option value="formica 3550/1300 STRUCTUURB">formica 3550/1300 STRUCTUURB</option>
<option value="formica 4100/1300 UNIkleur">formica 4100/1300 UNIkleur</option>
<option value="formica 4100/1300 STRUCTUURL">formica 4100/1300 STRUCTUURL</option>
<option value="formica 4100/1300 STRUCTUURB">formica 4100/1300 STRUCTUURB</option>
<option value="MDF 2440/1220 BR 6mm">MDF 2440/1220 BR 6mm</option>
<option value="MDF 3050/1220 BR 6mm">MDF 3050/1220 BR 6mm</option>
<option value="MDF 2440/1220 BR 18mm">MDF 2440/1220 BR 18mm</option>
<option value="MDF 3050/1220 BR 18mm">MDF 3050/1220 BR 18mm</option>
<option value="MDF 2620/2070 BR 18mm">MDF 2620/2070 BR 18mm</option>
<option value="MDF 2620/2070ZWART 10mm">MDF 2620/2070ZWART 10mm</option>
<option value="MDF 2620/2070 ZWART 19mm">MDF 2620/2070 ZWART 19mm</option>
<option value="MDF 2440/1220 WATER 18mm">MDF 2440/1220 WATER 18mm</option>
<option value="MDF 3050/1220 WATER 18mm">MDF 3050/1220 WATER 18mm</option>
<option value="DEN A/A 18 mm FINEER SPAAN">DEN A/A 18 mm FINEER SPAAN</option>
<option value="DEN A/B 18mm FINEER SPAAN">DEN A/B 18mm FINEER SPAAN</option>
<option value="EIK A/A 18mm FINEER SPAAN">EIK A/A 18mm FINEER SPAAN</option>
<option value="EIK A/B 18mm FINNER SPAAN">EIK A/B 18mm FINNER SPAAN</option>
<option value="Multiplex 2500/1220 18mm">Multiplex 2500/1220 18mm</option>
</select></th>
<td> </td>
<td><div align="center">
<input name="AANTAL" type="text" size="12">
</div></td>
<td><input name="LENGTE" type="text" size="16"></td>
<td><input name="BREEDTE" type="text" size="18"></td>
<td><div align="center">
<select name="KLENGTE1" size="1">
<option value=""></option>
<option value="2PA">2PA</option>
<option value="2PB">2PB</option>
<option value="MIL">MIL</option>
<option value="L">L</option>
</select>
</div></td>
<td><div align="center">
<select name="KLENGTE2" size="1">
<option value=""></option>
<option value="2PA">2PA</option>
<option value="2PB">2PB</option>
<option value="MIL">MIL</option>
<option value="L">L</option>
</select>
</div></td>
<td><div align="center">
<select name="KBREEDTE1" size="1">
<option value=""></option>
<option value="2PA">2PA</option>
<option value="2PB">2PB</option>
<option value="MIL">MIL</option>
<option value="L">L</option>
</select>
</div></td>
<td><div align="KBREEDTE2">
<select name="select" size="1">
<option value=""></option>
<option value="2PA">2PA</option>
<option value="2PB">2PB</option>
<option value="MIL">MIL</option>
<option value="L">L</option>
</select>
</div></td>
<td><input name="REFERENTIE" type="text" size="46"></td>
</tr>
<tr>
<th height="23" scope="row"> </th>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<th scope="row"> </th>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<th scope="row"> </th>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<th scope="row"> </th>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<th scope="row"> </th>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<th scope="row"> </th>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<th scope="row"> </th>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<th scope="row"> </th>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<th scope="row"> </th>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<th scope="row"> </th>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<th height="26" scope="row"> </th>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<th scope="row"> </th>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<th scope="row"> </th>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<th scope="row"> </th>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<th scope="row"> </th>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<th scope="row"> </th>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<th scope="row"> </th>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<th scope="row"> </th>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<th scope="row"> </th>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<th scope="row"> </th>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<th scope="row"> </th>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<th scope="row"> </th>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<th scope="row"> </th>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<th scope="row"> </th>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<th scope="row"> </th>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<th scope="row"> </th>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<th scope="row"> </th>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<th scope="row"> </th>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table><br>
<input type="submit" name="Submit" value="Verzenden">
</form>');
if (isset($_POSTї'submit']))
{
$MATERIAAL = $_POSTї'MATERIAAL'];
$AANTAL = $_POSTї'AANTAL'];
$LENGTE = $_POSTї'LENGTE'];
$BREEDTE = $_POSTї'BREEDTE'];
$KLENGTE1 = $_POSTї'KLENGTE1'];
$KLENGTE2 = $_POSTї'KLENGTE2'];
$KBREEDTE1 = $_POSTї'KBREEDTE1'];
$KBREEDTE2 = $_POSTї'KBREEDTE2'];
$REFERENTIE = $_POSTї'REFERENTIE'];
if (empty($AANTAL)) { die('<br>U heeft het veld "AANTAL" niet ingevuld.'); }
if (empty($LENGTE)) { die('<br>U heeft het veld "LENGTE" niet ingevuld.'); }
if (empty($BREEDTE)) { die('<br>U heeft het veld "BREEDTE" niet ingevuld.'); }
if (empty($REFERENTIE)) { die('<br>U heeft het veld "REFERENTIE" niet ingevuld.'); }
$query = "INSERT INTO planken (MATERIAAL, AANTAL, LENGTE, BREEDTE, KLENGTE1, KLENGTE2, KBREEDTE1, KBREEDTE2, REFERENTIE) VALUES('".$_POSTї'MATERIAAL']."','".$_POSTї'AANTAL']."','".$_POSTї'LENGTE']."','".$_POSTї'BREEDTE']."','".$_POSTї'KLENGTE1']."','".$_POSTї'KLENGTE2']."','".$_POSTї'KBREEDTE1']."','".$_POSTї'KBREEDTE2']."','".$_POSTї'REFERENTIE']."';";
mysql_query($query,$db) or die("<b>A fatal MySQL error occured</b>.\n<br />Query: " .$query. "<br />\nError: (" .mysql_errno(). ") " .
mysql_error());
}
?>