Help

[rubbersoul]

My Code:

<?php require_once('Connections/uptime.php'); ?>
<?php
mysql_select_db($database_uptime, $uptime);
$query_uptime = "SELECT * FROM september ORDER BY system DESC";
$uptime = mysql_query($query_uptime, $uptime) or die(mysql_error());
$row_uptime = mysql_fetch_assoc($uptime);
$totalRows_uptime = mysql_num_rows($uptime);

mysql_select_db($database_uptime, $uptime);
$query_Recordset1 = "SELECT * FROM september ORDER BY system DESC";
$Recordset1 = mysql_query($query_Recordset1, $uptime) or die('Error: '.mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);

mysql_free_result($Recordset1);

mysql_free_result($uptime);
?>

<table width="100%" border="1" cellpadding="1" cellspacing="1">
<tr>
<td>system</td>
<td>day</td>
<td>date</td>
<td>downtime</td>
</tr>
<?php do { ?>
<tr>
<td><?php echo $row_uptime['system']; ?></td>
<td><?php echo $row_uptime['day']; ?></td>
<td><?php echo $row_uptime['date']; ?></td>
<td><?php echo $row_uptime['downtime']; ?></td>
</tr>
<?php } while ($row_uptime = mysql_fetch_assoc($uptime)); ?>
</table>

My error:

Warning: mysql_select_db(): supplied resource is not a valid MySQL-Link resource in C:\Inetpub\wwwroot\uptime\index.php on line 9

Warning: mysql_query(): supplied resource is not a valid MySQL-Link resource in C:\Inetpub\wwwroot\uptime\index.php on line 11
Error:

[eoghain]

Does Connections/uptime.php connect to MySQL and store the link as $uptime? If not then that is your problem. If it does then you'd better check uptime.php to make sure the connection information is correct and that the user who runs your web server has permission to connect to MySQL.

[TheDefender]

Debug by adding a die to your mysql_select_db statement.

mysql_select_db($database_uptime, $uptime) or die(mysql_error());