Using HTML to generate variables for PHP

[idnoble]

Hello

I'm trying to use a set HTML links on my website to query a database using PHP, writing the php script is not a problem but generating variables through the HTML link is beyond me, i don't want to create different scripts for the links instead i want them to share just one script.

Has anyone got any idea of how to do this?

Thank you

[devinemke]

not exactly sure what yop mean. you want to create links to query a database. so just pass the relavent data on the query string:

<a href="query.php?table=users&field=email&value=[e-mail]">query</a>

then in query.php:

$result = mysql_query ("SELECT * FROM " . $_GET['table'] . " WHERE " . $_GET['field'] . " = '" . $_GET['value'] . "'");

this would query the users table and pull all fields for the email [e-mail]