[Resolved] Where is the problem...?

busyguy78

I've been looking all day and I cannot find the problem with this part of the code...

		$babaloo = mysql_query("Insert Into owners 
(OwnerName, OwnerAddress, OwnerCity,
OwnerZip, OwnerPhone, OwnerWebsite,
OwnerUser, OwnerPass, OwnerState, OwnerContact) 
Values
('$ownername','$owneraddress','$ownercity',
'$ownerzip','$ownerphone','$ownerwebsite',
'$owneruser','$ownerpass','$ownerstate','$ownercontact')") 
or die("Insert Did Not Work");

I checked and the spelling and case of all the field names and the table is right on...

What am I not seeing...?

zapa

$ownercon
tact')")

could put it in one line maybe the line return is messing it up?

The_Chancer

What was the error ?

Use

$babaloo = mysql_query("INSERT INTO `owners` 
(OwnerName, OwnerAddress, OwnerCity,
OwnerZip, OwnerPhone, OwnerWebsite,
OwnerUser, OwnerPass, OwnerState, OwnerContact)
VALUES
('".$ownername."','".$owneraddress."','".$ownercity."',
'".$ownerzip."','".$ownerphone."','".$ownerwebsite."',
'".$owneruser."','".$ownerpass."','".$ownerstate."','".$ownercontact."')") 
or die(mysql_error()." Insert Did Not Work");

Should give you the mysql error from that...

busyguy78


if ($submit)
{
	// Access DB

include ("final_code/dbConnect.php");

// Check other users

$check_result = mysql_query ("Select * From owners Where OwnerUser = '$ownerusername'");

$check_num = mysql_num_rows($check_result);

if ($check_num > 0)
{
	$url = "http://www.apartment-scout.com/owner_register.php?error=1"; 
	$delay = "0";
	echo '<meta http-equiv="refresh" content="'.$delay.';url='.$url.'">';
}
else
{	
	// Input information into owners table

	echo $ownername;
	echo "<br>";
	echo $owneraddress;
	echo "<br>";
	echo $ownercity;
	echo "<br>";
	echo $ownerzip;
	echo "<br>";
	echo $ownerphone;
	echo "<br>";
	echo $ownerwebsite;
	echo "<br>";
	echo $owneruser;
	echo "<br>";
	echo $ownerpass;
	echo "<br>";
	echo $ownerstate;
	echo "<br>";
	echo $ownercontact;
	echo "<br>";

	$babaloo = mysql_query("Insert Into owners (OwnerName, OwnerAddress, OwnerCity, OwnerZip, OwnerPhone, OwnerWebsite, OwnerUser, OwnerPass, OwnerState, OwnerContact) 
							Values ('$ownername','$owneraddress','$ownercity','$ownerzip','$ownerphone','$ownerwebsite','$owneruser','$ownerpass','$ownerstate','$ownercontact')") or die("Insert Did Not Work");

Thanks for the help on this...
Still not working...
Whenever I try to run this, I get "Insert Did Not Work"...
I echo'd the variables to make sure nothing was wrong there and they are fine...
I'm stumped...

This is in a form to sign up an 'Owner'...
I duplicated it from a nearly identical form to sign up a 'User' (which works fine)...
All I did was change the table, fields, and variable names...

Arghhhhh...!

drawmack

try echoing the sql statement and taking a look at that. Also use mysql_error() to echo the error from the dbms.

busyguy78

Thanks for the tip...
I echo'd the sql statement and all looked OK...
I broke it up into 2 statements ...
Still no use...
I keep getting the 'Insert didn't work' error I put in...
I also added an 'or die' statement to the DB call...


if ($submit)
{
	// Access DB

include ("final_code/dbConnect.php") or die("Bad DB");

// Check other users

$check_result = mysql_query ("Select * From owners Where OwnerUser = '$ownerusername'");

$check_num = mysql_num_rows($check_result);

if ($check_num > 0)
{
	$url = "http://www.apartment-scout.com/owner_register.php?error=1"; 
	$delay = "0";
	echo '<meta http-equiv="refresh" content="'.$delay.';url='.$url.'">';
}
else
{	
	// Input information into owners table

	echo $ownername;
	echo "<br>";
	echo $owneraddress;
	echo "<br>";
	echo $ownercity;
	echo "<br>";
	echo $ownerzip;
	echo "<br>";
	echo $ownerphone;
	echo "<br>";
	echo $ownerwebsite;
	echo "<br>";
	echo $owneruser;
	echo "<br>";
	echo $ownerpass;
	echo "<br>";
	echo $ownerstate;
	echo "<br>";
	echo $ownercontact;
	echo "<br>";

	$babaloo = "Insert Into owners (OwnerName, OwnerAddress, OwnerCity, OwnerZip, OwnerPhone, OwnerWebsite, OwnerUser, OwnerPass, OwnerState, OwnerContact) 
							Values ('$ownername','$owneraddress','$ownercity','$ownerzip','$ownerphone','$ownerwebsite','$owneruser','$ownerpass','$ownerstate','$ownercontact')";
	echo $babaloo;
	echo "<br>";

	$lucy = mysql_query($babaloo) or die ("Query Didn't Work");

I just can't understand what's wrong when there is a page that is nearly the same, and it works fine...

Stressing...!

What a wonderful world....!

Oh no ! I'm losing it...!

busyguy78

I'm thinking I might just delete the page...

Rebuild it from scratch...

And try it again...

Sometimes that works...

But when it does, I never know what went wrong...

Thanks for all the help everyone...

mrhappiness

Originally posted by busyguy78
I echo'd the sql statement and all looked OK...

I looked at the this fabolous description and came to the conclusion that something didn't work

if someone asks you to echo something why for god's sake you don't poste that?

and: i look thru your php and didn't find a single usage of mysql_fetch_array, mysql_fetch_ro, mysql_fetch_assoc or mysql_fetch_object...

busyguy78

Well I re-wrote the page and, of course, it works now...
Not sure what happened...
Sorry to get everyone all confused...

Here is the new code if it helps anyone...

If ($submit)

{



// Access DB



include ("final_code/dbConnect.php");



// Check other users



$check_result = mysql_query ("Select * From owners

				Where OwnerUser = '$owneruser'");



$check_num = mysql_num_rows($check_result);



if ($check_num > 0)

{

	$url = "http://www.apartment-scout.com/owner_register.php?error=1"; 



	$delay = "0";



	echo '<meta http-equiv="refresh" content="'.$delay.';url='.$url.'">';

}

else

{	







// Input information into users table



$insert = "INSERT INTO owners (OwnerContact, OwnerName, OwnerAddress, OwnerCity, OwnerState, OwnerZip, OwnerPhone, OwnerWebsite, OwnerUser, OwnerPass)

		VALUES ('$ownercontact','$ownername','$owneraddress','$ownercity','$ownerstate','$ownerzip','$ownerphone','$ownerwebsite','$owneruser','$ownerpass')";



$insert_result = mysql_query($insert) or die("Insert Did Not Work");