<?php class Site { function greeting() { //This function is used to display the random greeting on the front page. //Grab how many rows are in this table $get_num_sql = "SELECT * FROM `greeting`"; $get_num_query = mysql_query($get_num_sql); $get_num = mysql_num_rows($get_num_query); /*if(!$get_num_query) { echo "Get num: ". mysql_error(); }*/ //Produce a random number from how many rows are in the table. $num = rand(1, $get_num); //User the random number to select the corresponding greeting. $greeting_sql = "SELECT * FROM `greeting` WHERE `greeting_id` = '$num'"; $greeting_query = mysql_query($greeting_sql); $greeting = mysql_fetch_assoc($greeting_query); /*if(!$greeting_query) { echo "Greeting: ". mysql_error(); }*/ return $greeting; } }?>