Forums

PHP

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:

Reply to this topic