Where clause on a joined field?

Hello,

I have a video gallery, and each video has a category field. The categories are stored in a separate table called "categories" so I am able to add more categories down the road.

I'm trying to do this:

<?php

require_once "/home/test/public_html/cmsAdmin/lib/viewer_functions.php";

list($videoRecords, $videoMetaData) = getRecords(array(
'tableName' => 'video',
'where' => 'category = "A category"',
));

?>

but it's not understanding my Where clause.

I noticed in CMSB's generated viewer foreach code that the category field was being joined, as below:

<?php echo join(', ', getListLabels('video', 'category', $record['category'])); ?>


How do I modify the Where clause from above so that I can create a list of videos from a specific category?

And can I create additional $videoRecords lists for each other category, that way I can arrange each list on the page where I want it.

Thanks