[Resolved] Submit SQL query with button

[cchhita]

Hi Everyone,
I am very new to PHP, and wanted a little help with radio buttons and SQL.

I have found a script that will allow me to type in a SQL query in a text box and execute this on a button click. The result is returned in a table in HTML.
I would like to now make it user friendly for my client. I.e. so they do not see any SQL code displayed or have to write any themselves.

What I would like is a set of radio button that contain predefined SQL statements for them to click on and hit submit to return a result.

An example is if they would like to see a sales report of all activity on the site ordered by date, they can click on the 'Sales Report' radio button and hit the submit button to view the report.

Can someone point me in the right direction here???

Thanks

[olaf]

I don't think that this kind of tasks can be scripted by yourself, it's very complex for a beginner.

try this link and test some this projects:

http://www.hotscripts.com/PHP/Scripts_and_Programs/Database_Tools/index.html

[cchhita]

Thanks for that!
I have had a look here. I think I have found what I need.
Will keep working on it.

Cheers