After the Submit button ??

Cork_Skate

Hi there,

I want to ask a basic question. The form below is simple, name and age .... click submit and .....


<form action="result.php" method="POST">
Enter your name: <input type="text" name="name" />
Enter your age: <input type="text" name="age" />
<input type="submit" />
</form>

It ends up here ... on the result.php page


Welcome <?php echo $_POST["name"]; ?>.<br />
You are <?php echo $_POST["age"]; ?> years old!

That is fine ...... but i dont know what to do with my code ....

The user is meant to click on Submit and it takes them to result.php but the following IF Statement is run first !?!

Everything in the blue, red and green is fine

What should i put on the result.php page ??


if ($_REQUEST['submit'] == 'Submit') {

[COLOR=blue]$username = "username";
$password = "password";
$hostname = "localhost";	
$dbh = mysql_connect($hostname, $username, $password) 
	or die("Unable to connect to MySQL");
print "Connected to MySQL<br>";
$selected = mysql_select_db("database",$dbh) 
	or die("Could not select my database");
print "Connected to database<br>";[/COLOR]


$clubID = $_POST['Clubno']; 
$result=mysql_query("[COLOR=red]SELECT ClubName, DomesticLeague, TelePhoneNo, FaxNo, EmailAddress, Website, Groundno, YearEstablished, Status, ManagerNo, CoachNo FROM club WHERE Clubno=$clubID[/COLOR]"); 


while ($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
[COLOR=green]echo "Club Name: $row[ClubName] <br> League: $row[DomesticLeague] <br> Telephone: $row[TelePhoneNo] <br> Fax No.: $row[FaxNo] <br> Email: $row[EmailAddress] <br> Website: $row[Website] <br> GroundNo: $row[GroundNo] <br> Established: $row[YearEstablished] <br> Status: $row[Status] <br> ManagerNo: $row[ManagerNo] <br> CoachNo: $row[CoachNo] <br>"; [/COLOR]
}
}

Can anyone help ...... i think it is a fairly straight forward problem if you know hat you are doing.

jkurrle

Let me see if I understand this correctly:

If the variables were properly filled out on the form page, you want to display them on the results page. If they aren't filled out, then don't show anything?

BTW, you are missing an 'extract($row);' command before your echo command in the while{} loop...

Cork_Skate

Originally posted by jkurrle
If the variables were properly filled out on the form page, you want to display them on the results page. If they aren't filled out, then don't show anything?

I'll be honest, i didn't think about what happens if there is a problem. Basically what i wanted was the user to select something from the drop down menu, hit Submit and it goes to the result.php page with the results ..... if there is a problem, i suppose if i had a message saying "that didn't work"

BTW, you are missing an 'extract($row);' command before your echo command in the while{} loop... [/B]

Is that the syntax ... just extract($row); on a line above the echo ??

jkurrle

The extract command takes the information from the row and sets variable names and their values. Putting the command 'extract($row);' above the echo command gives you the variables you want to quote. Otherwise, you have no variables set. Just an array of information.