kINDA LIKE A SHOPPING LIST WHERE I CREATE THE PRODUCTS ND PRICE AND THE CLIENT DECDIES HOW MANY THEY WANT ... THE PRICE I PROVIDE IS MULTIPLIED BY THE QUANITITY AND THE SUM OF ALL THE ITEMS I OFFER IS TALLIED AND CAN BE EMAIL TO ME FOR PROCESSING...

i DONT NEED ANY SPECIAL LOGIN INFORMATION AS EACH CLIENT WILL BE GIVE THEIR OWN SPECIAL CUSTOMIZED PAGE WITH ITEMS THAT THYE OPURCHASE....

CAN ANYBODY SUGGEST ANYTHING FOR THIS THAT MIGHT WORK...

I ATTACHED A RAW SCREENSHOT

jim

Presently i show the resdential listings that are not hiden and the ones from each location (ie Port Hope /Cobourg etc etc)

i would also like to be able to filter then  by showing only the condo units from this list on separate e page. and maybe just the rental untils excuding the condo unts.

http://www.genedco.com/indexoct15.php


So under the Rental tabs i can THEN show only the condo listings for each town AS WELL
WITH THE SAME CONDITIONS AS I HAVE THERE RIGHT NOW FOR THE RENTAL LSITINGS
ON THE RENTAL LSITINGS THEN I DONT WANT TO INCLUDE THE CONDO OPTIONS


<?php header('Content-type: text/html; charset=utf-8'); ?>
<?php
 /* STEP 1: LOAD RECORDS - Copy this PHP code block near the TOP of your page */

 // load viewer library
 $libraryPath = 'cmsAdmin/lib/viewer_functions.php';
 $dirsToCheck = array('/services3/webpages/g/e/genedco.com/public/','','../','../../','../../../');
 foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
 if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }



 // load records from 'listings'
 list($listingsRecords, $listingsMetaData) = getRecords(array(
 'tableName' => 'listings',
 'loadUploads' => true,
 'allowSearch' => true,
  'where' => '`hide_listing` = "0" AND `content` = "cobourg"',
  ));


nY SYNTAX IS WRONG....
SO IN EFFECT I WANT THIS for the condo PAGES
'where' => '`hide_listing` = "0" AND `content` = "cobourg"', AND 'property_type' ='condo'",

AND FOR THE REST OF THE PAGES TO SHOW EVERYTHING ELSE THE EXCEPT CONDOS....

SO IF YOU CLICK ON THE RENTALS TAB AND OPTION cOBURG IT WILL EXCLUDE THE CONDOS FROM THOSE LISTINGS.

'
AND I WANT TO SHOW ONLY CONDO LISTINgs FROM THE TABLE TO DISPLAY ONA CONDO ONLY PAGE
Property Type (value): <?php echo $record['property_type'] ?><br/> WITH THE OPTION OF showing Condo only from that list




i AM GETTIng SCREWED UP with THE CORRECT SYNTAX....and the pages cant load then
CAN ANY help PLEASE









