hi all,
i have a problem when i retrive some records from a table in db which is there isnot any textboxes in the form that show the records i retrieved , another problem i faced was that i want to redirect to another form (i.e a new form that list all the retrieved records) ,i tried to create another form but that was wrong and i didnot know how can i redirect to a new form..

here is what i make ....can any one help me to makes it work propably.

else if ($form_state['clicked_button']['#value'] == 'view') 
	  {
		$query="SELECT v_date FROM {requests}";
		$queryResult =  db_query($query);
		while ($obj = db_fetch_object($queryResult)) 
                                        {
			
				$form['requests'] = array(
					'#type' => 'textfield',
					'#title' => t('Pending Requests'),
					'#default_value' => $obj->v_date,
					'#size' => 20,
					'#maxlength' => 255
				);
		                         return $form;
			  
		                }
            }
	

thanks for advance