(isset)

misunderstood · #1 19-Jun-2004, 08:06

I use a search form that sends the relevant info to a results page
Example code

HTML Code:

<tr> <td height="25" class="textfont">&nbsp;Fuel Type:</td>
<td height="25" class="textfont"> 
<select name="Rpic" class="droplist">
<option value="0" selected>Any Fuel</option>
<option value="Petrol">Petrol</option>
<option value="Diesel">Diesel</option>
</select>
</td></tr>

This is inserted into my search query as

PHP Code:


if(isset($Rpic)and ($Rpic != 0 ))
        {
            if($state == 1)
                $sql1 .= "AND rem_pic_path4=$Rpic ";
            else
                $sql1 .= "rem_pic_path4=$Rpic ";
            $state = 1;
        }

All the other sections work apart from this one. Can anybody see what I am doing wrong?

It is the only section that doesnt work so I am missing something.

JdS · #2 20-Jun-2004, 04:38

Despite having almost 100 posts to your credit on GIDForums™, I am surprised that you still use [ QUOTE ] bbcode tag to highlight your code examples. What is wrong with using HTML or PHP bbcodes?

Anyway, what seems to be the problem with your code actually? Is it just that $Rpic is not set/blank or the 'created' SQL is failing? Can you echo the $Rpic value in a test page?

If you're using the POST method in your form and your REGISTER GLOBALS setting is OFF, then you need to use $_POST['Rpic'] to grab the form's value in your script. Somehow I think you know that already, so it must be something else that you omitted sharing in your first message.

misunderstood · #3 20-Jun-2004, 06:12

My first reprimand.

Quote:

Is it just that $Rpic is not set/blank or the 'created' SQL is failing? Can you echo the $Rpic value in a test page?

$Rpic value can be displayed on the page so the information is getting to my results page.
All other aspects of the search are working but the $Rpic is being ignored for some reason. If I search for just a Diesel all listings are displayed as if the $Rpic was not present.

(I hereby promise to use the correct tags for codes on all my posts, scouts honour.

)

JdS · #4 20-Jun-2004, 06:17

No, we don't do the 'reprimand' thingy here... just confused why you'd want me to keep editing your posts, that's all!

OK, I see the issue now that I've narrowed my attention to the SQL bit off your example code; you forgot the single quotes around $Rpic!

So, your code could look a bit like this?

PHP Code:


if(isset($Rpic)and ($Rpic != 0 ))
    {
      if($state == 1)
        $sql1 .= "AND rem_pic_path4='$Rpic' ";
      else
        $sql1 .= "rem_pic_path4='$Rpic' ";
      $state = 1;
    } ?>

misunderstood · #5 20-Jun-2004, 06:30

Nope

tried with and without but still ignoring $Rpic

JdS · #6 20-Jun-2004, 06:33

Have you tried 'echo'-ing $sqll just to see what is being sent to the MySQL server?

misunderstood · #7 20-Jun-2004, 06:34

If I use

PHP Code:


if(isset($Rpic))
        {
            if($state == 1)
                $sql1 .= "AND rem_pic_path4='$Rpic' ";
            else
                $sql1 .= "AND rem_pic_path4='$Rpic' ";
            $state = 1;
        }

It will search for Diesel or Petrol but of course my problem arises if I want both Fuel Types.

misunderstood · #8 20-Jun-2004, 06:48

OK now we are getting somewhere:

'echo'-ing sql1 shows that using code last posted without

PHP Code:


and $Rpic != 0

that $pic is being included in the query.

'echo'-ing sql1 shows that using code including

PHP Code:


and $Rpic != 0

that $pic is not being included in the query.

misunderstood · #9 20-Jun-2004, 07:17

Got it to work

I used

HTML Code:

<tr>  <td height="25" class="textfont">&nbsp;Fuel Type:</td>
<td height="25" class="textfont"> 
<select name="Rpic" class="droplist">
<option value="Any" selected>Any Fuel</option>
<option value="Petrol">Petrol</option>
<option value="Diesel">Diesel</option>
</select>
</td> </tr>

and

PHP Code:


if(isset($Rpic) and ($Rpic!=Any))
        {
            if($state == 1)
                $sql1 .= "AND rem_pic_path4='$Rpic' ";
            else
                $sql1 .= "rem_pic_path4='$Rpic' ";
            $state = 1;
        }

What the difference Any made from 0 I am unsure??? but it now works.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread: