[Resolved] Displaying data from a query

[lyndonlegend]

I am very new to php and am trying to use it to develop my website which I do for free on my spare time for local youth hockey association. The current site without any php is www.reedsburgpolars.com

Any help or suggestions would be greatly appreciated.

I am trying to display information from a mysql table. The webpage should show DAY, DATE, TIME, HOME TEAM, OPPONENT and GAME TYPE.

The other thing I would like to do is to create a form with dropdown boxes.

I have the following code:

<?php

$host="localhost";
$username="XXXXXX";
$password="XXXXXX";
$database="XXXXXX";

$tablename="homeice";

$con= mysql_connect($host,$usrnm,$passwrd)
or die("Connection failed!!! <br>");

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$sql = mysql_query("SELECT * FROM homeice
WHERE date BETWEEN '2005-10-31' and '2005-12-01'
ORDER BY 'date' ASC");
?>

<table border="4" width="100%"><tr>

<?php
while($row = mysql_fetch_assoc($sql)){
?>
<td><?php echo $row["Day"];?></td>

<td><?php echo $row["Date"];?></td>

<td><?php echo $row["Time"];?></td>

<td><?php echo $row["Home Team"];?></td>

<td><?php echo $row["Opponent"];?></td>

<td><?php echo $row["Game Type"];?></td>
<?php
}
?>
</tr>
</table>

[devinemke]

<?php
mysql_connect('localhost', 'XXXXXX', 'XXXXXX') or exit(mysql_error()); 
mysql_select_db('XXXXXX') or exit(mysql_error());

$result = mysql_query("SELECT * FROM homeice WHERE date BETWEEN '2005-10-31' AND '2005-12-01' ORDER BY date") or exit(mysql_error());
if (mysql_num_rows($result))
{
	echo '<table border="4" width="100%">'; 
	while ($row = mysql_fetch_assoc($result))
	{
		echo '
		<tr>
		<td>' . $row['Day'] . '</td>
		<td>' . $row['Date'] . '</td>
		<td>' . $row['Time'] . '</td>
		<td>' . $row['Home Team'] . '</td>
		<td>' . $row['Opponent'] . '</td>
		<td>' . $row['Game Type'] . '</td>
		</tr>
		';
	}
	echo '</table>';
}
else
{
	echo 'no records found matching that criteria';
}
?>

[lyndonlegend]

I tried what you stated above, but I am getting the same results I received earlier. The rows are not printing or showing on the webpage. You can see what I mean on this site:

www.reedsburgpolars.com/nov_homeice.php

[devinemke]

are you using the exact code that i posted? i ask because my code spits out very specific errors if any part of the script fails. if you are using my code and are still seeing nothing you should check the error_reporting directive in your php.ini and set it to E_ALL or use the [man]error_reporting[/man] function to do the same thing.

[lyndonlegend]

It isn't giving an error. The sql for retrieving the data is correct. It should display two rows as there are currently two home dates. However, you can see the table area, but no data going into it. I purposely left out the password and received the error saying I needed the password. So I know the errors are showing.

[devinemke]

what happens when you run this same query from the mySQL command line console?

[lyndonlegend]

I made a couple of changes today keeping the table within the php code and it worked.