| | |
Database Question From Newbie
Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
•
•
Join Date: Feb 2005
Posts: 427
Reputation:
Solved Threads: 12
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?
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?
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.)
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.)
![]() |
Similar Threads
- Database normalization/redundancy question (PHP)
- Quick database question (PHP)
- Java Application +Database Question (Java)
- very newbie (mysql) question (MySQL)
- database question (C#)
Other Threads in the MySQL Forum
- Previous Thread: MySQL Functions W/ Offline Languages
- Next Thread: Please school me in PHP script installation.
| Thread Tools | Search this Thread |
agplv3 alfresco amazon api artisticlicense aws bizspark breathalyzer camparingtocolumns changingprices cmg communityjournalism contentmanagement contractors copyright count court crm data database design developer development distinct drupal dui ec2 email enter enterprise eudora facebook form foss gartner gnu government gpl greenit groklaw groupware hiring hyperic images innerjoins insert ip joebrockmeier join journalism keyword keywords kickfire laptop law legal license licensing linux maintenance managing mariadb metron micromanage microsoft microsoftexchange mindtouch montywidenius mozilla music mysql mysqlcolumnupdating mysqldatetimeordermax() mysqlindex mysqlinternalqueries mysqlquery mysqlsearch news open-xchange opendatabasealliance opensource oracle php priceupdating query referencedesign reorderingcolumns resultset saas select sharepoint simpledb sourcecode spotify sql sugarcrm syntax techsupport thunderbird transparency





