List creation automation ?

  • Bingo
  • Newbie
  • Newbie
  • Bingo
  • Posts: 8

Post 3+ Months Ago

On one of my websites - How can I automate a list of vehicles within category such that someone can click on either vehicle Stock No. description, or maybe a picture in a listing format and have the click take them to a page on which the vehicle is shown?

Would that require database programming ?

Where do I begin ? I know how to do it manually, but that is too time consuming if you have to maintain this with new vehicles all the time..

Please remember that I am a newbie, guide me gently..

Thanks, Bingo
  • Anonymous
  • Bot
  • No Avatar
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post 3+ Months Ago

  • joebert
  • Fart Bubbles
  • Genius
  • User avatar
  • Posts: 13503
  • Loc: Florida

Post 3+ Months Ago

What steps do you take to do it manually right now ?
  • Bingo
  • Newbie
  • Newbie
  • Bingo
  • Posts: 8

Post 3+ Months Ago

Hi Joebert,

Well, here is where you find out how much of a newbe I am, but I will attemp to explain...

I would have to create a list with a column showing:

Category: ie Automobile, Water Craft, Motorcycles, Suvs, PickUps, etc.

Sub Catagory: (Under Automobile) ie 2 door, 4 door, convertable, etc.

Vehicle: ( Under 2door) ie Ford, Chevy, Chrysler, Toyota, etc.

Vehicle: (Under Ford) ie Fairlaine, Tempo, etc

Stock: (Under Tempo) ie 1994 silver and on same line showing
Stock Number, and possably a picture

I would have to select the line showing stock number and have it point to the page that that vehicle is on.

Thus I would have to do this for each vehicle as it is introduced to the system and remove the line when it is sold.

Is there an automated way to do this be simply placing the vehicle stock line in a data base which is pre-programed to display a listing with a link on a page?

How do I start, I have little to no experience in using a data base on a web site. Help ?


Thanks for replying, Bingo
  • joebert
  • Fart Bubbles
  • Genius
  • User avatar
  • Posts: 13503
  • Loc: Florida

Post 3+ Months Ago

I was at a Lincoln Mercury dealership for 2 years as a Detailer, I have a fairly decent understanding of inventory, I'm trying to get an idea of exactly what there is to work with right now so I don't suggest somthing from left field.

When you say you know how to do it manually, & mention automation, I'm under the impression you have a website setup already & it's just getting to be too much of a pain to maintain the way it is now.
  • Bingo
  • Newbie
  • Newbie
  • Bingo
  • Posts: 8

Post 3+ Months Ago

Thanks Joebert,

I have a website now, but it uses a menu button to drop into a further selection by category, and not a list.

Of course the client, wants a page with a list so someone can see all the vehicles at once, and click on the vehicle they want further info. on.

I can produce a list page but wanted to see what and how to create something in an automated way.

Here is the website and you can see what I have done so far.

hardyconsignment.com

Thanks for your help, Bingo
  • joebert
  • Fart Bubbles
  • Genius
  • User avatar
  • Posts: 13503
  • Loc: Florida

Post 3+ Months Ago

I see the site's using PHP & is hosted at 1and1, I'm not familiar with their control panel or setup however.
Is there anything about "phpmyadmin" or "mysql" in the control panel for the site ?
  • Bingo
  • Newbie
  • Newbie
  • Bingo
  • Posts: 8

Post 3+ Months Ago

JoeBert,

Here is what I could find:

Scripts supported: Perl, Python, PHP4, and PHP5.

MYSQL Database available ( I have up to 25 to use.) None in use now.

CGI Library
Front Page Server extensions available - Not activated at this point in time.

I will look to see where if anyplace in the control panel there is an activate for those.

Hope this helps, and thank you... Bingo

Well I just got back and There is a Perl Syntax Checker, a CGI Output Monitor, a MySQL Administration area where MySQL Database Set Up and ConfigurationI can put into play a MySQL database, that apears to be it for now...
  • joebert
  • Fart Bubbles
  • Genius
  • User avatar
  • Posts: 13503
  • Loc: Florida

Post 3+ Months Ago

Does anything on this listing look usable to you ?
  • Bingo
  • Newbie
  • Newbie
  • Bingo
  • Posts: 8

Post 3+ Months Ago

Joebert,

Thank you for finding that - Wow !

I haven't been so excited since my honeymoon.. Of course my wife tells me I am easy to please.. But I have gone through all those and they look very good.

There were two or three that seem to fit the bill exactly, but now I have to see if It would be silly to try to program it myself or maybe see if my client would want to spend some more for the ability...

I would love to learn but how long would it take me?

That is the big question...

How difficult? Bingo
  • Bingo
  • Newbie
  • Newbie
  • Bingo
  • Posts: 8

Post 3+ Months Ago

Well Joebert,

It looks like I may have to use a 4x4 (solid teak) on my client..
Doesn't understand and went so far as to go to a friend of his, who simply said that some cut and paste of my code should fix it ! Is murder still an offense?
So if I am going to get anywhere I will have to start with out the circus clown...

Can you suggest where to begin?

Thanks in advance Bingo
  • joebert
  • Fart Bubbles
  • Genius
  • User avatar
  • Posts: 13503
  • Loc: Florida

Post 3+ Months Ago

Go through with setting the stuff up on a test server & save it for later.

They'll get tired of copy & pasting sooner or later. ;)
  • Bingo
  • Newbie
  • Newbie
  • Bingo
  • Posts: 8

Post 3+ Months Ago

Thanks Joebert for your help.

Did some "southern engineering" and got them happy enough for now...

I think you did very well in spite of what must have been a temptation to tell me to get a how to book and start reading...

I did find some free scripts, have started to read a "how to" book and more then understand the amount of detail and complexity of the task now!

Hope to get on board and will be back with what I am sure will be more stupid questions... But hopefully with more understanding on my part...

I will be back !

Thanks, Bingo

Post Information

  • Total Posts in this topic: 12 posts
  • Users browsing this forum: No registered users and 83 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
cron
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.