/    Sign up×
Community /Pin to ProfileBookmark

PHP and MySQL N00b question?

Alright so basically here’s the premise. I’ve got a program that will index several movie titles and store basic information about those movies in a database. Right now the web interface lets you enter the information you need to enter and then does a MySql query to sort and print the information.
But I want to do more!
Basically, the first hurdle I have to get over is a way to edit the information in the table once it’s there. True, I could edit the information from the MySQL command-line, but the idea is to avoid that since other users will be using this interface. My idea is to have the user enter information through the HTML form as per the norm, then perform the query and display the query information in a basic HTML table but to have the last table be a button that says “edit” and allows an update/alter on the table row.
I also want to make each movie Title a hypertext link that will link to a table containing long descriptions (but that’s a ways off).
Anyone got suggestions? Or point me in the direction of a nice tutorial to perform this action?

to post a comment

2 Comments(s)

Copy linkTweet thisAlerts:
@SpectreReturnsOct 05.2005 — *[url=http://www.google.ca/search?q=mysql+tutorial]sigh[/url]*
Copy linkTweet thisAlerts:
@bambolinOct 05.2005 — www.snippetcollection.com/language/sql will help you out. There are plenty of small examples that help you understand what you can do :-) If you have any questions ask:-)


Help @TheAnonymousX spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 BETA 4.13,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ

legal: ({
terms: of use,
privacy: policy
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
recent_tips: (
tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,

tipper: @Samric24,
tipped: article
amount: 1000 SATS,