Like this code?
Show the author your appreciation.
<?php
( 'NUM_COLS' , 2 );
'../includes/config.inc' );
$_SESSION [ 'user' ][ 'auth' ])) {
header ( "Location: http://www.nyaspdp.org/nyaspdp.php" );
ob_end_clean ();
// set the page title
$page_title = 'NYASPDP Browse Subjects' ;
'../includes/reg_header.htm' );
// connect to the database
require_once ( '../includes/dbconnect.php' );
// START THE IMPORTANT STUFF
$query = "SELECT cat_id, cat_name FROM catg WHERE cat_name !='!INSTRUCTOR SELECT ONE'" ;
$result = @ mysql_query ( $query ) or die( mysql_error ());
$cats = array();
$cat = mysql_fetch_array ( $result )) {
array_push ( $cats , $cat );
$catsCnt = count ( $cats );
"\n<h1>Select A Subject</h1>" ;
"\n<table border='0' cellpadding='2' cellspacing='2' width='90%' align='center'>" ;
"\n<tr>" ;
$x = 0 ; $x < $catsCnt ; $x ++) {
$x + 1 ) % NUM_COLS == 0 ) {
"<td class='tblData' width='" .( 100 / NUM_COLS ). "%' NOWRAP><a href='courses.php?sid=" . $cats [ $x ][ 'cat_id' ]. "' class='normal'>" . $cats [ $x ][ 'cat_name' ]. "</a></td></tr>" ;
$x !=( $catsCnt - 1 )) echo "\n<tr>" ;
"<td class='tblData' width='" .( 100 / NUM_COLS ). "%' NOWRAP><a href='courses.php?sid=" . $cats [ $x ][ 'cat_id' ]. "' class='normal'>" . $cats [ $x ][ 'cat_name' ]. "</a></td>" ;
$numSpaces = $catsCnt % NUM_COLS ;
$numSpaces != 0 ) {
$i = 0 ; $i <= $numSpaces ; $i ++) {
"<td width='" .( 100 / NUM_COLS ). "%' NOWRAP> </td>" ;
"</tr>\n" ;
"\n</table>" ;
// END THE IMPORTANT STUFF
include ( '../includes/reg_footer.htm' );
?>
A very simple way to build and do a hierarchical html categories browser without javascript , just using html php and mySql
Categories : HTML and PHP , Databases , Algorithms , PHP , MySQL Function for retrieving MySQL enum values into a PHP array.
Categories : PHP , Databases , MySQL , Arrays PHP and MySQL scripting for Muyltiple CheckBoxes Categories : HTML and PHP , MySQL , Databases , PHP create a grid out of <INPUT TYPE=TEXT> then saving to a database. Uses
a 'multi-dimension array', but not really as the array is just one big array
with the index of "[$i][$j]". Have a look at the code and you'll see what I
mean. Categories : PHP , MySQL , Arrays , Databases Dynamically generated pop-ups (Select items) Categories : PHP , HTML and PHP , MySQL , Databases DDN FFA Network Script Categories : PHP , MySQL , Complete Programs , HTML and PHP , Databases This program allows you to upload an ODBC ressource - i.e. an MS-Access database to a MySQL server. Categories : Databases , MySQL , Complete Programs , PHP , Databases Paginating the mySQL data Categories : PHP , Algorithms , Databases , MySQL , HTML and PHP Simple conversion functions to change MySQL dates to arrays, arrays to MySQL dates.
Categories : PHP , Arrays , Date Time , Databases , MySQL Editing the virtusertable and sendmail.cw via PHP3.0 and Mysql Categories : MySQL , HTML and PHP , PHP , Databases This function will populate the options in a drop down HTML select list
in a form from a database query.
Categories : MySQL , General SQL , PHP , HTML and PHP , Databases This simple function will take a few arguments and easily set a associative array for each column in a result from a MySQL query Categories : Databases , PHP , MySQL , Arrays How to load a query result into a PHP Array Categories : PHP , Databases , Arrays , MySQL Pull Down Surfing - Surf on Change Categories : Java Script , MySQL , HTML and PHP , PHP , Databases How can i Preload a 'SELECT MULTIPLE'? Categories : HTML and PHP , PHP , MySQL , Databases
