How should i do this?

Anon

Hello

I would like to create a form with two text boxes Country and currency.when i enter some data and hit the submit button, the data should be stored in my table.How can i implement this?
My database is Interbase.

Herez how i proceeded so far.

html>

<head>
<title>My Form</title>
</head>
<body>
<?php
$username = "SYSDBA";
$password = "masterkey";
$connection = @ibase_connect('localhost:C:\Programmefiles\examples\Database\employee.gdb', $username, $password);
if (!$connection)
{
exit ("Unable to connect to database: $connection");
}
$db = 'insert into COUNTRY(COUNTRY, CURRENCY) values ( );
$bsc = ibase_query($connection, $db);

Country
<br> <input type="text" country="Yourcountry">
<p> Currency
<br> <input type="text" currency="Yourcurrency">
<p>
<input type="submit" name="submit" value="Enter the Data!">
</form>
</body>

Could some body please help me with the above code.

Thanking you in advance.

stuartc1

Try updating the line that looks like this:
$db = 'insert into COUNTRY(COUNTRY, CURRENCY) values ( );

to include the form values like this:
$db = "insert into COUNTRY(COUNTRY, CURRENCY) values ('$Yourcountry', '$Yourcurrency' )";

Anon

Hello

could somebody tell why this SQL error is occuring in this program??

<?php
//Check for the submit button
if (isset($submit)){
$username = "SYSDBA";
$password = "masterkey";
$connection = @ibase_connect('localhost:C:\Programmefiles\examples\Database\employee.gdb', $username, $password);
if (!$connection)
{
exit ("Unable to connect to database: $connection");
}
$db = 'insert into COUNTRY (COUNTRY, CURRENCY) values ($Yourcountry, $Yourcurrency)';
$bsc = ibase_query($connection, $db);
echo "Data added";
} else {
?>

<head>
<title>My Form</title>
</head>
<body>
<form name="myform" action="<? print $PHP_SELF; ?>">
Country
<br> <input type="text" country="Yourcountry">
<p> Currency
<br> <input type="text" currency="Yourcurrency">
<p>
<input type="submit" name="submit" value="Enter the Data!">
</form>
</body>

<?
}

Thank you