PHP MySQL Query help

phpbeginner · November 13, 2005

Hello, first of all this is a great site and I have been frequenting it alot lately as I have been struggling through with MySQL and PHP a bit as a beginner and I find this place very helpful.

I have bascially built a database with a few tables and seem to be having some trouble with one in particular. Its for a hockey team and what I have in this table is a hockey game details. I show a few fields from the table in which they can link to the complete game details for that particular game. I have tried to do this and either get all the game detail results or none. I currently have none with the code below. I have tried linking to the complete details page by either using the gamenumber ( autoincrement primary key ) and have also tried game "date". Here is the code below and please do not laugh to loud as I am a beginner.

This is my game details page in which I have either gotten all records or none.....

[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]mysql_connect($dbserver, $dbuser, $dbpass)

or die ("UNABLE TO CONNECT TO DATABASE");

mysql_select_db($dbname)

or die ("UNABLE TO SELECT DATABASE");

echo "<table width=500 bgcolor=000000 cellpadding=2 border=1><tr><td width=200 height=20 bgcolor=#000000>Teams</td><td width=50 bgcolor=#000000>1st </td><td width=50 bgcolor=#000000>2 nd</td><td width=50 bgcolor=#000000>3 rd</td><td width=50 bgcolor=#000000>Total</div></td><td width=50 bgcolor=#000000>SOG</td>";

echo "</td></tr></table>";

$sql = 'SELECT gamenumber, versus, sea_score_1st, sea_score_2nd, sea_score_3rd, sea_score_total, vs_score_1st, vs_score_2nd, vs_score_3rd, vs_score_total, sea_shots, vs_shots, period1_scores, period2_scores, period3_scores, period1_penalties, period2_penalties, period3_penalties FROM `game` WHERE gamenumber ="$gamenumber"';;

$result = mysql_query($sql);

if ($myrow = mysql_fetch_array($result)) {

do

{

$date=$myrow["date"];

$gamenumber=$myrow["gamenumber"];

$versus=$myrow["versus"];

$sea_score_1st=$myrow["sea_score_1st"];

$sea_score_2nd=$myrow["sea_score_2nd"];

$sea_score_3rd=$myrow["sea_score_3rd"];

$sea_score_total=$myrow["sea_score_total"];

$vs_score_1st=$myrow["vs_score_1st"];

$vs_score_2nd=$myrow["vs_score_2nd"];

$vs_score_3rd=$myrow["vs_score_3rd"];

$vs_score_total=$myrow["vs_score_total"];

$sea_shots=$myrow["sea_shots"];

$vs_shots=$myrow["vs_shots"];

$period1_scores=$myrow["period1_scores"];

$period2_scores=$myrow["period2_scores"];

$period3_scores=$myrow["period3_scores"];

$period1_penalties=$myrow["period1_penalties"];

$period2_penalties=$myrow["period2_penalties"];

$period3_penalties=$myrow["period3_penalties"];

echo "<table width=500 bgcolor=#232323 cellpadding=2 border=1><tr><td width=200 height=20 bgcolor=#333333 valign=top>";

echo "Seahawks<hr>";

echo "$versus</td>";