Sigh... I know it should be easy... Help.. Please.

Hi BigBear,

Don't worry, you don't need to know PHP and MySql unless you want to do really advanced stuff.

Let's try this one step at a time. First, to get random results you can set the orderBy field to RAND() like this:

$options['orderBy'] = 'RAND()';

Next, you want to display only banners with c_of_c checked? You use the where option to filter like this:

$options['where'] = 'c_of_c = "1"';

And then the company name, how do you want that passed to the page? Your example link isn't working anymore.

PS: To learn basic PHP and MySQL just google "Learn PHP" and "Learn Mysql"

Hope that helps! Let me know!

Hi Dave,

here is what I have - with your additions... I still get an error though.

<?php require_once "/home/bigbearcreations/alexandria-ontario.net/cmsAdmin/lib/viewer_functions.php";
$options = array(); // NOTE: see online documentation for more details on these options
$options['orderBy'] = 'RAND()';
$options['tableName'] = 'clients'; // (REQUIRED) MySQL tablename to list record from. Example: "article";
$options['recordNum'] = ''; // (optional) Record number to display. Example: "1"; Defaults to number on end of url, then 1
$options['where'] = 'c_of_c = "1"';
$record = getRecord($options);
?>

This is what I use to put the uploaded banner on the page. I know its something I am doing wrong.. but I can't figure out any other options.

<img src="<?php echo $upload['urlPath'] ?>" width="<?php echo $upload['width'] ?>" height="<?php echo $upload['height'] ?>" />

This is the error that I am getting at the bottom of the page where I want the uploaded banner displayed

Page Viewer (clients) errors
Unknown option 'orderBy' specified. Valid option names are: (tableName, recordNum, where)


One method I did use was to paste the banner in a WYSIWYG window and then display that... But I would rather have the client upload his actual banner and just be able to paste that code where I need it.

Sorry about the link problem: here is the proper link: http://www.alexandria-ontario.net/clientsPage.php The banner should show up on any of the clientspage creations. If I did another typo, just select the business directory from any of the menus.

Thanks for your help.

Rob

No worries, we want to start with a "List Viewer" for this one, not a "Page Viewer".

Try creating a list viewer, then adding those options, and also setting 'pageNum' and 'perPage' to 1 (so it always shows the first result and only 1 result).

If you get an error still, attach the php file to this thread and I'll have a look at it for you.

Hi BigBear,

Try replacing this line


<img src="<?php echo $upload['urlPath'] ?>" width="<?php echo $upload['width'] ?>" height="<?php echo $upload['height'] ?>" /></th>

with this:

<?php foreach ($listRows as $record): ?>
<?php if ($record): ?>
<?php foreach (getUploads($options['tableName'], 'uploads', $record['num']) as $upload): ?>
<img src="<?php echo $upload['urlPath'] ?>" width="<?php echo $upload['width'] ?>" height="<?php echo $upload['height'] ?>" /></th>
<?php endforeach ?>
<?php endif ?>
<?php endforeach ?>

That's the extra bit of code that loops over each matching record (just 1 in this case) and then loops over each upload for that 1 record.

If that's does work and you want me to login and take a look just email me ftp details at dave@interactivetools.com

Hope that helps!

Hi again.

I made the changes you gave me, and it still does not want to display an uploaded picture... so here is what I did. Instead of the field being an upload file, I changed the field to a WYSIWYG type. I then insert the banner as an image. Instead of displaying the downloaded file record, I now ask it to show the WYSIWG content, and no problems. Wierd.

I have encountered one problem with this though - I cannot link the banner to a url through the editor - it gives me an "error on page" and will not save it properly. Can I just wrap an ahref tag with the hompage_url field to direct it?

Thanks again Dave!

The service level here has been absolutely incredible! Canadian Companies ROCK!!!

Thanks for the praise! :)

Yes, you should be able to wrap an href around it and have it work. Give it a try.

And if you want us to hunt down what was going wrong with the other method we can do that too.