"; } } if (!$sort) $sort="$field1"; $query = "select * from $table"; switch ($sort) { case "id": $query=$query. " order by id"; break; case "$field1": $query=$query. " order by $field1"; break; case "$field2": $query=$query. " order by $field2"; break; case "$field3": $query=$query. " order by $field3"; break; } if ($read) { $query = "select * from $table where id=$read"; } if ($keyword) { $query = "select * from $table where $field1 LIKE '%$keyword%' OR $field2 LIKE '%$keyword%' OR $field3 LIKE '%$keyword%'"; } $result = mysql_query($query); $rows = mysql_num_rows($result); echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; if (!$read) { echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; } if (!$read) { while ($row = mysql_fetch_row($result)) { echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; } } if ($read) { $row = mysql_fetch_row($result); echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; } mysql_close(); ?>

ID	$field1_label	$field2_label	$field3_label	"; if ($keyword) echo "View All"; echo "
New				"; echo "
$row[0]	$row[1]	$row[2]	$row[3]	Edit	Delete
$row[0]