Search Results not working...

Hi,

For some reason the first record that is in my database is the only record that shows on my results page no matter what I type into my search. I've gone through the process of creating the pages several times and can't find what I'm doing wrong. please help

Thanks

Rich W

i presume you have a repeat region for the recordset

can you post a link to your page or zip and upload it?

Hi Craig,

Yep, I have a repeat region. Here's a link to download the results page:

WADAcontractor_Results.html


thanks,

oh, on another note...for some reason the webassist site's server is blocking access periodically, have to try several times to get onto the site (including the main page)

lot going on there, but i can't see a repeat region.

around line 495, try putting the <tr></tr> for the data rows in a repeat region...(hope i go the syntax right), failing that, post the sql and i can take a proper look

<table width="300" border="1">
        <tr>
          <th scope="col">&nbsp;</th>
          <th scope="col">&nbsp;</th>
          <th scope="col">&nbsp;</th>
          <th scope="col">&nbsp;</th>
        </tr>
        <?php do { ?>
        <tr>
          <th scope="col"><?php echo $row_WADAWADAcontractor['name']; ?></th>
          <th scope="col"><?php echo $row_WADAWADAcontractor['company_name']; ?></th>
          <th scope="col"><?php echo $row_WADAWADAcontractor['city_town']; ?></th>
          <th scope="col"><?php echo $row_WADAWADAcontractor['type_of_work']; ?></th>
        </tr>
        <?php } while ($row_WADAWADAcontractor = mysql_fetch_assoc($WADAWADAcontractor)); ?>
      </table>

PS you can zip and attach files to posts in this forum

Can you please let me know what I have to do in order to being able to see the qry argument on my URL.
This will enable me to solve some other problems as well.
For security reasons webassist has put some code on the WADbSearch/HelperPHP.php to strip the argument and therefore the argument isn't displayed on the URL.
I need to know which lines of code I need to delete in order to see the argument.
e.g. on Google when you search you have the following argument: search?q=
I need to know how to replace 'search?q=' in order to see my argument.
Thanks in advance

please send a link to your search page so I can seer this.

results.php
Thanks

your search form uses the POST method, only if the form uses the GET method will the search term by passed using the query string.

you can still display the search term on the using this code:

<?php echo((isset($_POST['search']))?$_POST['search']:""); ?>

but it wont be part of the URL.

Is there any way for me to find the url string?
What I need is to type on the URL the argument and when I press the enter key to receive the same results as I will receive when I add the word/words on the input field.
What I'm trying to do is use FLASH and AS3.0 to search.
E.g.
for the google search I will need to add:
search?q=
When I add the word 'hello' after the argument:
search?q=hello
and then press Enter, the results will give me the word hello (please copy and paste the above argument on your URL to see and understand what I need.
This is why I will need the URL argument.
Can you please let me know if is possible for me to produce a URL argument in order to find my a specific result/s?
The table called: urls and is looking for the 'Description' field using LIKE
a-directory.co
Hope you will be able to help.

this is a function of the way forms work.

if you set your form to use the GET method, the form data will be passed through the query string

if you set your form to use the POST method, there is no querystring

your form is using the post method. there is no querstring created using this form method.

the only way to get the form information is by using the $_POST array from my example in the previous reply.


you are asking me how to get information that does not exist because of the method that the form uses.

If you want the information to passed through the querystring, then you need to change the forms method from POST to GET.