PHP joins MySQL

<?php

• echo "This is a test</br>";
• echo "ASDFASDFADSF";
• $mysql _server_name="localhost:3306"; //Database server name
• $mysql _username="root"; //Connect database user name
• $mysql _password="Rootpass"; //Connect database password
• $mysql _database="dbname"; //Database name
• //Connect to database
• $conn =mysql_connect ($mysql _server_name, $mysql _username,
• $mysql _password);
• //SQL statement that extracts information from a table
• $strsql ="Select Val from tsys_hashtable where ' key ' = ' vmall_version '";
• //Execute SQL query
• $result =mysql_db_query ($mysql _database, $strsql, $conn);
• //Get query Results
• $row =mysql_fetch_row ($result);
• echo ' <font face= ' Verdana > ';
• echo ' <table border= ' 1 "cellpadding=" 1 "cellspacing=" 2 ">";
• //Display field name
• echo "</b><tr></b>";
• For ($i = 0; $i <mysql_num_fields ($result); $i + +)
• {
• echo ' <td bgcolor= ' #000F00 ><b> '.
• Mysql_field_name ($result, $i);
• echo "</b></td></b>";
• }
• echo "</tr></b>";
• //Navigate to the first record
• Mysql_data_seek ($result, 0);
• //Loop out record
• While ($row =mysql_fetch_row ($result))
• {
• echo "<tr></b>";
• For ($i = 0; $i <mysql_num_fields ($result); $i + +)
• {
• echo ' <td bgcolor= ' #00FF00 > ';
• echo $row [$i];
• echo ' </td> ';
• }
• echo "</tr></b>";
• }
• echo "</table></b>";
• echo "</font>";
• //Release Resources
• Mysql_free_result ($result);
• //Close connection
• Mysql_close ($conn);
• ?>

PHP joins MySQL