Topic: [SOLVED] Connecting And Inserting Into Database

[phprocker]

Hey all.  I'm trying to create my own "Contact US" form in a module on the main page of a Joomla site.  The problem is that I can't seem to get the data inserted into the database.  I have the form action "POST" to a page called dbc.php and then it gets redirected back to the main page.  Here is the basics of the dbc.php page.

Code: [Select]

<?php

if (isset($_POST['Submit'])){

if(!$dbc = @mysql_connect('localhost', 'username', 'password'))
{
die ('<p>Could not connect to the database because: <b>' . mysql_error() . '</b></p>');
}



@mysql_select_db('database');


// insert
$sqlquery = "INSERT INTO contact (id, time_date, first, last, phone, email)  VALUES (0, NOW(), '$_POST[first]', '$_POST[last]', '$_POST[phone]', '$_POST[email]')";

@mysql_query($sqlquery);

mysql_close();
}
header(Location: index.php);
exit();

?>
Can someone point me in the right direction on how to do this?

[phprocker]

Nevermind I got it working.  I had a few errors in the script and a big mistake my form was missing the "name" for the submit button.