Re: Help please, back to an error
| From: | Micah Stevens | Date: | Wed, 15 Sep 2004 00:02:04 +0000 |
| Subject: | Re: Help please, back to an error | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-36191@lists.php.net to get a copy of this message | ||
I'm thinking you should either get a better code generator, or learn more
about php.. :)
-Micah
On Monday 13 September 2004 02:49 pm, Stuart Felenstein wrote:
> Thanks to help here I was able to overcome some ivalid
> query errors.
>
> Now I'm back, (probably the same mistake)
>
> It's coming off of this line:
>
> $sql .= " And
> PostStart >= DATE_SUB(CurDate(), Interval
> ['search_fd1'] day )";
>
> The 'search_fd1' is one of the form fields where a
> list of values is chosen from. Perhaps I will try the
> "search_optfd1"
>
> <?php
> if ((!isset($_GET["search_fd1"])) &&
> (!isset($_POST["search_fd1"]))) {
> $itemvalue = "";
> } else {
> $itemvalue = qsrequest("search_fd1");
> }
>
> $cellvalue = "<select
> name=\"search_optfd1\"><option value=\"<=\"" .
> qscheckselected("<=",$arryopt[1],"selected") . ">less
> or equal</option></select>
> <select name=\"search_fd1\"><option value=\"\"" .
> qscheckselected("",$arryitemvalue[1],"selected") .
> ">Please Select</option>" . qsmysqlgen_listbox("
> Select Distinct
DaysID,Days
> From staDays
> ","search_fd1","DaysID","Days",$arryitemvalue[1]) .
> "</select>" . "<input type=\"hidden\"
> name=\"multisearch_fd1\" value=\"\">";
> if ($cellvalue == "") {
> $cellvalue = " ";
> }
> print "<td class=" . $css_class . " align=Default
>
> >" . $cellvalue . "</td>";
>
> ?>
>
> I hope my question makes sense. I didn't write this
> code AND I have little knowledge of PHP.
>
> Thank you,
> Stuart