Posted: Tue Jan 31, 2006 5:09 am
This should definitely work...earlier in the code there were some elusive errors...try this with confidence and show us the output...
Code: Select all
<?php
error_reporting(E_ALL);
$findid = "SELECT `id` FROM `users` WHERE `username` = '$mail' ";
$idq = mysql_query($findid, $db_conn) or die("Query $findid failed".mysql_error());
echo "<br />Result: ".$idq;
if (is_resource($idq)){
echo "<br />Rows returned: ".mysql_num_rows($idq);
if (mysql_num_rows($idq) > 0){
echo "<br />Before assignment - user id: ".$userid;
$userid = mysql_result($idq, 0, "id");
echo "<br /> After assignment - user id".$userid;
$type = 'Awaiting credit check';
$enterorder = "INSERT INTO orders_main
(orderno,user_id,username,dateadded,status,archive,price,exvat,payment,q,discount,total,totalexvat,deldet,refer,l_model,config)
VALUES ('','$userid','$mail',$datejoined','$type','','$_POST[price]','$_POST[exvat2]','Finance','$_POST[quantity]','$_POST[discount]','$_POST[final]','$_POST[extotal]','$_POST[deldet]','$refer','','')";
echo "<br > Insert Query: ".$enterorder;
mysql_query($enterorder, $db_conn) or die("Query enter order failed".mysql_error());
echo "Rows Affected: ".mysql_affected_rows();
}else{
echo "<br />Unable to find id!!!";
}
}else{
echo "<br />Is not a valid resource!!!";
}
?>