Hi to all, I have a search form where users can search project by 'Project Name' after they type in the project name, they will select which project they will like to view from a drop down menu which contains: Management Approve, Pre-Approved, Management-Not-Approved, and Pre-Not-Approved pproved.
I'm using switch statement switch ($project) { case "Management Approve" $sql = mysql_query("select * from project where project_name='$pro_name' and final_approved='yes'"); $result = mysql_query($sql); $record_count = mysql_num_rows($result); case "Pre-Approved": $sql2 = mysql_query("select * from project where project_name='$pro_name' and first_approved='yes'"); $result2 = mysql_query($sql2); $record_count2 = mysql_num_rows($result2); and so on... My question is: how do I call $sql, or $sql2, and $result, or $result2 to loop and put the fields into an array? The reason I'm asking is because the users will be able to navegate through the recordset, so I need to call just the query that match the criteria either '$result' or '$result2' to be able to display the right information. e.g., while($query_data = mysql_fetch_array($result)) //it can be $result2 { $project_id = $query_data[project_id]; $project_name = $query_data[project_name]; } I'm not sure if this explanation make sence to you guys, but if anybody would like to take the time and try to help me out, that would be great Thanks in advanced Nato -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php