|
SELECT statement
Hey guys I have been working on getting my selct statement to work for some time now and just can not get it to work I did manage to get it to stop returning errors but now it returns a blank page, so i went in to my DBMS and opend up the table double checked that i have every thing spelled the same as it is in there. I would be greatful if you could look at the code for me.
Quote:
<?
$host="localhost";
$username="----------";
$password="*******";
$db_name="kelvoron_testscripts";
$table_name="test1";
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
$sql="SELECT name FROM $tabLE_name WHERE gender='male'";
$result=mysql_query($sql);
echo($result);
mysql_close();
?>
|
__________________
Good better best, never let it rest, untill your good is better and your better is the best.
|