Here's my code, but I get errors
Notice: Undefined variable: orderby in F:\Html\fsyc_database\graduates_list.php on line 11
Notice: Undefined variable: color in F:\Html\fsyc_database\graduates_list.php on line 30
<?
$connection = mysql_connect("localhost","root","paraffin");
$db = mysql_select_db("job_seekers", $connection);
$table_name = 'personaldetails';
If (isset($sorting))
{
$orderby = "ORDER BY $sorting ";
If ($sorting == "personaldetails") { $orderby .= "ASC"; } else { $orderby .= "DESC"; }
}
$sql = mysql_query("SELECT * FROM $table_name $orderby");
// PRINT FIELD NAMES AT TOP OF PAGE WITH LINK TO SORT BY THAT FIELD
$number_of_fields = mysql_num_fields($sql); // STORE NUMBER OF FIELDS
echo "<TABLE><TR>";
for ($ii=0; $ii < $number_of_fields; $ii++)
{
$fn = mysql_field_name($sql, $ii); // Grabs the field name
$fn = strtoupper(substr($fn,0,1)) . substr($fn,1,strlen($fn)); // Capitalizes first letter
echo "<td bgcolor=gray><A HREF={$_SERVER['PHP_SELF']}?sorting=$fn>$fn</A></TD>";
}
echo "</TR>";
// NOW PRINT ALL INFO FOR EVERY COLUMN FOR ALL RESULTS
while ($result = mysql_fetch_array($sql))
{
if ($color == 'White') { $color = 'Silver'; } else { $color = 'White'; }
echo "<TR>";
for ($i=0; $i < $number_of_fields; $i++)
{
$fv = $result[$i];
echo "<TD BGCOLOR=$color><a>$fv</a></TD>"; }
echo "</TR>";
}
echo "</TABLE>";
?>
