User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 401,979 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,637 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Views: 2166 | Replies: 2
Reply
Join Date: Sep 2004
Posts: 23
Reputation: shortd81 is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 0
shortd81 shortd81 is offline Offline
Newbie Poster

Help Database Question From Newbie

  #1  
Feb 22nd, 2005
I'm getting ready to make a database of my baseball cards and wanted to know how would I go about making a searchable database of my cards?
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Feb 2005
Posts: 427
Reputation: autocrat is on a distinguished road 
Rep Power: 4
Solved Threads: 12
autocrat autocrat is offline Offline
Posting Pro in Training

Re: Database Question From Newbie

  #2  
Feb 25th, 2005
Well, firstly, what do you have?
Not the cards.... the database!

I'm assuming you have mysql, due to the forum.....
So, are you going to make it text based, typing everything... or going to get a program to make the process a little easier, something like navcator that, (works like MS Access!)?

As for the DB itself, I assume you know what details you wish to enter...name, number, description, details etc....unique id.....then all you do is make things indexed....particularly the unique id, name and number.

Does that make any sense?
Reply With Quote  
Join Date: Nov 2003
Location: Toronto, Canada
Posts: 354
Reputation: Gary King will become famous soon enough Gary King will become famous soon enough 
Rep Power: 6
Solved Threads: 5
Colleague
Gary King's Avatar
Gary King Gary King is offline Offline
PHP/vBulletin Guru

Re: Database Question From Newbie

  #3  
Mar 1st, 2005
Searchable database eh? Well, first off you need to make the layout for your table.

Make a table, something like 'cards' and then you need to figure out which columns you'll need (you can add and remove them later.)

For instance, columns could be something like:

id (this is essential - and should be incrementing for each card, so that your program can easily find a card using their ID)
name (card name)
(other columns that are suitable)

Then later on, you can make a PHP program that searches for different values in different columns, and you can even run wildcard searches (like *est* would find test, testing, etc.)
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

DaniWeb MySQL Marketplace
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes

Similar Threads
Other Threads in the MySQL Forum

All times are GMT -4. The time now is 7:26 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC