Select Query Output problem

michaelowen

hello everyone,

I am a newbie at this, and am having a problem outputting the results of a multi-variable query.

What I want to do is take a login, verify it, then pass the username along as a variable. According to that username, I want to query another table and return ALL the values that match the associated usernames "Team Name".

I believe my problem is in the way i return the array....here is the code:

$query="SELECT * FROM captain WHERE username ='$username'";
$result=mysql_query($query);

$mydata = mysql_fetch_array($result);

$queryrun="SELECT * FROM runner WHERE teamname ='$mydata'";
$resultrun=mysql_query($queryrun);
$mydatarun = mysql_fetch_array($resultrun);

echo $mydatarun;

Right now i'm getting blank results.....

-Michael

kevinsequeira

$mydata = mysql_fetch_array($result);
$queryrun="SELECT * FROM runner WHERE teamname ='$mydata'";

$mydata is an array, so the $queryrun is wrong

u need to extract the values inside the array like this

$myrow = mysql_fetch_array($result);
$mydata = $myrow['teamname'];

PS : im not sure what the column name for teamname is in your db
reg
kevin

michaelowen

kevin,

Thank you! One more quick question. I got it to return the correct results, now how would i get it to return ALL the results in the array?

$query="SELECT * FROM captain WHERE username ='$username'";
$result=mysql_query($query);
$mydata = mysql_fetch_array($result);
$teamname = $mydata[cap_team];

$queryrun="SELECT * FROM runner WHERE teamname ='$teamname'";
$resultrun=mysql_query($queryrun);
$myrow = mysql_fetch_array($resultrun);
$mydatarun = $myrow['run_lastname'];

echo $mydatarun;

Also, How can i return multiple fields?

-Michael

kevinsequeira

<?php
$user_query = "SELECT * FROM captain WHERE username ='$username'";
$user_result=mysql_query($user_query);
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);
  while($run_row = mysql_fetch_array($run_result)){
	  $mydatarun = $run_row['run_lastname'];
   echo $mydatarun."<BR>";
		} 
}
?>

reg
kevin

michaelowen

Thank you Kevin!

-michael

michaelowen

How could I place this information into an organized html table format?

-michael

kevinsequeira

<?php
$user_query = "SELECT * FROM captain WHERE username ='$username'";
$user_result=mysql_query($user_query);
echo "<table width=100% border=1>";
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);
  while($run_row = mysql_fetch_array($run_result)){
   $mydatarun = $run_row['run_lastname'];
   echo "<tr><td>".$mydatarun."</td></tr>";
  } 
}
echo "</table>"
?>

reg
kevin