|
|
$username="jparish";
$password="lut84her";
$database="jparish_roster";
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query='SELECT `Roster` . * FROM Roster WHERE `active` = "Y" ORDER BY `roster_id` ASC LIMIT 0, 200 ';
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
?>
|