$options['where']

hello, i was reading this post and have the same issue not working i have as follows:

require_once "............viewer_functions.php";
$options = array(); // NOTE: see online documentation for more details on these options
$options['tableName'] = 'vehiculos'; // (REQUIRED) MySQL tablename to list record from. Example: "article";
$options['recordNum'] = '9'; // (optional) Record number to display. Example: "1"; Defaults to number on end of url, then 1
$options['where'] = ''; // (ADVANCED) MySQL WHERE conditions to use INSTEAD of recordNum to look up record. Example: "fieldname = 'value'"
$record = getRecord($options);

would like it to be replaced with a value from another table in mysql so i did this:

require_once "............viewer_functions.php";
$options = array(); // NOTE: see online documentation for more details on these options
$options['tableName'] = 'cajas'; // (REQUIRED) MySQL tablename to list record from. Example: "article";
$options['recordNum'] = '1'; // (optional) Record number to display. Example: "1"; Defaults to number on end of url, then 1
$options['where'] = ''; // (ADVANCED) MySQL WHERE conditions to use INSTEAD of recordNum to look up record. Example: "fieldname = 'value'"
$record = getRecord($options);
$cajita = $record['caja1']; this is to have a value from one table[/#ff0000]
?>
<?php
require_once "............viewer_functions.php";
$options2 = array(); // NOTE: see online documentation for more details on these options
$options2['tableName'] = 'vehiculos'; // (REQUIRED) MySQL tablename to list record from. Example: "article";
$options2['recordNum'] = ''; // (optional) Record number to display. Example: "1"; Defaults to number on end of url, then 1
$escapedVar = escapeMysqlString($cajita);
$options2['where'] = "num[/#ff0000] = '$escapedVar'"; // (ADVANCED) MySQL WHERE conditions to use INSTEAD of recordNum to look up record. Example: "fieldname = 'value'"
$record = getRecord($options);

but for some reason itwont work dispaying $record['num'] as the number in $cajita

any help with this would be great

Hi mawebplus,

Double check your second block of code. If you're calling your options $options2 you want to make sure you're passing that to getRecord as well:

$record = getRecord($options2);

Also, you might want to name your $record variables something else so they don't overwrite each other. For example, $cajasRecord.

Let me know if that helps!

you guys rock!

finally i madea page with 3 iframes calling 3 different things that the client simply changes on admin fields thnx!!

to share it:

http://www.awebolovendo.com/index.php

the three pics on top