Looking for a simpler way to do this...

Hi zip222,

PHP doesn't replace variables in single-quoted strings, so you'll need to change your quotes to double-quotes:

'where' => "$section=1",

Does that help?

Please be very careful about where $section comes from. If you're getting it from the $_REQUEST, you'll want to do some sanity checking on it before inserting it into SQL to avoid SQL injection attacks. If you'd like some help with this, please post a little more of your page and I can show you how to keep things safe.

If you have any questions, please let me know.

Chris,

What I am doing is part of an include....

In the main file:

<?php
$section == "sectionnamegoeshere";
include ("includefile.inc.php");
?>


And then in the include file:

list($sidebar_featuresRecords, $sidebar_featuresMetaData) = getRecords(array(
'tableName' => 'sidebar_features',
'where' => "$section=1",
));

Does this present any issues?

Hi,

This shouldn't present an issue, but there may be a few things you want to change just to be safe.

First, you'll need to change where you're getting your $section variable from this:
$section == "sectionnamegoeshere";
to this:
$section = "sectionnamegoeshere";

You only want to use the 1 "=" when assigning a value.

Second, change where you're getting your records to this:

list($sidebar_featuresRecords, $sidebar_featuresMetaData) = getRecords(array(
'tableName' => 'sidebar_features',
'where' => mysql_escape($section)."=1",
));

This will ensure there is no malicious code hidden in your $section variable. This is just to be safe.

Hope this helps.

Thanks Jason. Works perfectly.

The two equal signs was just a typo :)