Noob Question, Can this be done?

[softz]

Hey everyone, well this is my first post here so hello to everyone.
Well im pretty much a noob to Databases and as my Background is mostly in GFX, i was wondering if this is possible.

I want to make a database for a web game i play Battrick. The database will hold all players skills etc etc. But what i want to know is if its possible for me to be able to take text sections from a text field and add them into a Database like so.

The user will paste this something like this into a text field, Just it will be alot longer:

<td class="skillName">Bowling:</td>
			
				<td><a href="javascript:showLevels(12, 1);" class='norm'>remarkable</a></td>
<td class="skillName">Consistency:</td>
			
				<td><a href="javascript:showLevels(13, 1);" class='norm'>wonderful</a></td>

Is it possible to do it so that remarkable is added into the Bowling Table and Wonderful is added to the Consistency Table??

Thanks for any help and letting me know if this is possible
Thank you

[Dan Grossman]

Yes, but you have to write the code to make it work like that.

Forum posts, blog comments, YouTube video descriptions... these are all user-inputted text being stored in a database.

[softz]

Thanks for the reply.

So say if some one added this line of text into a text box:

Stu Broomes (2297293)

Stu is a RH Batsman and RH Spin Bowler. He is a cautious player with feeble leadership skills and woeful experience.

He currently has proficient batting form, competent bowling form and energetic fitness.
Plays For: 	Palmerston Nth City
Nationality: 	New Zealand
Age: 	20 Years Old
Battrick Rating: 	116,747
Wages: 	£41,119 p/w
Stamina: 	superb 	Wicket Keeping: 	superb
Batting: 	wonderful 	Concentration: 	sensational
Bowling: 	wonderful 	Consistency: 	wonderful
Fielding: 	proficient 	

I can write some code to extract parts of it and put into different feilds.
Say i want to put wonderful into the Batting field?

Any chance you can point to some tutorials or anything to read over?

Thanks heaps for your help

[Dan Grossman]

Look up "regular expressions". You would write a pattern (expression) that matches the text and captures the portion you want to extract ("wonderful" after "Batting:").

Exactly how you do that depends on what language you're going to write your program in.

Once you've extracted the text, you construct the database queries to insert it in the database.

[softz]

Awesome, ill start some research on expressions now

and im going to use php and MYSQL

thanks for the help and pointin me in a direction to start with

[Dan Grossman]

http://php.net/manual/en/function.preg-match.php

[frih]

Ty php,net and other sites too, they offer good tutorial. Since you are a noob, so it will be slightly hard for you to understand, but they are really powerful function.