[RESOLVED] Loading form generates "Query was empty" error message

POMfils

Below is my code. I connect fine to the database but obviously, I am not collecting data from my form. I first had an htm file sending data to the php file. I then moved all in one file... Still doesn't work. I am not a very experienced php coder.. as you will see, but I need help with this please:

THE PHP code:
<?php

// setting connection infomation.

if (!empty($_POST))
{

//Setting content parameters
$dDid= $POST ['dnAddress'];
$dTitle= $POST['dntitle'];
$dLName= $POST['dnLName'];
$dFName= $POST['dnFName'];
$Email= $POST['dnEmail'];
$dCity= $POST['dnCity'];
$dProv= $POST['dnProv'];
$dZip= $POST['dnPCode'];
$dPhm= $_POST['dnPhmain'];

// connect to the mysql database server. $connect = @mysql_connect ($host, $user, $pass);
$gozy = mysql_connect($hsrv, $uzrname, $uzrpwd);

mysql_select_db("fafuzr", $gozy) or die( "Unable to select database");
	$query = mysql_query ("INSERT INTO personnes
					(
						Did,
						dTitle,
						dLName,
						dFName,
						dEmail,
						dAdCity,
						dAdProv,
						dAdZip,
						dPhMain,
					)
				VALUES
					(
						$dDid,
						$dTitle,
						$dLName,
						$dFName,
						$dEmail,
						$dCity,
						$dProv,
						$dZip,
						$dPhm
					)");
	printf("Last inserted record has id %d\n", mysql_insert_id());

		if ( mysql_query ( $query ) )
		{
			$success = 'New donor added';
		}
		else {
			die ( mysql_error () );
		}
}

THE html PART:
<FORM METHOD="POST" NAME="frmdonation" ACTION="<?echo$PHP_SELF?>">

                  <tr>
                   <td colspan="2">
                    <p class="titre"><b>4. Tell us about you...</p>
                   </td>
                  </tr>
                  <tr>
                    <td width="353" height="166">
                      <table width="320" border="0" cellpadding="0" cellspacing="0">
                        <tbody><tr>
                          <td width="130" height="30"><b>Title <font color="#999933">*</font></b></td>
                          <td width="180">
                            <select class="FT" style="width: 180px;" name="dntitle">
                              <option selected="selected"></option>
                              <option value="<?php echo $_POST['dntitle'] ?>">Mr.</option>
                          </select>
                          </td>
                        </tr>
                        <tr>
                          <td height="30"><b>First Name <font color="#999933">*</font></b></td>
                          <td>
                            <input class="FT" style="width: 180px;" maxlength="50" size="18" name="dnFName" value="<?php $_POST['dnFName'] ?>" />
                          </td>
                        </tr>
                        <tr>
                          <td height="30"><b>Last Name <font color="#999933">*</font></b></td>

(...)

                  <tr>
                   <td><input type="submit" value ="Proceed" name="Proceed"></td>
                  </tr>

tomhath

You need quotes around character fields in the VALUES part.

Try putting the query into a variable and echo it out to see what you have.

POMfils

Thank you Tomhath for the reply but, I am still not successful... I still get the same error message "Query was empty" after I added the quotes:

$query = mysql_query ("INSERT INTO personnes
				(
					Did,
					dTitle,
					dLName,
					dFName,
					dEmail,
					dAdCity,
					dAdProv,
					dAdZip,
					dPhMain,
				)
			VALUES
				(
					'$dDid',
					'$dTitle',
					'$dLName',
					'$dFName',
					'$dEmail',
					'$dCity',
					'$dProv',
					'$dZip',
					'$dPhm',
					'',

				)");

djjjozsi

your code makes this:

if ( mysql_query(mysql_query ( $query ) ) )

POMfils

I am sorry, but I am lost... still aren't able to insert this info into my database...

djjjozsi

$dDid= $_POST ['dnAddress']; do not use a space between POST and the bracket...

dAdZip,
dPhMain, <-------- do not add the last comma!
)

function ordie($text)
{
	$test=1;  //set this 0 if you  want to hide error texts

if($test==1)
die($text);
else
die("The program found an error, and terminated!<br />");
}


$sql="INSERT INTO personnes
(Did,dTitle,dLName,dFName,dEmail,dAdCity,dAdProv,dAdZip,dPhMain)
VALUES
('$dDid','$dTitle','$dLName','$dFName','$dEmail','$dCity','$dProv','$dZip','$dPhm')";

$query = mysql_query($sql) or ordie("pROBLEM WITH THE QUERY: $sql - ".mysql_error());

POMfils

Hi and thanks you for the help.. My code is now working fine.
I removed the last comma 🙁 also, I removed the control I added in the database [UNIQUE/NOT DUPLICATED] for some of the fields [Phmain] to replace those with SQl quearies...

I also found another stupid bug: I was missing the "d"in this declaration "$Email= $_POST['dnEmail'];"...

I need to fine tune now..

Thank you for your help...

djjjozsi

Your welcome,
if this problem has solved then set this thread as re-solved. (In the Thread Tools menu )

jjozsi