what about the form itself?
I see no problems in here (except of course that you disclosed your mySQL
host, login and password)
Cheers,
Maxim Maletsky
-----Original Message-----
From: Andre Bajew [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 16, 2001 2:57 PM
To: [EMAIL PROTECTED]
Subject: [PHP] form variables showing blank but query shows non-blank ??
Hi,
I have a form that has 4 variables, one, $pass_category, being a select
list. The form posts a php script. Once inside the PHP script if I have not
selected one of the select list variables the value should be blank. If I
echo this out the value shows as blank. However, I later check the value of
the passed select list variable and it passes a "if > "" test which has me
baffled. I don't have this problem with my three other variables that are
just form fields versus a select list. Am I missing something basic or ??
What I'm doing here is building a SQL statement based on form variables. A
snippet of the script is below.
I'd sincerely appreciate any help or guidance!!
Andre
<?php
mysql_close;
$pass_category = $HTTP_POST_VARS["form_cat"];
$pass_company = $HTTP_POST_VARS["form_company"];
$pass_contact = $HTTP_POST_VARS["form_contact"];
$pass_sort = $HTTP_POST_VARS["form_sort"];
if ($debug =="y")
{
echo "Pass_category=$pass_category<br>"; /* This shows as blank */
echo "Pass_company=$pass_company<br>";
echo "Pass_contact=$pass_contact<br>";
echo "Pass_sort=$pass_sort<br>";
}
$db = mysql_pconnect("mysql1:katychamber.com", "katyc2", "katyc2");
...............
...............
if ($pass_category > "") $sql2 = $sql2 . " and cat = '$pass_category' ";
/* this statement passes this test even though it appears to be blank */
...............
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
