Hi people
I am designing the website for Nanyang Technological University's Model United Nations Programme and I have a small problem in front of me.

We have to create an online registration system wherin a team could submit their particulars . I want it to be added to a database so that it could be conveniently converted to an excel spreadsheet quickly and without much labour. Can anyone please offer good solutions to this problem

Thanks in advance
Sparsh

How about PHP and MySQL?

To capture the data, a simple HTML form would work. Something like this:

<form method="post" action="savedata.php">
First Particular:<input type="text" name="particular1">
Second Particular:<input type="text" name="particular2">
<input type="submit" name="submitbutton" value="Submit Particulars">
</form>

To save the data to a MySQL table, make a page called savedata.php that looks something like this:

<?
   mysql_connect("db_host","db_user","db_pass")); 
   mysql_select_db("db_name");
   sql = "insert into table_name (particular1, particular2) values ('".$_POST["particular1"]."','".$_POST["particular2"]."')";
   mysql_query($sql);
?>

To export the data to Excel, you can use the following: PHP Help: Exporting MySQL To Excel

Thanks a lot dude... you really made my day... wont forget to thank you on the website if this works out...

just one more thing.. in addition to adding the data to the mysql can the form also send a copy of the submission to some email address...

Naturally.

<?
   mail("youremail@yourdomain.com", "The Subject", "The Body");
?>

I am using the page http://ntudebsoc.org/Registration.html

and the php code of savedata.php is

<?php
include 'config.php';

$team=$_POST['Team'];
$email=$_POST['Email'];
$p1=$_POST['P1'];
$p2=$_POST['P2'];
$contact=$_POST['Contact'];

$query = ("INSERT INTO `ntu_deb_society` VALUES ('$name','$email','$p1','$p2','$contact',)");
mysql_query($query) or die('Error, insert query failed');

$query = "FLUSH PRIVILEGES";
mysql_query($query) or die('Error, insert query failed');

?>

Everytime i am getting the error Error, insert query failed

You probably need to get rid of the comma after '$contact'

And possibly you need to put the field names in the sql query:

$query = ("INSERT INTO `ntu_deb_society` (fieldname1,fieldname2,fieldname3,fieldname4,fieldname5) VALUES ('$name','$email','$p1','$p2','$contact')");

same error again

here is the corrected code

<?php
include 'config.php';

$team=$_POST['Team'];
$email=$_POST['Email'];
$p1=$_POST['P1'];
$p2=$_POST['P2'];
$contact=$_POST['Contact'];
$query = ("INSERT INTO `ntu_deb_society` (Team,Email,P1,P2,Contact) VALUES ('$team','$email','$p1','$p2','$contact')");
mysql_query($query) or die('Error, insert query failed');

$query = "FLUSH PRIVILEGES";
mysql_query($query) or die('Error, insert query failed');

?>

You don't necessarily need the parentheses () around the string when you assign $query.

failed again..
code is

<?php
include 'config.php';

$team=$_POST['Team'];
$email=$_POST['Email'];
$p1=$_POST['P1'];
$p2=$_POST['P2'];
$contact=$_POST['Contact'];
$query = "INSERT INTO `ntu_deb_society` (Team,Email,P1,P2,Contact) VALUES ('$team','$email','$p1','$p2','$contact')";
mysql_query($query) or die('Error, insert query failed');

$query = "FLUSH PRIVILEGES";
mysql_query($query) or die('Error, insert query failed');

?>

oh .. i was mentioning the name of the table wrong... dumb error

the final code

<?php
include 'config.php';

$team=$_POST['Team'];
$email=$_POST['Email'];
$p1=$_POST['P1'];
$p2=$_POST['P2'];
$contact=$_POST['Contact'];
$query = "INSERT INTO `Team Name` (Team,Email,P1,P2,Contact) VALUES ('$team','$email','$p1','$p2',$contact)";
mysql_query($query) or die($query);

?>

and ya the Flush Privileges was giving an error so i removed it.. works fine

Special thanks to the coupon guy for all his valuable help