Help for a Newbie!!!

Hi all,

I'm trying to create a table in me database via a php script with mysql. When i run the .php file all i get is my error message from the mysql-query.

Here is the bit of script causing my headaches

----

$sql = "create table People (Name text, Region test, City text, Telno int)";

$result = @mysql_query($sql,$connection)
or die("Couldn't execute query.");

if ($result) {
$msg = "<P>People has been created!</p>";

----

Any ideas?

Cheers

Resis

Region test

should be

Region text

you shouldn try printing mysql_error().. it helps a lot when debugging.. ;)