Pretty Basic Question

[Purcelly]

So I'm new to the whole MySQL and have a basic question.

I have a config file that contains the database, user and password info. This is required on all pages to connect to the database.

 

Within my 'users' table there is an 'alert' field. When I input data into this for a set user they recieve the alert.

At the moment to do this I have to go into PHPmyAdmin and manually add the message into the alerts field.

 

I'm hoping to have a page on the site where there is a drop down menu that slects the users names from the users table and then an input box to type the alert and once you press send/submit it enters the database.

 

Does anyone have any way I can do this. I've tried a few things but they've failed.

 

[F1Fan]

That's more than a pretty basic question. You need a page with the select inputs that posts the data to then update the DB table.

 

It would be easier to help you if you list the code that didn't work, rather than asking for someone to write it for you. Plus, you'll learn more.

[GregL83]

Agreed.

 

You need to create a dynamic form of users (rows) with the drop down option for each row.  After, code to process the form that determines what to update in the database.