Re: [sidcam] Show 1 record in detail, rest in a list
Hi there.
As long as you put the code for Table A first, you can start using variables from it immediately.
So when you setting up the code for Table B, you can use
$TableA-news-storiesRecord['SOMETHING']
in the WHERE clause. It's always good practice to escape any values you test in a MySQL statement though, so something like this would work better:
'where' => 'title = "'. mysql_real_escape_string( $TableA-news-storiesRecord['SOMETHING'] ) .'"',
You'll probably need to play around with that a bit but that's the jist of it all.
Let me know what you think :).
-----------------------------------------------------------
Cheers,
Ross Fairbairn - Consulting
consulting@interactivetools.com
Hire me! Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/