Joining tables, please help newb

Robert_Blackwel

I need help joining some tables to display more info about "races"

What you see there is just displaying info from the "races" table.

Here's what I'm working on which is
broken.

I made the page myself, but it was a little while ago so I'm a little rusty.

Here's the code I'm trying

   $query = "select * from races where race_name = '".$selection."'";
   $result = mysql_query($query);
   $array = mysql_fetch_array($result);

   $rsClass = "select * from classes where races.race_id = rcjoin.race_id AND rcjoin.class_id = classes.class_id";
   $result2 = mysql_query($rsClass);
   $array2 = mysql_fetch_array($result2);

OpenTable();

echo "<br><br><center><table width=\"95%\" border=\"1\" cellpadding=\"4\" cellspacing=\"4\" 

bordercolor=\"#404040\"><center>
  <tr>
    <td valign=\"top\">
		<img src=\"images/wowc/races/".$array['race_image']."\">
		<br><center>
		Available Classes:
		<br>
  <table border=\"0\" cellpadding=\"1\" cellspacing=\"1\">
   <tr>
   for ($i=0; $i <$num_results; $i++)
   { /* THIS IS LINE 95*/
    $array2 = mysql_fetch_array($result2);
    echo "echo "<td><span class=\"contentsmall\"><center>".$array2['class']."</center></span></td>


	".$array['classes']."
	</center>
   </tr>
   </table>
	</td>
    <td>
	<table width=\"100%\" cellpadding=\"5\">
 	 <tr>
     	<td>
		<img src=\"/themes/$ThemeSel/images/titles/races/".$array['race_timg']."\"><br><br>
		".$array['race_description']."<br>
		<center><br>
		Starting Location(s):<br>
		".$array['start_loc']."
		</center>
		<img src=\"images\spacer.gif\" width=\"350\">
		</td>
  	</tr>
	</table>	
	</td>
  </tr></center></table></center><br><br>";  

CloseTable();

On the page that works, it's displaying what's in the classes cell of the races table but my whole goal here is to make it relational.

Now, the error is on line 95 but even if I comment out lines 92-103 I still get an error on line 95

Parse error: parse error, unexpected T_ECHO, expecting ',' or ';' in c:\webhost4life_aspnet\robbieb\modules\Racetest\index.php on line 95

The only difference between the 2 pages I've linked to are that on the racetest one, I've added the

   $rsClass = "select * from classes where races.race_id = rcjoin.race_id AND rcjoin.class_id = classes.class_id";
   $result2 = mysql_query($rsClass);
   $array2 = mysql_fetch_array($result2);

And of course, the table in the middle that is supposed to display the results.

I THOUGHT I was on the right track but it looks like I'm gonna need a lot of help

Here are some snapshots of the tables I'm trying to join.

http://www.wowcentral.com/random/races.gif
http://www.wowcentral.com/random/rc_join.gif
http://www.wowcentral.com/random/classes.gif

I'm betting my error is mainly cause I don't know how to do the SQL...

Thanks for reading

Drakla

Ok - if you put in code of any lenght make sure you put it in the PHP tags this board takes, as it syntax highlights it.

I've just pasted this into dreamweaver and I think I can see your problem straight away - you messed up a few of your closing quotes and put in an erroneous echo. I won't bother saying where, I'll just paste the code back - see if it works

$query = "select * from races where race_name = '".$selection."'"; 
$result = mysql_query($query); 
$array = mysql_fetch_array($result); 

$rsClass = "select * from classes where races.race_id = rcjoin.race_id AND rcjoin.class_id = classes.class_id"; 
$result2 = mysql_query($rsClass); 
$array2 = mysql_fetch_array($result2); 

OpenTable(); 

echo "<br><br><center><table width=\"95%\" border=\"1\" cellpadding=\"4\" cellspacing=\"4\" 

bordercolor=\"#404040\"><center> 
<tr> 
<td valign=\"top\"> 
<img src=\"images/wowc/races/".$array['race_image']."\"> 
<br><center> 
Available Classes: 
<br> 
<table border=\"0\" cellpadding=\"1\" cellspacing=\"1\"> 
<tr>";
for ($i=0; $i <$num_results; $i++) 
{ /* THIS IS LINE 95*/ 
$array2 = mysql_fetch_array($result2); 
echo "<td><span class=\"contentsmall\"><center>".$array2['class']."</center></span></td> 


".$array['classes']." 
</center> 
</tr> 
</table> 
</td> 
<td> 
<table width=\"100%\" cellpadding=\"5\"> 
<tr> 
<td> 
<img src=\"/themes/$ThemeSel/images/titles/races/".$array['race_timg']."\"><br><br> 
".$array['race_description']."<br> 
<center><br> 
Starting Location(s):<br> 
".$array['start_loc']." 
</center> 
<img src=\"images\spacer.gif\" width=\"350\"> 
</td> 
</tr> 
</table> 
</td> 
</tr></center></table></center><br><br>"; 

CloseTable();

Robert_Blackwel

Okay, I see the php button now, thanks. duh.

I see where I botched the echo's too, I need to remember the little things.

I pasted your code, and then it errored on line 125 which is 2 lines under the closetable()

it's just a closing bracket...so I added another closing bracket to line 99 cause I forgot to put one.

{ /* THIS IS now LINE 96 */
$array2 = mysql_fetch_array($result2);  

echo "<td><span class=\"contentsmall\"><center>".$array2['class']."</center></span></td> 
} /* I FORGOT THIS BRACKET */

But it still errors

Parse error: parse error, unexpected $end in c:\webhost4life_aspnet\robbieb\modules\Racetest\index.php on line 125

btw, does it look like I have my tables structured okay? I had thought that's probably where I'd totally gone wrong.

Robert_Blackwel

Okay, I fixed the error.

I closed the echo in the loop, and opened a new one right after...but my sql statement doesn't seem to work cause the classes aren't being displayed

Robert_Blackwel

Okay, it's all good 🙂

// FIGURE OUT WHICH RACE THEY ARE TRYING TO VIEW
$query = "select * from races where race_name = '".$selection."'";
$result = mysql_query($query);
$array = mysql_fetch_array($result);

// GET THE ID NUMBER OF THE SELECTED RACE INTO A VARIABLE
$raceid = $array['race_id'];

// GET A LIST OF ALL THE CLASSES AVAILABLE TO THAT RACE INTO AN ARRAY
$query = "select * from rc_join where race_id like '".$raceid."'";
$result = mysql_query($query);
$numclasses = mysql_num_rows($result);

// LOOP THROUGH THE ARRAY OF AVAILABLE CLASSES, SPITTING OUT LINKS TO EACH ONE
for($i = 0; $i < $numclasses; $i++)
	{
	$classinfo = mysql_fetch_array($result);
	$query = "select * from classes where class_id like '".$classinfo['class_id']."'";
	$results = mysql_query($query);
	$currentclass = mysql_fetch_array($results);
	echo "<a href=\"modules.php?name=classes#".$currentclass['class_title']."\">".$currentclass['class_title']."</a>, ";
	}

http://www.wowcentral.com/modules.php?name=Races&selection=humans

check it out..

thanks for the help.