'Where' clause validation

4 posts by 2 authors in: Forums > CMS Builder
Last Post: August 20, 2008   (RSS)

By terryally - August 20, 2008 - edited: August 20, 2008

Good morning from England.

I just want to pass some code by you to get your advice and correct an error message.

The scenario is that I have set up a Lunch Menu using the Multi-record menu type. The menu has Starters, Main Course, Desserts, and Bar - all of which I want to list in each category on the same page. I could not find any instruction about how to achieve this so I assigned the SELECT call as a variable first as illustrated in the code section below.

It works. But I am still getting the error message:
Notice: Undefined variable: lunch_menuRecords in /home/lakesideint/www/www/menu.php on line 6
Notice: Undefined variable: lunch_menuRecords in /home/lakesideint/www/www/menu.php on line 14.

The undefined variables to which it refers are $main and $starter

How do I correct this?

P.S. My test page is http://lakesideint.server266.com/menu.php



$main = $lunch_menuRecords;


list($main, $lunch_menuMetaData) = getRecords(array(
'tableName' => 'lunch_menu',
'where' => 'course="Main"',
));

$starter = $lunch_menuRecords;

list($starter, $lunch_menuMetaData) = getRecords(array(
'tableName' => 'lunch_menu',
'where' => 'course="Starter"',
));

Terry

Re: [terryally] 'Where' clause validation

By terryally - August 20, 2008 - edited: August 20, 2008

Apologies to all. Here is the solution.

It seems that CMS Builder is much more efficient that writing a SELECT statement and query.

What I did was to generate the code using the WHERE clause for each category I wanted to display. Remember my categories are "Starter", "Main", "Dessert" etc. The field name of my categories is called "course" so I generated the code for <course="Starter"> and got the following:

list($lunch_menuRecords, $lunch_menuMetaData) = getRecords(array(
'tableName' => 'lunch_menu',
'where' => 'course="Starter"',
));

Which I placed immediately before the loop, viz

<?php
list($lunch_menuRecords, $lunch_menuMetaData) = getRecords(array(
'tableName' => 'lunch_menu',
'where' => 'course="Starter"',
));
?>


<?php foreach ($lunch_menuRecords as $record): ?>

<?php echo $record['item'] ." ". $record['cost'] ?><br/>
<?php echo $record['description'] . " " .$record['notes'] ?><br/>

<?php endforeach; ?>

I then repeat the same for Main Course and Desserts.

So the difference is that I did not place the code at the top of the page before everything else (except the include file: require_once "/my/path/to/cms-admin/lib/viewer_functions.php";) but immediately before the loop.

The results can be viewed at the development site: http://lakesideint.server266.com/dining/menu_lunch.php

Cheers
Terry

Re: [terryally] 'Where' clause validation

By Donna - August 20, 2008

Hey Terry! Glad to hear you got that sorted out -- thanks for sharing! :)
Donna

--
support@interactivetools.com