I am making a query and I am returned an array. I would like to get a value from the first row of the array to put in variable. Then I would like to display the full array in a table. I have everything working fine, but when I retrieve the data for the variable, I lose that row when I display the data. Can someone offer a suggestion, here's what I have now:
<<<==================================>>>
$my_query = mysql_query("SELECT * from schedule");
$my_Date = mysql_result($my_query,0,"gameDate");
while ( $mo_row = mysql_fetch_array($mo_query) )
{
<!-- html table and mysql data here -->
}
