Displaing MySQL data

[olly79]

Hi all,

 

Just wondering if someone can help me with the following.

 

I'm inserting data from a web form into MySQL (below is the data that I'm inserting):

 

^{$Body .= $_POST['m'].' '.$name.''.$surname.'<br />';}

^{if(!empty($_POST['month']) && !empty($_POST['day']) && !empty($_POST['year'])  )$Body .= 'Date of Birth: '.$_POST['month'].' '.$_POST['day'].' '.$_POST['year'].'<br />';}

^{if(!empty($_POST['gender']))$Body .= 'Gender: '.$_POST['gender'].'<br />';}

^{if(!empty($address))$Body .= 'Street Address: '.$address.'<br />';}

^{if(!empty($city))$Body .= 'City: '.$city.'<br />';}

^{if(!empty($zip))$Body .= 'Zip Code: '.$zip.'<br />';}

^{if(!empty($_POST['country']))$Body .= 'Country: '.$_POST['country'].'<br />';}

^{if(!empty($state))$Body .= 'State/Province: '.$state.'<br />';}

^{if(!empty($day_ph))$Body .= 'Daytime phone: '.$day_ph.'<br />';}

^{if(!empty($mob_ph))$Body .= 'Mobile Telephone: '.$mob_ph.'<br />';}

^{if(!empty($email))$Body .= 'Email: '.$email.'<br />';}

^{if(!empty($add_info))$Body .= 'Additional Information: '.$add_info.'<br />';}

 

I now want to display this data on a web form I have:

 

^{<form action="insert.php" method="post">}

^{MySQL Table Name:}

^{<div class="indent-form"><input type="text"/></div>}

^{<br />}

^{<textarea name="mysql recruitment data" rows="20" cols="150" wrap="physical"></textarea>}

^{<br />}

^{<INPUT TYPE="submit" value="load data">}

^{<INPUT TYPE="submit" value="export data" />}

^</form>

 

I basically wanted to load the data via the "load data" button, and I would firstly load the table name into the first textbox and then all the data for the database named "recruitment" would be loaded into the textarea in tabluar format.

 

I have seen ways in which I can load MySQL data; however, I'm struggling with how I can achieve this based on what I want to do.

 

Any help would be much appreciated.