I thought so, too. But the part where it receives the data is this:
$s_marke = $_POST['marke'];
$s_modell = $_POST['modell'];
$s_preis_von = $_POST['preis_von'];
$s_preis_bis = $_POST['preis_bis'];
$s_mileage_von = $_POST['mileage_from'];
$s_mileage_bis = $_POST['mileage_to'];
$s_ez_von = $_POST['ez_from'];
$s_ez_bis = $_POST['ez_bis'];
$s_search_text = $_POST['search_text'];
$s_cat = $_POST['cat'];
$kw_von = $_POST['kw_von'];
$kw_bis = $_POST['kw_bis'];
(part of it)
And this is the relevant part of the <form>
<select name="kw_von">
<option selected="selected" value="0">***</option>
<option value="44">44/60</option>
<option value="55">55/75</option>
<option value="66">66/90</option>
<option value="81">81/110</option>
<option value="92">92/125</option>
<option value="110">110/150</option>
<option value="147">147/200</option>
<option value="184">184/250</option>
<option value="220">220/300</option>
<option value="257">257/350</option>
</select>
The funny thing is that all vars are being received except for the last
two:
$kw_von = $_POST['kw_von'];
$kw_bis = $_POST['kw_bis'];
I am soooo stuck here, it ain't even funny anymore *g* And my boss is, of
course, waiting for a result. Howcome people don't get that programming
sometimes really IS leaning back and closing your eyes *grrrrr* :oP
Thanks for trying to help me :o)
Chris
----- Original Message -----
From: "Zoltán Németh" <znemeth@xxxxxxxxxxxxxx>
To: "Christian Haensel" <php@xxxxxxxxx>
Cc: <php-general@xxxxxxxxxxxxx>
Sent: Monday, May 21, 2007 9:58 AM
Subject: Re: PHP & MySQL Problem
> 2007. 05. 21, hétfő keltezéssel 09.43-kor Christian Haensel ezt írta:
>> Right, here we go... this page has about 1000 lines of code, so here
>> the
>> relevant stuff.
>>
>> $s_query = "SELECT * FROM database WHERE
>> kategorie LIKE '$s_cat' AND
>> marke LIKE '$s_marke' AND
>> leistung_kw >= '$kw_von' AND leistung_kw <= '$kw_bis' AND
>> preis >= '$s_preis_von' AND
>> preis <= '$s_preis_bis'".$checkboxes.$sort_str;
>>
>> I get the $checkboxes from the POST checkboxes, which looks like this
>> (an
>> example):
>>
>> $kraftstoffart = $_POST['fueltype'];
>> if($kraftstoffart == "3") {
>> $checkboxes .= "";
>> }elseif($kraftstoffart == "2") {
>> $checkboxes .= " AND kraftstoffart = '2'";
>> }elseif($kraftstoffart == "1") {
>> $checkboxes .= " AND kraftstoffart = '1'";
>> }
>>
>> and the $sort_str comes in like
>>
>> $sort_by = $_POST['sort_by'];
>> $desc_asc = $_POST['desc_asc'];
>> $sort_str = " ORDER BY ".$sort_by." ".$desc_asc;
>>
>>
>> The query then just goes like
>> $do_q = mysql_query($s_query) or die(mysql_error());
>>
>> and that's it... no errors shown, just the regular output which I had
>> before I put the new fields in there. So no changes to what I've had
>> before... but there should be changes *g*
>
> actually there seems to be no problem with your query (besides that you
> should check posted values first in order to avoid SQL injection)
>
> you said in your first letter that "$_POST['var'] don't reach the
> script" - I would guess the relevant part is not the query but rather
> the form itself...
>
> greets
> Zoltán Németh
>
>>
>> I hope anybody can find some sense in what I'm writing here... hardly
>> makes
>> sense to me :oP
>>
>> Cheers!
>>
>>
>>
>>
>>
>>
>>
>> ----- Original Message -----
>> From: "Zoltán Németh" <znemeth@xxxxxxxxxxxxxx>
>> To: "Christian Haensel" <php@xxxxxxxxx>
>> Cc: <php-general@xxxxxxxxxxxxx>
>> Sent: Monday, May 21, 2007 9:36 AM
>> Subject: Re: PHP & MySQL Problem
>>
>>
>> > 2007. 05. 21, hétfő keltezéssel 09.26-kor Christian Haensel ezt
>> > írta:
>> >> Good morning friends,
>> >>
>> >> I have a script that collects data from a form and puts together a
>> >> mysql
>> >> query to search a database.
>> >> Now, everything worked fine until I added a few new form fields...
>> >> now
>> >> the
>> >> $_POST['var'] don't reach the script...
>> >>
>> >> I have about 20 to 25 form fields which are all taken into the
>> >> query...
>> >>
>> >> Now my question: is there a limit in the fields that I can use in
>> >> the
>> >> query
>> >> string to query the database? Somehow the script doesn't even
>> >> output
>> >> the
>> >> value of the POST data anymore... been using this stuff for years
>> >> now,
>> >> and
>> >> i'm feeling really silly at the moment.
>> >
>> > AFAIK there is no limit in the number of fields in a query...
>> > post some code please, otherwise I don't think anyone will be able
>> > to
>> > help you
>> >
>> > greets
>> > Zoltán Németh
>> >
>> >>
>> >> I'd appreciate any help.
>> >>
>> >> Cheers!
>> >> Chris
>> >>
>> >
>>
>
