Re: [PHP] BIG PROBLEM WITH SEARCH!!!!!!

2001-01-19 Thread Chris Lee
best way is this. if ($CID) $query[] = "CID = '$CID'"; if ($CUserName) $query[] = "CUserName = '$CUserName'"; if ($CAge) $query[] = "CAge = '$CAge'"; if ($CEducation) $query[] = "CEducation = '$CEducation'"; if (isset($query)) $query = "SELECT * FROM clients WHERE CID = '$CID

[PHP] BIG PROBLEM WITH SEARCH!!!!!!

2001-01-19 Thread Mike Yuen
I'm developing a site that requires people to sign up. During this time, we get their name, email, city, etc. There is also optional informational like (age, education) that they don't have to fill in. Now, the problem we have is we allow people search through the database using mostly the same