SQL fejl ? Hvorfor melder den fejl ???
Jeg får denne fejl: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 'tom Med ORDER BY marke, model, ccm, pris' at line 1
Min kode ser sådan ud (udsnit):
<CENTER>
<FORM ACTION="vismc.php" METHOD="post">
<table width=90% border=0>
<tr>
<td width=30%><CENTER>
Mærke:
</td>
<td width=30%><CENTER>
Model:
</td>
<td width=30%><CENTER>
Årgang:
</td>
</tr>
<tr>
<td width=30%><CENTER>
<select name="marke" CLASS="felter">
<option value="" selected>
<option value="AND marke='Aprilia'">Aprilia
<option value="AND marke='Benelli'">Benelli
<option value="AND marke='Bmw'">BMW
<option value="AND marke='Ducati'">Ducati
<option value="AND marke='Honda'">Honda
<option value="AND marke='Jawa'">Jawa
<option value="AND marke='Kawasaki'">Kawasaki
<option value="AND marke='Moto Guzzi'">Moto Guzzi
<option value="AND marke='Suzuki'">Suzuki
<option value="AND marke='Triumph'">Triumph
<option value="AND marke='Yamaha'">Yamaha
</select>
</td>
<td width=30%><CENTER>
<INPUT NAME="model" TYPE="text" SIZE="20" Class="felter">
</td>
<td width=30%><CENTER>
<select name="aargang" CLASS="felter">
<option value="" selected>
<option value="AND aargang='1981'">1981
<option value="AND aargang='1982'">1982
<option value="AND aargang='1983'">1983
<option value="AND aargang='1984'">1984
<option value="AND aargang='1985'">1985
<option value="AND aargang='1986'">1986
<option value="AND aargang='1987'">1987
<option value="AND aargang='1988'">1988
<option value="AND aargang='1989'">1989
<option value="AND aargang='1990'">1990
<option value="AND aargang='1991'">1991
<option value="AND aargang='1992'">1992
<option value="AND aargang='1993'">1993
<option value="AND aargang='1994'">1994
<option value="AND aargang='1995'">1995
<option value="AND aargang='1996'">1996
<option value="AND aargang='1997'">1997
<option value="AND aargang='1998'">1998
<option value="AND aargang='1999'">1999
<option value="AND aargang='2000'">2000
<option value="AND aargang='2001'">2001
</select>
</td>
</tr>
<tr>
<td width=30%><CENTER>
CCM:
</td>
<td width=30%><CENTER>
Pris:
</td>
<td width=30%><CENTER>
Med/Uden Afgift:
</td>
</tr>
<tr>
<td width=30%><CENTER>
<select name="ccm" CLASS="felter">
<option value="" selected>
<option value="AND ccm='125'">125
<option value="AND ccm='250'">250
<option value="AND ccm='400'">400
<option value="AND ccm='500'">500
<option value="AND ccm='600'">600
<option value="AND ccm='750'">750
<option value="AND ccm='900'">900
<option value="AND ccm='1000'">1000
<option value="AND ccm='1100'">1100
<option value="AND ccm='1200'">1200
<option value="AND ccm='1300'">1300
</select>
</td>
<td width=30%><CENTER>
<select name="pris" CLASS="felter">
<option value="" selected>
<option value="AND pris > 0 AND pris < 10000">0-10.000
<option value="AND pris > 10001 AND pris < 20000">10.001-20.000
<option value="AND pris > 20001 AND pris < 30000">20.001-30.000
<option value="AND pris > 30001 AND pris < 40000">30.001-40.000
<option value="AND pris > 40001 AND pris < 50000">40.001-50.000
<option value="AND pris > 50001 AND pris < 60000">50.001-60.000
<option value="AND pris > 60001 AND pris < 70000">60.001-70.000
<option value="AND pris > 70001 AND pris < 80000">70.001-80.000
<option value="AND pris > 80001 AND pris < 90000">80.001-90.000
<option value="AND pris > 90001 AND pris < 100000">90.001-100.000
<option value="AND pris > 100001 AND pris < 110000">100.001-110.000
<option value="AND pris > 110001 AND pris < 120000">110.001-120.000
<option value="AND pris > 120001 AND pris < 130000">120.001-130.000
<option value="AND pris > 130001 AND pris < 150000">130.001-150.000
<option value="AND pris > 150001 AND pris < 175000">150.001-175.000
<option value="AND pris > 175001 AND pris < 200000">175.001-200.000
<option value="AND pris > 200001 AND pris < 999999">200.000-?
</select>
</td>
<td width=30%><CENTER>
<select name="afgift" CLASS="felter">
<option value="AND afgift='Med'">Med
<option value="AND afgift='Uden'">Uden
</select>
</td>
</tr>
</table><br>
<center><INPUT NAME="sog" TYPE="submit" VALUE="Søg" Class="felter">
</FORM>
</CENTER>
<?
if ((@$sog)){
mysql_connect("localhost","test","test");
mysql_select_db("db1") or die("Error opening database ..");
$query = "select * FROM annoncer WHERE NOW() <= DATE_ADD(date, INTERVAL 60 DAY) $marke $aargang $ccm $pris $afgift ORDER BY marke, model, ccm, pris";
$result = mysql_query($query) or die(mysql_error());
Jeg aner ikke hvor den får det der "tom" fra.... ????
