'pages',
'where' => "`num` = '1'",
'loadUploads' => true,
'allowSearch' => false,
'limit' => '1',
));
$pagesRecord = @$pagesRecords[0]; // get first record
if (!$pagesRecord) { dieWith404("Record not found!"); } // show error message if no record found
//This function gets the last number from the URL. If there is no number it will return 0;
$number = getLastNumberInUrl();
//This if statement will set the $number variable to the number 3 if it is currently less than 1. Change the number 3 to whatever record you want to load.
$nothingSelected = ($number < 1)? true : false;
//The $_REQUEST area variable should contain the table that needs to be searched.
$area = @$_REQUEST['area'];
// And the num field should contain the num value.
$number = @intval($_REQUEST['num']);
//Set the number value here if it's less than 1. Note: this needs to be a value that appears in both tables.
$number = ($number < 1)? '3' : $number;
//Set the table. Automatically sets to practice_areas if it's not industries to stop people trying to other tables
$area = ($area == 'industries')? 'industries' : 'practice_areas';
// load detail record from 'practice_areas'
list($practice_areasRecords, $practice_areasMetaData) = getRecords(array(
'tableName' => $area,
'where' => whereRecordNumberInUrl(1), // If no record # is specified then latest record is shown
'loadUploads' => true,
'allowSearch' => false,
'limit' => '1',
));
$detailRecord = @$practice_areasRecords[0]; // get first record
if (!$detailRecord) { dieWith404("Record not found!"); } // show error message if no record found
// load list records from 'practice_areas'
list($practice_areasRecords, $practice_areasMetaData) = getRecords(array(
'tableName' => 'practice_areas',
'loadUploads' => false,
'allowSearch' => false,
));
// load list records from 'industries'
list($industriesRecords, $industriesMetaData) = getRecords(array(
'tableName' => 'industries',
'loadUploads' => false,
'allowSearch' => false,
));
?>
Title
