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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php