Forums
This topic is locked
Search / Results Problem - still !
Posted 22 Feb 2002 09:27:15
1
has voted
22 Feb 2002 09:27:15 John Ashton posted:
Hi all,further to my earlier posting on this issue. I have carried out the suggestions made by Bruno but am experiencing problems.
The following is an extract from the code on my results page:
------------------------------------------
<?php
$rsResults__MM_ColParam1 = "1";
if (isset($HTTP_POST_VARS["columnSelect"] ))
{$rsResults__MM_ColParam1 = $HTTP_POST_VARS["columnSelect"] ;}
?><?php
$rsResults__MM_ColParam2 = "1";
if (isset($HTTP_POST_VARS["enteredName"]))
{$rsResults__MM_ColParam2 = $HTTP_POST_VARS["enteredName"];}
?><?php
$rsResults=$connConvicts->Execute("SELECT * FROM table3 WHERE " . ($rsResults__MM_ColParam1) . "='" . ($rsResults__MM_ColParam2) . "'" or DIE($connConvicts->ErrorMsg());
$rsResults_numRows=0;
$rsResults__totalRows=$rsResults->RecordCount();
?>
--------------------------------------
Now, if my search form is set up with a "get" I get a complete listing of all entries. On the other hand if I set the search form up with a "post" I get no results returned.
Anyone got any ideas???
Thanks
John.<font color=blue></font id=blue><font color=red></font id=red><b></b>
John Ashton
Intellinet Business Solutions
Wollombi NSW 2325
ph: +61-2-4998 3426
website: www.intellinet.com.au
email: