--- Chris <[EMAIL PROTECTED]> wrote:
> What I tend to do in this situation is have a WHERE
> array:
>
> $sql .= " SELECT PostStart, JobTitle, Industry,
> LocationState, VendorID FROM VendorJobs";
>
>
> $aWHERE = array();
> if(isset($s_Ind)) $aWHERE[] =
> "VendorJobs.LocationState IN ($s_Ind)"
> if(isset($s_State)) $aWHERE[] =
> "VendorJobs.LocationState IN ($s_State)"
>
> if(!empty($aWHERE)) $sql .= 'WHERE '.implode(' AND
> ',$aWHERE);
>
Chris - thank you , it's working great now. Even
though someone had suggested this on php-general it
took me till now to get it to work!
Appreciate the help!
Stuart
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
