Mysql insert... nothing happens no errors
Posted: Tue Jul 24, 2007 12:13 am
feyd | Please use
feyd | Please use
Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]
for some reason the following piece of code is giving my hosting business a run for its money... clients (or developers at this stage) input all their information into a form which is parsed and the results are entered into a mysql db.. which is remote but no access problems as of now. i checked the phpmyadmin... table isnt created... nothing happens when you submit except that it brings back up the blank signup sheet.Code: Select all
<?php
mysql_select_db("woodenwe_clients", $con);
$uid=mysql_query("SELECT 'uid' FROM 'accounts'");
$uid_results=mysql_num_rows($uid);
$new_uid=($uid_results+1);
mysql_query("INSERT INTO 'accounts' firstname, lastname, phone, username, password, street, city, state, zip, email, class, uid, domain, plan, date, status VALUES ".$fname, $lname, $username, $password,$street, $city, $state, $zip, $email, $resell, $class, $new_uid, $domain, $plan, $date, "inactive");
mysql_close($con);
mail($email, "'Welcome to Wooden Web Hosting', 'Welcome to Wooden Web Hosting.<p>You can activate your account by clikcing the link below. Once activated, a sales representative will assist you via live chat or telephone at your convenience.<p><a href='http://woodenwebhosting.co.nr/signup/activate.php?uid='$new_uid></a>'");
print "Check your email for information about account activation.";
}
?>feyd | Please use
Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]