website building help please

[Wickedest]

Ok I've asked about this once before with no reply or help from anyone I think I'm posting this in the right place

ok so I am building a website for mushroom spores selling & trading heres the link http://fstr-usa.kicks-ass.net/ hosted by dyndns & wampserver & sqlyog

ok so when you goto my website off to the right side I have this join my news letter deal with free membership & free stuff but nothing happens when you place in you email

I want to have it like a wow registration page where you just place in you email & click submit & it be place in my database in sqlyog

I just need to know how to script it so that my webpage will link to my sqlyog server can anyone help me with that I +rep what I can

[Wickedest]

if the website gos down in afew hours I gave up for now but still need the help the site is still under work & isnt gonna be up till later in the year

but is up now to view I am not tryin to scam emails & shit like that I am truly trying to make a real website & I'm no computer tech & you all write wow reg pages for sqlyog


no place left to turn please help!!!!!

[Multitask]

i think your getting a little in over your head. start out learning the basics of web design, then begin server/db scripting

[Wickedest]

i think your getting a little in over your head. start out learning the basics of web design, then begin server/db scripting

I think you hit my site off line I just need a table in my sqlyog that when you put it in it saves it to that table like an account reg page for wow & the only reason I'm asking here is this is where I learned most of it all so I am gonna leave the page up for the night

I feel like I'm some how not making this too clear to understand

[Wickedest]

please help

[Nikentic]

If you specify exactly what you need, then maybe I could help. And if it wouldn't be illegal, then I would.

[Wickedest]

ok so I almost got it & now this it keeps telling me Could not connect: Access denied for user 'wickedest'@'localhost' (using password: YES)

I put the my info into the config file I'm not understanding this I have 2 file this

<?php
$conn = mysql_connect('localhost','wickedest','*****BLa*****');
$sel_db = mysql_select_db('wickedest-spore-network');
?>

& this as my website reg page still under work once I have it working Im gonna add it to my site

<center><title>The U.S. Spore Ring</title>
<?php
// Originally by: Wickedest
// Modified by: Wickedest
// Additional Modifications: Fourth

error_reporting(E_ERROR | E_CORE_ERROR | E_COMPILE_ERROR | E_USER_ERROR);

// SQL data
$db_u = "wickedest"; // fill in ur db username
$db_p = "*****BLa*****"; // fill in ur db pass
$db_host = "localhost"; // fill in only if u're not running it on the same machine as the db.

// don't change
$u = $_POST['username'];
$p = $_POST['passwords'];
$e = $_POST['emails'];

$h = "localhost"; //server address
$p = "3306"; //default realmd port
$s = fsockopen($h, $p, $errno, $errstr, 25);

if(!$u){

// die("Registration is offline!"); // uncomment if u want to turn off reg.
echo ' <form name="form1" method="post" action="1.php">
Username:<br>
<input type="text" name="username"><br>
Password:<br>
<input type="text" name="passwords"><br>
Email:<br>
<input type="text" name="email"><br>
<input type="submit" name="Submit" value="Submit">
<input type="reset" name="Clear" value="Clear">
</form>';
}
else
{
// Some lame protection code against sql injections
if (!get_magic_quotes_gpc()) {
$u = addslashes($_POST['user']);
$pass = addslashes($_POST['pass']);
$e = $_POST['email'];
} else {
$u = $_POST['user'];
$pass = $_POST['pass'];
$e = $_POST['email'];
}

//DB SHITZ. DO NOT TOUCH !!!
$link = mysql_connect("$db_host", "$db_u", "$db_p");
if (!$link) {
die('Could not connect: ' . mysql_error());
}
$db_selected = mysql_select_db('realmd', $link);
if( !$db_selected ) {
die( 'Could not get database!' );
}
$q = "insert into account (email)";
$r = mysql_query($q);

if (!$r) {
echo "Error: Username already taken!";
} else {
echo "Registration Completed!";
}
mysql_close($link);
echo '<br>';
echo '<a href="index.php">Return to add another.</a>';
}

?>
</center>

can someone take alook at this & tell me whats wrong to why its not connecting

[Wickedest]

& now the new error is Could not get database!

is there anyone that can help