Creating a dynamic querry ??

From: Date: Wed, 06 Feb 2002 22:25:31 +0000
Subject: Creating a dynamic querry ??
Groups: php.db 
Request: Send a blank email to php-db+get-16599@lists.php.net to get a copy of this message
Hi there, I am building a picture search engine with a gui where the user can choose categories and then choose from those categories several points. It is almost impossible to build a querry out of that. I am having a problem keeping it dynamic. It works if I am naming the category, but I would like to make it dynamic Here is an example what I am trying to get: assuming there are following values: $glacier = array("g_one", "g_two"); $lake = array ("l_one", "l_two"); $mountain = array ("m_one", "m_two"); // this returns the value for glacier echo $glacier[1]; // g_two // This code is creating a querry. User has a gui where he can choose between the categories. // It should loop through all possibilities Thats why I tryed to make the $glacier $$category But somehow this does not work // The problem is, that I want to loop through all. So I do not know if it is a glacier, lake or mountain the user selected building the querry: if ($glacier[0] == 'empty'){ // show all glaciers $search = "glacier IS NOT NULL"; } else{ // show particular $search = "glacier ="; for($i=0; $i<count($glacier); $i++){ $search .= $glacier[$i]; # add OR if it is not the last in the array if ($i < (count($glacier)-1)) $search .= " OR glacier ="; } } Do you see my trouble?? Thanx for any help Cheers Andy

« previous php.db (#16599) next »