|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| ||||||||||||||||||||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Best way to do this...
Ok, I'm getting the hang of PHP and I am creating a page that will access a DB in order to search the site.
Now what would be the best way to store the information in the DB? The following is one way I thought of doing it: Code:
CREATE DATABASE Product Line CREATE TABLE Adhesive Application (Adhesive Application Conveyor VARCHAR(25); Then in that table I would insert my text for that particular product. The text for different pages varys from a couple lines to a few paragraphs. Would it be wise to do it like that, or better to use a .txt file for each product to read from? The search will function like any other search. It will look through all tables for a match to keywords or similar keywords and then display the links to the pages it finds. Thanks in advance, The Squirrel |
|
#2
|
|||
|
|||
|
RE: Best way to do this...
Quote:
OK, So if in fact you could convert the squirrel in to pure energy and we know that E is energy amd M is mass and C is 3x10^8m/s or the speed of light. The amount of energy in any givin mass would equal the amount of mass times the speed of light squared. This would make Mass and Energy the same thing correct? So you would have to change your formula to this below So 1 Kg like you said is... E = mc2 = 1kg(3x10^8m/s)2 So a 10 Kg would be equal to 200 Megaton's or 400,000 Lbs of TNT. But a 22.046 Lb Squirrel is a huge Squirrel don't you think. This means that Einstein's relationship between matter and energy, 200 megaton's of energy would be released if about 10 Kilograms of matter was completely converted into energy. I think ?????? I m just rambling. Physics was never a strong point for me. Sorry, I could not resist Don't mind me, I'm just a cow. |
|
#3
|
|||
|
|||
|
RE: RE: Best way to do this...
Quote:
Sounds good to me. I don't know any physics pretty much, or at least what I did know I forgot by now. I just copied and pasted the quote and assumed the original author knew what he/she was talking about. The Squirrel |
|
#4
|
|||
|
|||
|
RE: RE: RE: Best way to do this...
While I have this open... I looked around but can't find an answer to this that has been discussed already.
Is it possible to transfer a database from one computer to another? I am designing our webpage and everything here at my workstation, and then when I am done I plan on just transferring files into new folder for the new site. Is it possible to do my database here as well? Or would I have to design and build that on the server itself? Thanks, The Squirrel |
|
#5
|
|||
|
|||
|
RE: Best way to do this...
I would have a different field for each one. You can't beat the speed of a sql database as to searching a txt file
|
|
#6
|
|||
|
|||
|
RE: Grant user
I'm back.
In MySQL I'm trying to create some users that I will be using for access to the database when someone visits the site and uses the search function but I cannot get it to work. Here is what I insert into MySQL: Code:
grant all on * to admin identified by 'my_password' with grant option; when I execute that command here is what I get: Code:
ERROR 1044: Access denied for user: '@localhost' to database 'engineering' I've searched the forum for similar problems and came across a couple, but the solutions to their problems didn't help any. As always, I thank you in advance for any help. The Squirrel |
![]() |
| Viewing: Codewalkers Forums > Other Technologies > Database Help > Best way to do this... |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|