PDA

View Full Version : Creating a newsbox controlled by php/mysql



minimalistik
May 6th, 2006, 12:08 AM
I have always been interested in knowing/learning a bit about using php/mysql. I have been developing my personal website that includes a simple newsarea. This is within its own div and uses an external html page.

However, I would like to make it better; to easily update the news content with php/sql.

What will this require and will it be hard to setup?

Ben Smith
May 6th, 2006, 05:38 AM
I could do this for you. It's pretty simple, and I'd comment the code so you would know how to do something like it in the future.
Sound good?
If you want me to, email me at ben.e.smith@gmail.com

bwh2
May 6th, 2006, 05:13 PM
to pull data from db:
1) mysql SELECT statement into php variable
2) echo php variable

to insert into db:
1) html form -> php -> mysql INSERT statement

minimalistik
May 6th, 2006, 10:44 PM
I've emailed you Ben; bwh2, thanks for the brief info.

bwh2
May 6th, 2006, 10:49 PM
no problem. definitely post here if you guys need some help. it should be straight forward, but there are always spots to trip you up.

minimalistik
May 6th, 2006, 11:06 PM
I have worked with Microsoft Access so I knew what you were trying to say. I think it is quite similiar but I'll wait until I can get working on it.

bwh2
May 6th, 2006, 11:15 PM
well, it will be similar to the extent that you understand relational database structure. if you've written queries in access, they will look similar to, but not exactly like mysql queries.