2007. 05. 21, hétfő keltezéssel 10.04-kor Christian Haensel ezt írta:
> 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'];
and if you do a var_dump($_POST) what do you get?
are these values not showing up at all?
if so, then you should check whether they are within the <form> and
</form> tags... I made that mistake once...
greets
Zoltán Németh
>
> 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
> >> >>
> >> >
> >>
> >
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
