[Resolved] Bad code

[piersk]

Anyone see whwr I'm going wrong? No error messages are showing up:

	error_reporting(E_ALL);
	if(!(isset($_GET['registersb'])))
	{
		header("location:../index.php");
		exit;
	}

include_once("sql.inc.php");
$realname = $_GET['registerFN'].$_GET['registerLN'];
$now = time();
$insertsubQuery = "insert into subscriber values('','$_GET[registerUN]','$_GET[registerPW]','$realname','$_GET[registeremail]','$_GET[registertitle]','$now','','','','$_GET[registertelephone]','$_GET[registerfax]')";
mysql_query($insertsubQuery,$dbconnect);
$subID = mysql_insert_id($dbconnect);
$insertcoQuery = "insert into company values('','$subID',$_GET[registercompany]',$_GET[registeraddress1]','$_GET[registeraddress2]','$_GET[registertown]','$_GET[registercounty]','$_GET[registercountry]','$_GET[registerpostcode]','$_GET[registercountry]','$_GET[registerinv]','$_GET[registerwebsite]','')";
mysql_query($insertcoQuery,$dbconnect);

$to = "[e-mail]";

$subject = "New TTP Subscriber";
$body = "The following data was entered into the TTP database.\n\n";
$body .= "Subscriber: " . $realname ."\n";
$body .= "Company: " . $_GET['registercompany'] . "\n";
$body .= "Address:\n";
$body .= $_GET['registeraddress1'] . " " . $_GET['registeraddress2'] . "\n";
$body .= $_GET['registertown'] . "\n" . $_GET['registercounty'] . "\n" . $_GET['registerpostcode'] . "\n";
$body .= $_GET['registercountry'] . "\n";
$body .= "Email address: " . $_GET['registeremail'] . "\n" . "Telephone number: " . $_GET['registertelephone'] . "\n";
$body .= "Fax: " . $_GET['registerfax'] . "\n\n";
$body .= $_GET['registerwebsite'] . "\n\n";
$body .= "Invoice number: ".$_GET['registerinv']."\n\n\n";
$body .= "To allow the subscriber access, either click or follow the link below.\n\n";
$body .= "Link: [url]http://www.technologytradingpost.com/index.php?page=allow&subid=[/url]".$subID.".\n\n";
$body .= "If you have any problems, email Piers ([e-mail])";

$header = "From:[e-mail]\r\n";
$header .= "CC:[e-mail]\r\n";

mail($to,$subject,$body,$header);

[laserlight]

Could this be the problem?

$insertcoQuery = "insert into company values('','$subID',$GET[registercompany]',$GET[r
egisteraddress1]'

there seems to be 1 missing single quote each at the front of the 2 variables.

[piersk]

Could have been it, but it wasn't just that cos it's still not working. Does anyone know why there are no error messages popping up?

[laserlight]

The next problem might be:

$body .= "Link: <a href="http://www.technologytradingpost

but I have no idea why there arent any errors being displayed.

[The_Chancer]

Do you get as far as the mail function, or does it just stop before ?

Try echoing the SQL queries and see if it what you expect...

[piersk]

I am such a moron!!

All those $GET's that you can see? They're supposed to be $POST's.

Boy do I feel stupid now!! :mad:

[laserlight]

hmm... that's why there was no error reported.

still, shouldnt there have been errors reported due to the other parts I pointed out?

strange

[The_Chancer]

<phew>

And I thought it was only me that made such mistakes...