<?php header('Conte

I coudn't remember the correct syntax...thanks again

I am reworking a site and cant remember how this is done...
http://www.genedco.com/listings2016.php

I am trying to get results listed based on  the following conditions.
where the results on show listing that have both the conditions exist.... both hide listings and cobourg must exist for the result to show up.

.here are 

// load records from 'listings'
list($listingsRecords, $listingsMetaData) = getRecords(array(
'tableName' => 'listings',
'loadUploads' => true,
'allowSearch' => true,
'where' => "hide_listing ='0'",
'where' => "content = 'cobourg'",

));

Can anyone help me with the correct code

I wanted to calculate the total value  for data entered each week....

for instance... i'll use sport team for an example

WHAT I AM THINKING IS A SPORTS L;EAGUE WITH 10 MEMBERS...

EACH WILL HAVE THEIR OWN PAGE TO, LOGIN AND ENTER THEIR WEEKLY PICKS.

THESE PICKS WILL THEN BE TABULATED AND STANDINGS WILL BE KEPT....

USER 1   jim

week            team selected         wins        losses...   points     totlal Points

week 1        Dallas                       10            6            13

week 2         chicago                     6           10            34

USER 2   bill

week            team selected         wins        losses...   points     totlal Points

week 1        ney york                       10            6            13

week 2         cleveland                      6           10            34

. etc etc..... 

then i want to have the total ponts accumulated  (running toital)   and then ranked  AGAINST THE OTHER 9 USERS...  so create basically a standing page based on user input

Standings page....
tema name            wins            losses          pts

1.    Usr1 JIM.......... 16                  10            47 
2.   Usr 4 bill            12                   148         33 

etc etc

also is it possible to have selections greyed out (not avaiable) once thye have been used.

Any suggestions for the mysql syntax would be appreciated or if anybody has done anything like this any help would be appreciated...

OR ANY SUGGESTIONS WHICH WOULD BE THE MOST EFFECTIVE WAY TO SET THIS UP....

JIM

I want to do a running total of how many people  

always good to learn something new each day....

thank you for looking into this for me... Always appreciated....

Have a  great night

JIM

PS ... My  client is very happy with your software... very easy to use as usual...

I am trying to get  a listing to display in multiple areas,  fOR INSTANCE A SIMILAR LISTING TO APPEAR ON MULTIPLE PAGES.

Here is a sample per example.

http://www.economyequipmentsales.com/construction-equipment.php

 As an example   From the page example  i want to have  ...beuthling Vibratory Roller

CDN $7,000.00 appear not only in the construction equipMEnt page but also on the turf and agriculture  page as well...

WHEN YOU ADD A NEW LISTINGS  in my options was created 3 categoIies with dropdowns with page  options  where they can decide where the listing is to appear...

  Equipment Type    ( select  from  turf, construction equip, munnicpal agricuture ) etc etc

  Additional Equipment Type 1  

  Additional Equipment Type 2   

THE PROBLEM I AM HAVING IS THAT ONLY  EQUIPMENT TYPE AND EQUIPMENT TYPE 2 ARE shong up on the pages....   ADDITIONAL EQUIPMENT TYPE 1 SELECTIONS ARE NOT BEING SHOWN ON THE PAGES....

ONLY THE LISTINGS SELECTRED FROM EQUIPMENT TYPE AND ADDITIONAL EQUIPMENT TYPE 2.

THE CODE I AM USING IS BELOW AND I SUSPECT I HAVE SOMETHING WRONG IN THERE.  )OR WHERE CLASUE) CAN ANYONE MAKE A SUGGESTION?

HERE IS THE SAMPLE TOP VIEWER CODE FROM THE MUNICIPAL EQUIPMENT PAGE....

<?php header('Content-type: text/html; charset=utf-8'); ?>
<?php
/* STEP 1: LOAD RECORDS - Copy this PHP code block near the TOP of your page */

// load viewer library
$libraryPath = 'cmsAdmin/lib/viewer_functions.php';
$dirsToCheck = array('/home/glenfinbow2014/economyequipmentsales.com/','','../','../../','../../../');
foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }

// load records from 'equipment_for_sale'
list($equipment_for_saleRecords, $equipment_for_saleMetaData) = getRecords(array(
'tableName' => 'equipment_for_sale',
'where' => "equipment_type = 'municipal equipment'",
'orWhere' => "additional_equipment_type_1 = 'municipal equipment'",
'orWhere' => "additional_equipment_type_2 = 'municipal equipment'",

'loadUploads' => true,
'allowSearch' => false,
));?>

Is there any way to make the products line up from left to right.

Here is the sample page......
http://www.economyequipmentsales.com/construction-equipment.php

so in this case the Johnson Sweeper would be on the right side below the Asphalt Paver etc etc.

Here is the code i am using for this section......

<font size="+1"color="#660000"><strong>Our Newest Additions...<hr></strong></font>

