need help

[aggiy2k]

i am trying to creat table in database test-1 but it gives error " cannot create table " can you tell me where i went wrong

<?
$test="test-1";

mysql_connect("$locahost") or die ("error");
mysql_select_db($test) or die ("error in dv");

$sql=("create table test (
id int(4),
name char(10),
)");

$query="select * from test";

$result=mysql_query($query);

if ($result)
{
echo ("table created ");
}
else
{
echo (" cannot create table");
}
?>

[kevinsequeira]

<?
mysql_connect("$locahost") or die ("error");
mysql_select_db($test) or die ("error in dv");

$sql="create table test (id int(4), name char(10))";
$query = mysql_query($sql);
EDIT :
if(mysql_error()){
echo "table not created");
}else{
echo "table created";
}

?>
reg
kevin

[aggiy2k]

kevin,

I tried this also it goes second condition i.e table not created.

[kevinsequeira]

my mistake , reverse the statements in the if condition 😃

if(mysql_error()){
echo "table not created";
echo mysql_error();
}else{
echo "table created";
}

u probably have a table called test already, else u can see what mysql_error() outputs

reg
kevin

[aggiy2k]

Thx kevin,

Need one more help i just tried this one

<?php

$password=$POST['password'];
$retype=$POST['retype'];

if ($password==$retype)
{

mysql_connect("$localhost") or die ("could not connect ");
mysql_select_db("userdata") or die ("could not select Db");

$user=$POST['username'];
$password=$POST['password'];
$name=$POST['name'];
$lname=$POST['lname'];
$email=$POST['email'];
$country=$POST['country'];

$sql="INSERT INTO register SET
(
username='$user',
password='$password',
name='$name',
lname='$lname',
email='$email',
country='$country'
)";

$query=mysql_query($sql);

if ($query)

{
echo ("you have been registered");
}
else
{
echo (" one of you filed is incorrect");
require 'register.inc';
}
}

else
{
echo ("error one of you field is empty");
require 'register.inc';
}

?>

everything is coorect when i insert datas in my form and submit it goes to else statement ( one of your field is in correct ) can you help me why it does not enter datas