Hello everybody,
I have written the following piece of code, however how would I make it return all matched rows in editable (add/change/delete) form?
(email is used for validation), and then return all registered apps that have associated teamname.
<?php
include("include.php");
$db = mysql_connect("???", "???", "????");
mysql_select_db("???",$db);
$user_query = "SELECT FROM captain WHERE email='$email";
$user_result=mysql_query($user_query);
echo "<table width=100% border=0>";
while($user_row = mysql_fetch_array($user_result)){
$teamname = $user_row['cap_team'];
$run_query = "SELECT FROM runner WHERE teamname ='$teamname'";
$run_result = mysql_query($run_query);
echo "<tr><td><center><font size=+2 color=red> Team Name: ".$teamname."</font></center></td></tr>";
echo "<tr><td></td></tr>";
echo "<tr><td></td></tr>";
echo "<tr><td><b> Runner</b> </td><td><b>Sex</b></td><td><b>Age</b></td><td><b>Race</b></td><td><b>Email</b></td></tr>";
while($run_row = mysql_fetch_array($run_result)){
$mydatarunfirst = $run_row['run_firstname'];
$mydatarunlast = $run_row['run_lastname'];
$mydatarunsex = $run_row['run_sex'];
$mydatarunage = $run_row['run_age'];
$mydatarunrace = $run_row['race'];
$mydatarunemail = $run_row['run_email'];
echo "<tr><td>".$mydatarunfirst. " " .$mydatarunlast."</td><td>".$mydatarunsex."</td><td>".$mydatarunage."</td><td>".$mydatarunrace."</td><td>".$mydatarunemail."</td></tr>";
}
}
echo "</table>"
?>
Thanks!
-Michael
