https://interactivetools.com/forum/forum-search.php?k=user%3Aethan76 Mon, 04 May 2026 15:42:41 -0700 en-us https://interactivetools.com/forum/forum-posts.php?postNum=2191973#post2191973
Haven't quite been able to test this all yet - in fact since swapping the site from my test server to 'live' I've had to go back a few steps.

Now when I add the php header code - produced from the code creator as before - I get this error ;

getRecords(newin) MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 4

It doesn't seem to like 'limit'? Which is strange as another page with news lsitings (limit='5') works fine..

any ideas would be much appreciated.

Thanks!

E
]]> Fri, 13 Jun 2008 23:50:08 -0700 forum-posts.php?postNum=2191973#post2191973 https://interactivetools.com/forum/forum-posts.php?postNum=2191898#post2191898
So problem solved!
]]> Mon, 09 Jun 2008 00:34:46 -0700 forum-posts.php?postNum=2191898#post2191898 https://interactivetools.com/forum/forum-posts.php?postNum=2191897#post2191897
I've run into some problems when making my site 'live'. Everything works fine except viewing uploads. Now that I've changed the domain the site is looking for the images through an extra folder level ie;

CMS originally pathed at; hostinghome/siteroot/cmsAdmin/uploads/

Now I've made the site live it's; siteroot/cmsAdmin/uploads/

I found that CMS was looking for the images with an extra 'siteroot' directory ie; siteroot/siteroot/cmsAdmin/uploads.

Ok, so I followed the advice on several posts here and created a new folder tree for the uploads in that place. so I now have my uploads in;

siteroot/siteroot/cmsAdmin/uploads.

This works fine but (finally to the problem!) in CMS I can no longer see the upload thumbnails. They still point to the old, original folder, and I can't find a way to change that.

Any ideas how I can update the thumbnail path, or otherwise solve this?

Big thanks,

Ethan
]]> Sun, 08 Jun 2008 23:17:16 -0700 forum-posts.php?postNum=2191897#post2191897 https://interactivetools.com/forum/forum-posts.php?postNum=2191896#post2191896
I'll go and try it out now!

Ethan
]]> Sun, 08 Jun 2008 22:15:37 -0700 forum-posts.php?postNum=2191896#post2191896 https://interactivetools.com/forum/forum-posts.php?postNum=2191885#post2191885
I'm having the exact same problem - any chance of putting your solution on the forum? I've been scratching my head for a few hours now!

Thanks

Ethan
]]> Sun, 08 Jun 2008 01:31:34 -0700 forum-posts.php?postNum=2191885#post2191885 https://interactivetools.com/forum/forum-posts.php?postNum=2191874#post2191874
Yep, got that working fine on the homepage, so I now have three listings appearing which show the selected records from the pulldowns, like so;

Cars: 4
Motorbikes: 2
Quad Bikes: 4

So, the final step - how do I turn this info into showing the full listing on the page?

And, to confirm, yes I only want to show one listing - the first one selected from all three.

Thanks for your help again - nearly there!

Ethan
]]> Thu, 05 Jun 2008 21:51:24 -0700 forum-posts.php?postNum=2191874#post2191874 https://interactivetools.com/forum/forum-posts.php?postNum=2191849#post2191849
I've got the new section working with 3 pull-down lists of products. So now it's the next step you mentioned; getting those into the page!

One question - there will only be one 'Special this week' area on the homepage - which should show ONE record from all three pull downs. I'm guessing this will require an "if record = x, then display. Or else next record" type thing.

Thanks so much

Ethan
]]> Wed, 04 Jun 2008 22:24:11 -0700 forum-posts.php?postNum=2191849#post2191849 https://interactivetools.com/forum/forum-posts.php?postNum=2191835#post2191835
I've integrated everything in my site to CMS and it's looking great. There's one feature I'd like to implement though and I don't know if it's possible, so any help or pointers would be great!

I have 3 product pages, each with their own related table. Now I would like to display one - selected - record (a 'Special this week' type thing) from all of these tables on the home page. The user needs to select this record in the admin section.

My first thought was using a 'featured' check box in every record and somehow displaying the selected one, but ;

a. Is it possible to get records from more than one table at the same time?

b. Using the 'featured' checkbox is a bit problematic as the user will have to manually make sure only one record, out of three separate tables is 'checked'.

My ideal solution would be a pull down menu which pulls in all names from all the tables - allowing the user to select one record, then displaying this on the homepage?

Where to start!!?

Thanks for your time,
Ethan
]]> Tue, 03 Jun 2008 22:03:03 -0700 forum-posts.php?postNum=2191835#post2191835 https://interactivetools.com/forum/forum-posts.php?postNum=2191825#post2191825
That worked a treat!

CMS builder is genius - it's cured a headache I've had for about 3 years...

Thanks

Ethan
]]> Tue, 03 Jun 2008 12:02:27 -0700 forum-posts.php?postNum=2191825#post2191825 https://interactivetools.com/forum/forum-posts.php?postNum=2191822#post2191822
I'm just getting into CMS builder and can already say I think it's great!

There's one thing I'd like to do and can't yet find a work-around though.

I want to have the user select one of three options in a pull down menu, and then on the live page for this to appear as an image, rather than type.

So, I have three options;

Road Legal
Off road
Kid's Quads

Can I alter the code on the page so that - depending on what's chosen - an image changes?

Probably a real noob queston - any help very appreciated!

Thanks, Ethan]]> Tue, 03 Jun 2008 08:36:14 -0700 forum-posts.php?postNum=2191822#post2191822