How to find record ...

Anon

I have a MySQL database. The db contains peoples names and adresses, in addition to other information. Two of the field names are LastName and FirstName. I want to be able to find a record in the database which has fields matching values that I specify. For example, I want find the record for which LastName is "Smith" and FirstName is "John". I have tried the following query, but I am getting an error

SELECT * FROM $tablename WHERE LastName="Smith" AND FirstName="John".

Can anyone suggest, or provide, a short tutorial on how to
1) connect to mysql (to make sure I am doing this correctly)
2) specify the db
3) perform query such as one mentioned above.

Thanks,
Ed

[deleted]

I wrote something of an FAQ just for the newbies :-)

http://www.xs4all.nl/~vinny/index.html#4

Anon

<?
connect to server
$conn= mysql_connect("localhost",user,password);
If(!$conn)
{
print("Unable to connect to the".
"Database Server.</p>");
exit();
}
else
{ print("connected");}

$result= mysql_query("CREATE DATABASE something");
IF(!$result)
{
print("Couldn't create a database.");
exit();
}
else
{
print("Database created");
}
$selectdb=mysql_select_db(something);
if(!$selectdb)
{
print("<p>Unable to locate $db</p>");
exit();
}

		$query = "create table board (" .
		         "ID Int Not Null Auto_Increment Primary Key,".
		          "name VarChar(25),".
		          "AddF VarChar(40),".
		          "send VarChar(25),".
		          "AddT VarChar(40),".
		           "Message Text,".
		            "Email  VarChar(40),".
		           "Ph_no  VarChar(10),".
		           "Date   Date Not Null".
		      ")";

		 if(mysql_query($query))
		      {
			   print(" table Created");
			     }
				else
				   {
				    print("Error Creating table");
					}





?>