 | MySQL Databases |  |
 Posted: 05/02/2007 3:28 PM |
 |
|
|
|
|
| Citation |
| Posts |
407 |
| Word Cnt. |
10,993 |
| BDay |
May 28 |
| Sign |
Gemini |
| Sex |
 |
|
|
|
Joined: Feb 25, 2007
Local time: 11:51 PM
Location: SE England
|
|
|
|
|
 |
Hey NR.
Sorry I can't help out right now, but I do need your expert help 
Here's what I want to do:
Create a database with the tables: Name, Comments.
Create a form for a website that will inject those 2 value into the database.
Think you can help?
Thanks,
- Poomie |
|
|
|
|
| Back to Top |
|
|
| Re: MySQL Databases | |
| Posted: 05/02/2007 3:44 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 7:51 PM
Location: St Pete, FL
|
|
|
|
|
|
Do you know what fields will be in the two tables and the types, keys, and default data should be???
 |
|
|
|
|
| Back to Top |
|
|
| Re: MySQL Databases | |
| Posted: 05/02/2007 3:46 PM |
|
|
|
|
|
| Citation |
| Posts |
407 |
| Word Cnt. |
10,993 |
| BDay |
May 28 |
| Sign |
Gemini |
| Sex |
|
|
|
|
Joined: Feb 25, 2007
Local time: 11:51 PM
Location: SE England
|
|
|
|
|
|
Well not really - I haven't thought about any of that.
- Poomie |
|
|
|
|
| Back to Top |
|
|
| Re: MySQL Databases | |
| Posted: 05/02/2007 3:57 PM |
|
|
|
|
|
| Citation |
| Posts |
407 |
| Word Cnt. |
10,993 |
| BDay |
May 28 |
| Sign |
Gemini |
| Sex |
|
|
|
|
Joined: Feb 25, 2007
Local time: 11:51 PM
Location: SE England
|
|
|
|
|
|
Well could you explain the 2 field thingys?
Oh man I'm forgetting some stuff *smacks self*
Yah, I'd just like something that can inject a name and their comments into a database from a form, and display how many entries there are on another page.
Thanks,
- Poomie |
|
|
|
|
| Back to Top |
|
|
| Re: MySQL Databases | |
| Posted: 05/03/2007 12:22 AM |
|
|
|
|
|
| Citation |
| Posts |
407 |
| Word Cnt. |
10,993 |
| BDay |
May 28 |
| Sign |
Gemini |
| Sex |
|
|
|
|
Joined: Feb 25, 2007
Local time: 11:51 PM
Location: SE England
|
|
|
|
|
|
OK, I have a value for Name and for Comments.
Something like TEXT VARCHAR (well, VARCHAR anyways).
Hope that help.
Thanks,
- Poomie |
|
|
|
|
| Back to Top |
|
|
| Re: MySQL Databases | |
| Posted: 05/03/2007 1:56 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 7:51 PM
Location: St Pete, FL
|
|
|
|
|
|
If you've already created your database, then you can run a query like this to create a table replacing new_table_name with the name that you want for the table...
| Code:
|
CREATE TABLE new_table_name (
record_id mediumint(8) NOT NULL auto_increment,
username varchar(255),
comments text
PRIMARY KEY (record_id)
);
|
The record_id would be the unique key for each record and would be automatically assigned. The username can hold up to 255 characters, and the comment field can hold as much as you want to store in the field...
 |
|
|
|
|
| Back to Top |
|
|
| Re: MySQL Databases | |
| Posted: 05/03/2007 11:32 AM |
|
|
|
|
|
| Citation |
| Posts |
407 |
| Word Cnt. |
10,993 |
| BDay |
May 28 |
| Sign |
Gemini |
| Sex |
|
|
|
|
Joined: Feb 25, 2007
Local time: 11:51 PM
Location: SE England
|
|
|
|
|
|
And what about a form to input a username into the table, and another to display how many records there are in the table?
- Poomie |
|
|
|
|
| Back to Top |
|
|
| Re: MySQL Databases | |
| Posted: 05/03/2007 2:56 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 7:51 PM
Location: St Pete, FL
|
|
|
|
|
|
Oh, you're trying to write everything from scratch? Is this going to be integrated in with your forum or is this going to run completely separate???
|
|
|
|
|
| Back to Top |
|
|
| Re: MySQL Databases | |
| Posted: 05/03/2007 11:36 PM |
|
|
|
|
|
| Citation |
| Posts |
407 |
| Word Cnt. |
10,993 |
| BDay |
May 28 |
| Sign |
Gemini |
| Sex |
|
|
|
|
Joined: Feb 25, 2007
Local time: 11:51 PM
Location: SE England
|
|
|
|
|
|
It's going to be separate.
- Poomie |
|
|
|
|
| Back to Top |
|
|
| Re: MySQL Databases | |
| Posted: 05/04/2007 4:50 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 7:51 PM
Location: St Pete, FL
|
|
|
|
|
|
If it won't be included with the forum software, then it will be necessary to write the code to connect to and access the database. I haven't had to ever do that with php, so it would take some research to recreate the database access...
|
|
|
|
|
| Back to Top |
|
|
| Information | |
Welcome to RCF - WHF Forum Index
-> Talk PC
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 vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum
|
All times are GMT - 5 Hours
Goto page: 1, 2 Next
Page 1 of 2
Add To Bookmarks
|
|
|
|
|
Calendar
