retrieving values from a MYSQL query

[stretchy]

I am making a query and I am returned data. I would like to get a value from a fieldin the query and put it in a variable variable. Then I would like to display all the data in a table. I thought I had have everything working fine, but when I displayed the table I noticed the first row was lost. How can I retrieve a value without distrupting the array? Here is my current code:

<<<==================================>>>

$my_query = mysql_query("SELECT * from schedule");

$my_Date = mysql_result($my_query,0,"gameDate");

while ( $row = mysql_fetch_array($my_query) )
{
<!-- table display code goes here! -->
}