Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

The Database Forum


You are currently viewing our The Database Forum as a guest. Please register to participate.
Login



Reply
Recycling an old database for a new site... more of a "display" question
Old 11-22-2009, 06:51 PM Recycling an old database for a new site... more of a "display" question
Novice Talker

Posts: 10
Trades: 0
I'm pretty new at this but I've been reading up on it this week. Basically I have a large database from a CMS I used to have. I don't want to use the CMS any more, but the MySQL file is full of lots of information that would take me many, many months to re-enter.

I haven't deleted the database, I can view it all in phpmyadmin and I know how to set up a new database and then copy all of that info over to the new domain/server I am setting up. So I guess you can say the database is done and I just need to display it now. What I can't work out is how I'm going to display the database information - so it is visible on the page. It seems I still need some sort of CMS or a different type of interface to handle the info. The problem is, since the database was written for a different CMS, I would probably have to convert it if I used one of the bigger content management systems, right?

I have an extremely basic need for the database info. I just want display it as a list. I've created pages for each title in the database, now I want to create a page that lists them that I can use to link to those pages. I had previously tried setting a plain HTML list up over numerous pages and adding new titles manually, but with no way to automatically alphabetize the list it was very time consuming to reorganize.(since the list is only 20 per page)

A little about the database:
I have a few thousand titles and I'm always adding more so primarily I just wanted to display these titles split over numerous pages, displayed alphabetically and by category. My previous CMS handled that, so I am guessing I need an alternative that can do something similar. I assume that's a pretty basic function, and doesn't really need the full power of most advanced programs.
ImgVerification is offline
Reply With Quote
View Public Profile
 
 
Register now for full access!
Old 11-23-2009, 03:03 AM Re: Recycling an old database for a new site... more of a "display" question
chrishirst's Avatar
Missing! presumed drunk.

Posts: 41,517
Name: Chris Hirst
Location: Blackpool. UK
Trades: 0
It is going to require some code to read the tables and output the data as HTML.
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
A foolish consistency is the hobgoblin of little minds
Thought for today:- I SEO the only industry where all the cowboys are Indians?
chrishirst is online now
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 11-23-2009, 03:40 PM Re: Recycling an old database for a new site... more of a "display" question
Defies a Status

Posts: 1,605
Trades: 0
You will need to clean up (drop) all the tables that are no longer used and write the code to pull the data you want. It just takes time and PHP knowledge.
__________________
Colbyt

Please login or register to view this content. Registration is FREE
colbyt is offline
Reply With Quote
View Public Profile
 
Old 11-23-2009, 07:33 PM Re: Recycling an old database for a new site... more of a "display" question
Novice Talker

Posts: 10
Trades: 0
Thank you both for your replies.
ImgVerification is offline
Reply With Quote
View Public Profile
 
Reply     « Reply to Recycling an old database for a new site... more of a "display" question
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.43607 seconds with 12 queries