https://interactivetools.com/forum/forum-posts.php?Using-a-Multi-Record-on-a-Category-Menu-page-72312 Mon, 20 Jul 2026 03:36:49 -0700 en-us https://interactivetools.com/forum/forum-posts.php?postNum=2210108#post2210108 ]]> Mon, 14 Mar 2011 16:38:45 -0700 forum-posts.php?postNum=2210108#post2210108 https://interactivetools.com/forum/forum-posts.php?postNum=2210046#post2210046
jason
]]> Tue, 08 Mar 2011 14:23:13 -0800 forum-posts.php?postNum=2210046#post2210046 https://interactivetools.com/forum/forum-posts.php?postNum=2210045#post2210045
A good way to do the where clause would be like this:

'where' => "num = '". mysql_escape($newsid)."' ",

we use mysql_escape to make sure no one is putting malicious code in the url string.

You would only use the "%" in the where clause when using the LIKE operator. Also, the tab characters("\t") are only used for multi-value lists.

Hope this helps clarify. Is everything working now?
]]> Tue, 08 Mar 2011 14:15:33 -0800 forum-posts.php?postNum=2210045#post2210045 https://interactivetools.com/forum/forum-posts.php?postNum=2210044#post2210044
I have changed the url structure to this:
show.php?type=news&newsid=2&page=4

This viewer code works correctly:
// load news record details
list($news_details, $news_detailsMetaData) = getRecords(array(
'tableName' => 'news_items_template',
'where' => 'num=2',
'limit' => '1',
));
$news_details = @$news_details[0]; // get first record

But if I modify the where statement to utilize the a number from the url it stops working. like this:

// load news record details
$newsnum = @$_GET["newsid"];

list($news_details, $news_detailsMetaData) = getRecords(array(
'tableName' => 'news_items_template',
'where' => "num='%\t$newsnum\t%'",
'limit' => '1',
));
$news_details = @$news_details[0]; // get first record

if i change my where statement to the following it works properly.

'where' => "num='{$newsid}'",
]]> Tue, 08 Mar 2011 13:59:41 -0800 forum-posts.php?postNum=2210044#post2210044 https://interactivetools.com/forum/forum-posts.php?postNum=2210043#post2210043
There are actually quite a few things happening on show.php. From what I can tell, the category being selected is being based on the last number in your URL string.

I would recommend starting out selecting your news/event record not using whereRecordNumInUrl(). Instead use the 'where' option to create your own where clause. Once that's working, you can pass your category number at the end of your url without worrying about how it will affect your record selection.

In order to give an exact example of how this is done, I would need to be able to see more of what's happening on your page and in your database, which isn't something we can handle through support. If you'd like us to take a look at getting this functionality working for you, please send an email to consulting@interactivetools.com and we can go over some options with you.

Hope this helps
]]> Tue, 08 Mar 2011 13:34:41 -0800 forum-posts.php?postNum=2210043#post2210043 https://interactivetools.com/forum/forum-posts.php?postNum=2210015#post2210015 ]]> Mon, 07 Mar 2011 15:41:25 -0800 forum-posts.php?postNum=2210015#post2210015 https://interactivetools.com/forum/forum-posts.php?postNum=2210008#post2210008
I took a look at your code, and I think what's happening is you're not passing any category information in you're url.

You can try passing "page" in your url and then manually setting your WHERE clause to get your news using id and type instead of using whereRecordNumInUrl()

Hope this helps get you started.
]]> Mon, 07 Mar 2011 14:54:57 -0800 forum-posts.php?postNum=2210008#post2210008 https://interactivetools.com/forum/forum-posts.php?postNum=2209993#post2209993
Thanks.
]]> Mon, 07 Mar 2011 13:17:03 -0800 forum-posts.php?postNum=2209993#post2209993 https://interactivetools.com/forum/forum-posts.php?postNum=2209991#post2209991
Can you attach show.php as well as the code that outputs your menu?

Thanks
]]> Mon, 07 Mar 2011 13:01:58 -0800 forum-posts.php?postNum=2209991#post2209991 https://interactivetools.com/forum/forum-posts.php?postNum=2209958#post2209958
news list

Ideally I want the News category to stay highlighted.
]]> Thu, 03 Mar 2011 21:04:30 -0800 forum-posts.php?postNum=2209958#post2209958