Proverbs

[insert_php]
$today = getdate();
echo “

“;
printf(“Today is %s, %s %d, %s”, $today[weekday], $today[month], $today[mday], $today[year]);
echo “
“;
$link = mysqli_connect(“68.178.253.32”, “d2d23622742927”, “qHvQW}}gp6-L”, “d2d23622742927”, 3311);

if ($today[mday] == 31)
{
$prov_num = rand (1, 30);
}
else
{
$prov_num = $today[mday];
}

/* Select queries return a resultset */
if ($result = mysqli_query($link, “SELECT * FROM proverb_otd WHERE proverb_otd_id = $prov_num”)) {
// printf(“Select returned %d rows.\n”, mysqli_num_rows($result));
}
/* associative array */
//$row = $result->;fetch_array(MYSQLI_ASSOC);
//printf (“%s %s”, $row[“proverb_otd_id”], $row[“proverb_text”]);

while ($row = $result->fetch_array(MYSQLI_ASSOC))
{
echo “

Proverbs ” . $row[“proverb_otd_id”] . ” (KJV)
“;
echo ereg_replace(“([0-9]+)”, ”
\\0″, $row[“proverb_text”]);
}
/* free result set */
mysqli_free_result($result);
mysqli_close($link);
[/insert_php]