Re: [ross] cross information
Hi guys,
This is really urgent now. I have refined what I'm after, which is much simpler than above. I now just need some advice on a where clause:
I have a Services table that has 10 services listed in it. There are about 3 other sections that will be pulling this information in - our people, news and events (i.e. matching people, news and events will be presented on a service page).
Let's use our people as the example. In the Our People section, I have added a Service list field - I have made this list "Get Options From Database", selected the Services table and used the title field as the labels and the values.
In my our_services.php detail page, I have this:
<?php
require_once "/home/jglimpse/public_html/mst/cmsAdmin/lib/viewer_functions.php";
//detail of this service
list($servicesRecords, $servicesMetaData) = getRecords(array(
'tableName' => 'services',
'where' => whereRecordNumberInUrl(1),
'loadUploads' => '0',
'limit' => '1',
));
$servicesRecord = @$servicesRecords[0]; // get first record
//associated people to this service
list($our_peopleRecords, $our_peopleMetaData) = getRecords(array(
'tableName' => 'our_people',
'allowSearch' => '0',
'where' => ' services LIKE "%something goes here%" ',
));
?>
How do I get the where clause to pull the name of the service page we're now on?
Thanks for your help in advance.[:)]