|
include "functions.php";
include "connection.php";
$selectstr = "SELECT * FROM vaughanhorses WHERE page = 'Horses_in_training' ORDER BY name";
$result = mysql_query($selectstr);
$numrecs = mysql_num_rows($result);
$totrecs = ($numrecs/3)+1;
$cnt = 0;
if ($numrecs > 0)
{
while ($numrecs > 0)
{
$numrecs = $numrecs-1;
$rec = mysql_fetch_assoc($result);
$name = $rec['name'];
$racingpost = $rec['racingpost'];
if ($racingpost != "") $name = "$name";
$cnt++;
if ($cnt >= $totrecs)
{
$cnt = 1;
print " | \n";
}
print " $name \n";
}
}
?>
|
|
|
|
|
Horses In Pre-Training |
|
$selectstr = "SELECT * FROM vaughanhorses WHERE page = 'Horses_in_pre_training' ORDER BY name";
$result = mysql_query($selectstr);
$numrecs = mysql_num_rows($result);
$totrecs = ($numrecs/3)+1;
$cnt = 0;
if ($numrecs > 0)
{
while ($numrecs > 0)
{
$numrecs = $numrecs-1;
$rec = mysql_fetch_assoc($result);
$name = $rec['name'];
$racingpost = $rec['racingpost'];
if ($racingpost != "") $name = "$name";
$cnt++;
if ($cnt >= $totrecs)
{
$cnt = 1;
print " | \n";
}
print " $name \n";
}
}
?>
|
|
|
|
|
Horses at Rest |
|
$selectstr = "SELECT * FROM vaughanhorses WHERE page = 'Horses_at_rest' ORDER BY name";
$result = mysql_query($selectstr);
$numrecs = mysql_num_rows($result);
$totrecs = ($numrecs/3)+1;
$cnt = 0;
if ($numrecs > 0)
{
while ($numrecs > 0)
{
$numrecs = $numrecs-1;
$rec = mysql_fetch_assoc($result);
$name = $rec['name'];
$racingpost = $rec['racingpost'];
if ($racingpost != "") $name = "$name";
$cnt++;
if ($cnt >= $totrecs)
{
$cnt = 1;
print " | \n";
}
print " $name \n";
}
}
?>
|
|
|
|
|