<?php foreach ($equipment_for_saleRecords as $record): ?>
<?php foreach ($record['main_image'] as $index => $upload): ?>
<div class="three columns"><font face="Arial,Helvetica,sans-serif" size="-1">Location: &nbsp;<strong><?php echo htmlencode($record['location']) ?></strong></font><br/><br>
<a href="<?php echo $record['_link'] ?>"><img src="<?php echo $upload['thumbUrlPath'] ?>" width="<?php echo $upload['thumbWidth'] ?>" height="<?php echo $upload['thumbHeight'] ?>" alt="" border="0" /></a><br><br><strong><?php echo htmlencode($record['title']) ?></strong><br/><br/><strong><font color="#FF0000">CDN $<?php echo htmlencode($record['price']) ?></font></strong><br/>
</font><br/><br><br><br></div>
<?php $maxCols=4; if (@++$count % $maxCols == 6): ?></div><?php endif; ?>
<?php endforeach ?>
<?php endforeach ?>
<?php if (!$equipment_for_saleRecords): ?>
<strong>Sorry we have nothing matching your description at this time</strong><br/><br/>
<?php endif ?>

I can set this up so each individual entry can have its own info if necessary... Not necessary a slideshow gallery setup.

Can anybody suggest a plugin or application that might work with CMS Builder. or if its even possible.  If anybody has a link to something that done  can you please be kind to send a link to the working page.

If you go to
http://www.genedco.com/newsite/listings45b.php

 and do a SEARCH  with just the Parking ON SITE checked you will see the gaps io am talking about in the results.

Again the code is as follows:

<div class="row">

<font size="+1"color="#660000"><strong>Our Newest Additions...<hr></strong></font>

<?php foreach ($listingsRecords as $record): ?>
<?php foreach ($record['main_image'] as $index => $upload): ?>
<div class="three columns"><font face="Arial,Helvetica,sans-serif" size="-1">Location: &nbsp;<strong><?php echo $record['content'] ?></strong></font><br/><br>
<a href="<?php echo $record['_link'] ?>"><img src="<?php echo $upload['thumbUrlPath'] ?>" width="<?php echo $upload['thumbWidth'] ?>" height="<?php echo $upload['thumbHeight'] ?>" alt="" border="0" /></a><br><br>
<font face="Arial,Helvetica,sans-serif" size="-1"><?php echo $record['property_type:label'] ?><br><strong>$<?php echo htmlencode($record['price']) ?>&nbsp;<?php echo $record['per:label'] ?>&nbsp;<br><?php echo $record['utilities:label'] ?></strong><br><?php echo $record['rental_status:label'] ?>&nbsp;<?php echo $record['occupancy_date:label'] ?>&nbsp;<?php echo $record['occupany_date_day:label'] ?></font><br/><br><br><br clear="left"></div>
<?php $maxCols=4; if (@++$count % $maxCols == 6): ?></div><?php endif; ?>
<?php endforeach ?>
<?php endforeach ?>
<?php if (!$listingsRecords): ?>
<strong>Sorry we have nothing matching your description at this time</strong><br/><br/>
<?php endif ?>

</div>

doesnt seem to cha nge anything and added the <br clear>  SO THE CODE NOW LOOKS LIKE THIS ...

<div class="row">

<font size="+1"color="#660000"><strong>Our Newest Additions...<hr></strong></font>

<?php foreach ($listingsRecords as $record): ?>
<?php foreach ($record['main_image'] as $index => $upload): ?>
<div class="three columns"><font face="Arial,Helvetica,sans-serif" size="-1">Location: &nbsp;<strong><?php echo $record['content'] ?></strong></font><br/><br>
<a href="<?php echo $record['_link'] ?>"><img src="<?php echo $upload['thumbUrlPath'] ?>" width="<?php echo $upload['thumbWidth'] ?>" height="<?php echo $upload['thumbHeight'] ?>" alt="" border="0" /></a><br><br>
<font face="Arial,Helvetica,sans-serif" size="-1"><?php echo $record['property_type:label'] ?><br><strong>$<?php echo htmlencode($record['price']) ?>&nbsp;<?php echo $record['per:label'] ?>&nbsp;<br><?php echo $record['utilities:label'] ?></strong><br><?php echo $record['rental_status:label'] ?>&nbsp;<?php echo $record['occupancy_date:label'] ?>&nbsp;<?php echo $record['occupany_date_day:label'] ?></font><br/><br><br><br clear="left"></div>
<?php $maxCols=4; if (@++$count % $maxCols == 6): ?></div><?php endif; ?>
<?php endforeach ?>
<?php endforeach ?>
<?php if (!$listingsRecords): ?>
<strong>Sorry we have nothing matching your description at this time</strong><br/><br/>
<?php endif ?>

