[insert_php]
/* Data of SQL-server */
$server= “mysql.innerchildcrochet.com”; /* Address of 1&1 database server*/
$user= “melissacarolyn”; /* Database username */
$password= “Karaei1!12”; /* Database Password */
$database= “lpohworksheets”; /* name of database */
$table= “Worksheets”; /* Name of table, you can select that*/
/* Accessing SQL-server */
MYSQL_CONNECT($server, $user, $password) or die ( “
Server unreachable
“);MYSQL_SELECT_DB($database) or die ( “
Database non existent
“);$pick = “‘addition'”;
$query = “SELECT * FROM Worksheets WHERE subject =”.$pick;
$query = $query.”order by Title”;
$result=MYSQL_QUERY( $query );
echo $row[1].$row[2];
/* Output data into a HTMl table */
while ($row = mysql_fetch_row($result))
echo ““.$row[1].” “;
/* Close SQL-connection */
MYSQL_CLOSE();
[/insert_php]