[jason.lafferty]

Hi Nevermind (hope you're reading this)

As I said I got your suggestion working with a slight tweak.

I'm now trying to progress to another step where now I want to pull out all the contests a band has competed in in a season.

I've got it grabbing by ?Band=xxx as per your suggestion but found that I'm always one row short in what it pulls back. I've added a counter $num_rows and that counts correct but my table is always missing the first entry that would appear.

I read on another post you answered something about calling twice and not printing first row, is that what I've done wrong ?

PHP Code:

<?php 

$databaseName = "rspba_allresults";

$dbconnection = mysql_connect("*****", "*****", "*****") or die ('Cannot Connect To Results Databasebecause: ' . mysql_error());



mysql_select_db($databaseName,$dbconnection) or die ('Cannot use Results Database' . mysql_error());





$Band=$_GET['Band']; 



// Pull out results for all contests per band

$sql = "SELECT * FROM 2003results WHERE Band = '$Band'";

$sql .= 'ORDER BY DATE, Grade DESC LIMIT 0, 30'; 



$result = mysql_query($sql,$dbconnection);

$num_rows = mysql_num_rows($result);

$tablecolour = '#FFCCFF'; 



echo'<a href="http://www.rspba.org/members/Results/2003Results/2003results.html" TARGET="_parent">Return To Contest Picker<br><br></a>';



printf("<b>Band:</b> %s<br>\n", mysql_result($result,0,"Band"));

printf("<b>No of Contests Entries Completed in all Grades:</b> %s<br>\n", $num_rows);





if ($myrow = mysql_fetch_array($result)) 



{ 

echo "<table border=1>\n"; 

echo "<tr><td BGCOLOR=$tablecolour><b><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\">Contest</td></b></font>

<td align='center' BGCOLOR=$tablecolour><b><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\">Date</td></b></font>

<td align='center' BGCOLOR=$tablecolour><b><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\">Grade</td></b></font>

<td align='center' BGCOLOR=$tablecolour><b><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\">Piping 1</td></b></font>

<td align='center' BGCOLOR=$tablecolour><b><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\">Piping 2</td></b></font>

<td align='center' BGCOLOR=$tablecolour><b><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\">Piping Place</td></b></font>

<td align='center' BGCOLOR=$tablecolour><b><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\">Drumming</td></b></font>

<td align='center' BGCOLOR=$tablecolour><b><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\">Ensemble</td></b></font>

<td align='center' BGCOLOR=$tablecolour><b><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\">Final Place</td></b></font>

<td align='center' BGCOLOR=$tablecolour><b><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\">Position</td></b></font></tr>\n"; 



do { printf("<tr><td><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\">%s</font></td>

<td align='center'><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\">%s</font></td>

<td align='center'><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\">%s</font></td>

<td align='center'><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\">%s</font></td>

<td align='center'><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\">%s</font></td>

<td align='center'><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\">%s</font></td>

<td align='center'><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\">%s</font></td>

<td align='center'><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\">%s</font></td>

<td align='center'><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\">%s</font></td>

<td align='center' BGCOLOR=$tablecolour><b><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\">%s</font></b></td>

</tr>\n", $myrow["Contest"],$myrow["Date"], $myrow["Grade"], $myrow["Piping 1 Place"], $myrow["Piping 2 Place"], $myrow["Piping Place"], $myrow["Drumming Place"], $myrow["Ensemble Place"], $myrow["Final Place"], $myrow["Position"]); 



} 



while ($myrow = mysql_fetch_array($result)); echo "</table>\n"; } 



else { echo "Sorry, no records were found!"; } 





// End Code Table Should Display



?>

Thanks for any advice.

Jason