</div>

If you go to 
http://www.genedco.com/newsite/listings45b.php

Do a search with  LOCATION :COBURG     BEDRROMS  2   AND    PARKING ON sITE   CHECKED     you will see the gap i am talking about IN THE RESULTS

wrong URL
http://www.genedco.com/newsite/listings.php

These are lined up ok right now but if i change the listing around i get gaps...

Bizarre

Here is a sample page of the listings as working
http://www.genedeco.com/newsite/listings.php

I am using Foundation 12 column grid system...
The problem i get is when i shuffle listings around ie sort order  get gap spacing.
ie some orws have all four listings across and some 3 or 4  then a row with two then four etc....

 The code i am using  is as follows...

Can someone see if perhaps i am doing something wrong in my code to get this erractic results..

I am thinking it has to do with  the line
<?php $maxCols=4; if (@++$count % $maxCols == 6): ?></div><?php endif; ?> or soemthing like that.

Here is the code...

<div class="row">
<div class="twelve columns">
<font size="+1"color="#660000"><strong>Our Newest Additions...<hr></strong></font>

<?php foreach ($listingsRecords as $record): ?>
<?php foreach ($record['main_image'] as $index => $upload): ?>
<div class="three columns"><font face="Arial,Helvetica,sans-serif" size="-1">Location: &nbsp;<strong><?php echo $record['content'] ?></strong></font><br/><br>
<a href="<?php echo $record['_link'] ?>"><img src="<?php echo $upload['thumbUrlPath'] ?>" width="<?php echo $upload['thumbWidth'] ?>" height="<?php echo $upload['thumbHeight'] ?>" alt="" border="0" /></a><br><br>
<font face="Arial,Helvetica,sans-serif" size="-1"><?php echo $record['property_type:label'] ?><br><strong>$<?php echo htmlencode($record['price']) ?>&nbsp;<?php echo $record['per:label'] ?>&nbsp;<br><?php echo $record['utilities:label'] ?></strong><br><?php echo $record['rental_status:label'] ?>&nbsp;<?php echo $record['occupancy_date:label'] ?>&nbsp;<?php echo $record['occupany_date_day:label'] ?></font><br/><br><br><br></div>
<?php $maxCols=4; if (@++$count % $maxCols == 6): ?></div><?php endif; ?>
<?php endforeach ?>
<?php endforeach ?>
<?php if (!$listingsRecords): ?>
<strong>Sorry we have nothing matching your description at this time</strong><br/><br/>
<?php endif ?>

</div>

it works

I am unclear of what code should go up at the top to produce results based on the value of the show listing being checked...Here is the sample code..

Any help would be appreciated..

Here is the sample viewer code and the field listiing below...

_______________________________________________________________________

<?php header('Content-type: text/html; charset=utf-8'); ?>
<?php
/* STEP 1: LOAD RECORDS - Copy this PHP code block near the TOP of your page */

// load viewer library
$libraryPath = 'cmsAdmin/lib/viewer_functions.php';
$dirsToCheck = array('/services3/webpages/g/e/genedxx.com/public/','','../','../../','../../../');
foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }

// load records from 'listings'
list($listingsRecords, $listingsMetaData) = getRecords(array(
'tableName' => 'listings',
'loadUploads' => true,
'allowSearch' => false,
));

the field i want to only show results is the the following if it is selected...

Hide Listing (value): <?php echo $record['hide_listing'] ?><br/>
Hide Listing (text): <?php echo $record['hide_listing:text'] ?><br/>