Page 1 of 1

[SOLVED]SQL query not working

Posted: Wed Feb 16, 2005 1:16 pm
by Diod

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">&nbsp;</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>&nbsp;</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">&nbsp;</th>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <th scope="row">&nbsp;</th>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <th scope="row">&nbsp;</th>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <th scope="row">&nbsp;</th>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <th scope="row">&nbsp;</th>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <th scope="row">&nbsp; </th>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <th scope="row">&nbsp;</th>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <th scope="row">&nbsp;</th>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <th scope="row">&nbsp;</th>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <th scope="row">&nbsp;</th>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <th height="26" scope="row">&nbsp;</th>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <th scope="row">&nbsp;</th>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <th scope="row">&nbsp;</th>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <th scope="row">&nbsp;</th>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <th scope="row">&nbsp;</th>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <th scope="row">&nbsp;</th>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <th scope="row">&nbsp;</th>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <th scope="row">&nbsp;</th>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <th scope="row">&nbsp;</th>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <th scope="row">&nbsp;</th>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <th scope="row">&nbsp;</th>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <th scope="row">&nbsp;</th>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <th scope="row">&nbsp;</th>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <th scope="row">&nbsp;</th>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <th scope="row">&nbsp;</th>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <th scope="row">&nbsp;</th>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <th scope="row">&nbsp;</th>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <th scope="row">&nbsp;</th>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
</table><br>
<input type="submit" name="Submit" value="Verzenden">
</form>');

if (isset($_POST&#1111;'submit']))
&#123;
$MATERIAAL = $_POST&#1111;'MATERIAAL']; 
$AANTAL = $_POST&#1111;'AANTAL']; 
$LENGTE = $_POST&#1111;'LENGTE']; 
$BREEDTE = $_POST&#1111;'BREEDTE']; 
$KLENGTE1 = $_POST&#1111;'KLENGTE1']; 
$KLENGTE2 = $_POST&#1111;'KLENGTE2']; 
$KBREEDTE1 = $_POST&#1111;'KBREEDTE1']; 
$KBREEDTE2 = $_POST&#1111;'KBREEDTE2']; 
$REFERENTIE = $_POST&#1111;'REFERENTIE']; 

if (empty($AANTAL)) &#123; die('<br>U heeft het veld "AANTAL" niet ingevuld.'); &#125;
if (empty($LENGTE)) &#123; die('<br>U heeft het veld "LENGTE" niet ingevuld.'); &#125;
if (empty($BREEDTE)) &#123; die('<br>U heeft het veld "BREEDTE" niet ingevuld.'); &#125;
if (empty($REFERENTIE)) &#123; die('<br>U heeft het veld "REFERENTIE" niet ingevuld.'); &#125;

$query = "INSERT INTO planken (MATERIAAL, AANTAL, LENGTE, BREEDTE, KLENGTE1, KLENGTE2, KBREEDTE1, KBREEDTE2, REFERENTIE) VALUES('".$_POST&#1111;'MATERIAAL']."','".$_POST&#1111;'AANTAL']."','".$_POST&#1111;'LENGTE']."','".$_POST&#1111;'BREEDTE']."','".$_POST&#1111;'KLENGTE1']."','".$_POST&#1111;'KLENGTE2']."','".$_POST&#1111;'KBREEDTE1']."','".$_POST&#1111;'KBREEDTE2']."','".$_POST&#1111;'REFERENTIE']."';";
mysql_query($query,$db) or die("<b>A fatal MySQL error occured</b>.\n<br />Query: " .$query. "<br />\nError: (" .mysql_errno(). ") " .
mysql_error());

&#125;
?>
this is the code im talking about, but i cant get it to insert it into mysql. User and pass and such is good

Posted: Wed Feb 16, 2005 1:19 pm
by feyd
any details of what the error it says is?

Posted: Wed Feb 16, 2005 1:21 pm
by Diod
It isnt saying any error, it just refreshes and doesnt insert it into the mysql db

Posted: Wed Feb 16, 2005 1:29 pm
by feyd
$_POST['submit'] doesn't exist.

$_POST['Submit'] does.

Posted: Thu Feb 17, 2005 3:10 pm
by Diod
Thx...
;)
You helped me out a great deal