Where Statement Issue
3 posts by 2 authors in: Forums > CMS Builder
Last Post: February 22, 2012 (RSS)
By efi-revivo - February 21, 2012 - edited: February 21, 2012
I have a problem with my page.
I try to load in Detail page a specific list from other table and matching to a filed (num) in the detail page.
I try to load in Detail page a specific list from other table and matching to a filed (num) in the detail page.
list($test_listingRecords, $test_listingMetaData) = getRecords(array(
'tableName' => 'test_listing',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
));
$test_listingRecord = @$test_listingRecords[0]; // get first record
// show error message if no matching record is found
if (!$test_listingRecord) { dieWith404("Record not found!"); }
list($eventRecords, $eventMetaData) = getRecords(array(
'tableName' => 'event',
'limit' => '6',
'where' => 'num="$test_listingRecord('posts_num')"', <----- This filed control by the first table ($test_listingRecords)
));Re: [efi-revivo] Where Statement Issue
By Jason - February 21, 2012
Hi,
It looks like you're just having some syntax issues in your where statement.
Try this:
Hope this helps
It looks like you're just having some syntax issues in your where statement.
Try this:
list($eventRecords, $eventMetaData) = getRecords(array(
'tableName' => 'event',
'limit' => '6',
'where' => "num = '".$test_listingRecord['posts_num']."'",
));Hope this helps
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/