Ok, I have decided to start programming a Banner Exchange Script from scratch even know my PHP Knowledge is very limited and I am very new to it. Below is my Processing Script which is supposed to 1st, Check to make sure that the Sign-up form feilds have all been filled and Second to Update the MySQL database assuming that thats true. I know I am missing something involving the MySQL database but not sure what. And not sure if I should have the part where it updates the MySQL database seperate. Well here is what I have so Far.

<?php

$errors=0
if (!trim($USERNAME))
{
echo "<BR><BR>Username</B> is required.";
$errors++;
}

if (!trim($PASSWORD))
{
echo "<BR><BR>Password</B> is required.";
$errors++;
}

if (!trim($SITENAME))
{
echo "<BR><BR>Sitename</B> is required.";
$errors++;
}

if (!trim($BANNERLOCATION))
{
echo "<BR><BR>Banner URL</B> is required.";
$errors++;
}

if ($errors > 0)
echo "<BR><BR><BR>Please user your browser's back button " .
"to return to the forum, correct ";
if ($errors == 1)
echo "the error, ";
if ($errors > 1)
echo "the errors, ";
if ($errors > 0)
echo "and re-submit the form.";

$db = mysql_connect ("localhost", "darkfire001_darkfire00l", "darkfire001")
if (!$db)
die("Failed to open Database");
mysql_select_db(darkfire_darkfire001)
INSERT INTO usernames (username, password, sitename, bannerlocation) VALUES ($USERNAME, $PASSWORD, $SITENAME, $BANNERLOCATION);

mysql_close();
?>

Any and all help is appreciated.

your probably better editing the above post so that your password etc arent shown - better playing it safe

Fronz, I did, LOL why do you think everything says darkfire001?

INSERT INTO usernames (username, password, sitename, bannerlocation) VALUES ($USERNAME, $PASSWORD, $SITENAME, $BANNERLOCATION);

what you do is simoethlng iiek

$string = "INSERT INTO usernames (username, password, sitename, bannerlocation) VALUES ($USERNAME, $PASSWORD, $SITENAME, $BANNERLOCATION)";

and then mysql_query($string);

also ... i sugest you read up on indenting

ANd lastly ... mysql.com has Kevin's tutorials on how to writ ea relational database driver website ... WELL worth a read if you are just entering MySQL

Originally posted by Darkfire001
Fronz, I did, LOL why do you think everything says darkfire001?

man i must have been taking the stupid pills that day - lol