Php Queries

Anon

I would like to setup a set of scripts that does several queries on my database.
The question I am having is how to connect to the database and then when the user enters a value in a form how do I query the mySQL database and print out the results.

For example:
Form question “What is the average age of the subscriber subscribing”
“Age Query: How many people in the database are ____ years old” – User fills in value

I would then like the script to return the results.
How do I do this? Thanks

James

Anon

Have the user enter the value into a form, then on the submitted page run your query and display the results.

Anon

Well, firstly....

Read php manual on various database functions. You didn't specify what database you are using... I'll assume you are using MySQL...

This is the code

<?
if($enter)
{
$tablename="your table in the database";
//connecting to database
$conn=mysql_connect(host, user, password);
//selecting database
$db=mysql_select_db("databasename", $conn);
//actual query
$sql="select age from $tablename where age<$age";
$result=mysql_query($sql, $conn);
if($result)
{
echo "<script>window.alert(\"Query executed\")</script>";
}
}
$html_block="

   <body>
   <form method=post action=$PHP_SELF>
   <input type=text name=age>
   <br>
   <br>
   <input type=submit name=enter value=Search>
   </form>
   </body>
   ";

echo "$html_block";
?>

Code of course can be modified in your $sql variable you can change sign from < to > or to =< or whatever you want. Your form variable you can adjust as well to reflect what kind of query you are doing...

Good luck,