Hot Scripts Forums - View Single Post - Displaying Selected Table Data from MYSQL using ? in URL

jason.lafferty · #1 (**permalink**) 01-18-04, 01:33 PM

Hi,

Complete Newbie to this and been tearing my hair out for a few days trying to do something.

I have a new mysql db and have created a table. I've managed to take a simpler version of what's now below and expand it to go to my database and pull out ALL records in the database and put them into a nice table displayed on screen.

A little background, the database will be used to store results of 52 contests, the code I have here is using a WHERE statement to pick out 1 contest and this works fine, however, what I want to be able to do is use something like a $_GET variable (I think) here and supply a blablabla.php?contest=xxxx to the URL bar.

I've tried lots of boards and lots of examples but everything I try ends up in a Parse error.

Can someone please look at this code and come up with a suggestion to allow me to take out the hard coded WHERE statement and supply the ?contest = xxxx to the browser. The user will select the appropriate contest from a ComboBox and this will supply the ?Contest=xxx to the browser.

I'm using phpmyadmin and used that to help me generate the SQL, hence the 4 lines in case anyone is wondering. My host has PHP v 4.3.2 if that helps.

Thanks very much in advance for any help.

Jason

***** CODE *****

<html>
<body>


<?php
$databaseName = "*****";
$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());

$sql = 'SELECT * ';
$sql .= 'FROM `2003results` ';
$sql .= 'WHERE Grade = "Nov" AND Contest = \'Gourock\' ';
$sql .= 'ORDER BY grade, 'final place' LIMIT 0, 50';

$result = mysql_query($sql,$dbconnection);
$tablecolour = '#FFCCFF';

printf("Contest: %s \n", mysql_result($result,0,"Contest"));
printf("Date: %s \n", mysql_result($result,0,"Date"));

printf ("");
printf("Grade: %s \n", mysql_result($result,0,"Grade"));
printf("Piping Judge 1: %s \n", mysql_result($result,0,"Piping 1"));
printf("Piping Judge 2: %s \n", mysql_result($result,0,"Piping 2"));
printf("Ensemble Judge: %s \n", mysql_result($result,0,"Ensemble"));
printf("Drumming Judge: %s \n", mysql_result($result,0,"Drumming"));

if ($myrow = mysql_fetch_array($result))
{ echo "<table border=1>\n";
echo "<tr><td BGCOLOR=$tablecolour>Band</td><td align='center' BGCOLOR=$tablecolour>Piping 1</td><td align='center' BGCOLOR=$tablecolour>Piping 2</td><td align='center' BGCOLOR=$tablecolour>Piping Place</td><td align='center' BGCOLOR=$tablecolour>Drumming</td><td align='center' BGCOLOR=$tablecolour>Ensemble</td><td align='center' BGCOLOR=$tablecolour>Final Place</td><td align='center' BGCOLOR=$tablecolour>Position</td></tr>\n";

do { printf("<tr><td>%s</td>
<td align='center'>%s</td>
<td align='center'>%s</td>
<td align='center'>%s</td>
<td align='center'>%s</td>
<td align='center'>%s</td>
<td align='center'>%s</td>
<td align='center' BGCOLOR=$tablecolour>%s</td>
</tr>\n", $myrow["Band Name"], $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!"; }

?>

</body>
</html>

***** END CODE *****