Why isn't this working??

[Harley]

Okay, I'm not sure what is going on... but I'm using this here form:

This is the code from the php:

$dbh=mysql_connect ("localhost", "primevil_rome", "<my_password>") or die ('I cannot connect to the database because: ' . mysql_error());

mysql_query("INSERT INTO romesheet (playerid,nick,RealName,password,ShowStats,ViewOnlyPassword,email,WantShown,URLaddress,gender,age,IconID,Comments,ExitMessage,whatru,Strength,Charisma,Perception,Dexterity,Manipulation,Intelligence,Stamina,Appearance,Wits,Alertness,AnimalKen,Academics,Athletics,Crafts,Bureaucracy,Awareness,Demolitions,Computer,Brawl,Drive,Enigmas,Dodge,Etiquette,Finance,Empathy,Firearms,Investigation,Expression,Meditation,Law,Intimidation,Melee,Linguistics,Intuition,Performance,Lore,Interrogation,Repair,Medicine,Leadership,Security,Occult,Streetwise,Stealth,Politics,Subterfuge,Survival,Research,Technology,Science,Willpower,Backgrounds,powers,Advantages,merit,othertraits,equipment,equipment2,whenmade,whenupdate) VALUES (NULL,'$form_nick','$form_RealName','$form_password','$form_ShowStats','$form_ViewOnlyPassword','$form_email','$form_WantShown','$form_URLaddress','$form_gender',$form_age,$form_IconID,'$form_Comments','$form_ExitMessage','$form_whatru','$form_Strength','$form_Charisma','$form_Perception','$form_Dexterity','$form_Manipulation','$form_Intelligence','$form_Stamina','$form_Appearance','$form_Wits','$form_Alertness','$form_AnimalKen','$form_Academics','$form_Athletics','$form_Crafts','$form_Bureaucracy','$form_Awareness','$form_Demolitions','$form_Computer','$form_Brawl','$form_Drive','$form_Enigmas','$form_Dodge','$form_Etiquette','$form_Finance','$form_Empathy','$form_Firearms','$form_Investigation','$form_Expression','$form_Meditation','$form_Law','$form_Intimidation','$form_Melee','$form_Linguistics','$form_Intuition','$form_Performance','$form_Lore','$form_Interrogation','$form_Repair','$form_Medicine','$form_Leadership','$form_Security','$form_Occult','$form_Streetwise','$form_Stealth','$form_Politics','$form_Subterfuge','$form_Survival','$form_Research','$form_Technology','$form_Science','$form_Willpower','$form_Backgrounds','$form_powers','$form_Advantages','$form_merit','$form_othertraits','$form_equipment','$form_equipment2',NOW() + 0,0)") or die ("Error!  Something messed up, and your sheet wasn't added.  Sorry.  Please contact the administrator at [email][e-mail][/email], and she'll try and fix it up.  If you want to speed things up, email your sheet to her, and she'll add it manually."); 

Now, when I test it I am getting the error which I have set up: "Something messed up, and your sheet wasn't added." I have gone over the tables to be sure I didn't mispell anything...

Many of the fields - From strength on uses the ENUM since on the form they are drop down of values of 1-10 or the '-', 1-9 for Skills and still... no love. 🙁

Aren't ENUM considered String objects hence the single quote around the field? I've tried with quotes and without and still no data being inputed.

Could someone help me out? I'm fairly new to this php/mysql, want to learn it but this is starting to drive me bonkers...[FONT=century gothic]

[nnichols]

Try adding this after your query -

echo "<b>mySQL error no: " . mysql_errno() . "<br>mySQL error: " . mysql_error() . "</b>";

it should give you the reason that the insert is failing.

Hope this helps 😉

[chads2k2]

Basic MySQL right here.

Insert into table VALUES (put stuff here);

You forgot VALUES in there. 🙂

I could be wrong.

Chad

[nnichols]

chads2k2

His structuring is correct. He is using -

INSERT INTO tbl_name (col1,col2,...) VALUES (val1,val2,...)

[Harley]

Originally posted by nnichols
Try adding this after your query -

echo "<b>mySQL error no: " . mysql_errno() . "<br>mySQL error: " . mysql_error() . "</b>";

it should give you the reason that the insert is failing.

Hope this helps 😉 [/B]

I put that in it's not giving me any errors towards the inserting just straight back to the error message and that's all.

I put the code in before the query and this is what I gets:

mySQL error no: 0
mySQL error: Error! Something messed up, and your sheet wasn't added. Sorry. Please contact the administrator at [e-mail], and she'll try and fix it up. If you want to speed things up, email your sheet to her, and she'll add it manually.

And when I put it aftered the query, I just got the error message of mine. So, not sure what else to try. 🙁

[tomhath]

I put the code in before the query and this is what I gets:

Put it after the query (otherwise how would it know?) 😉

[Harley]

I put it after the query still no luck... 🙁

[nnichols]

If you post again attaching your php file I (or whoever comes along first) will have a look at it.

Nick

[Harley]

As you see I even went in and changed the value names to make them shorter - hey, never know coulda been a typo in there somewhere. Thanks for the help tho. 😃

Here's the PHP code in all it's 'getting to be annoying' glory:

<html>
<head>
<title>Eternal City  - Character sheet</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<style>
<!-- 
	A:link,
	A:visited, 
	A:active { text-decoration: none; }
	A:hover	 { color: #33CC00; }
-->
</style>

<body bgcolor="#FFFFFF" text="#000000" link="#3333CC" vlink="#3333CC" alink="#3333CC">
<div align="center"><font face="Century Gothic" size=+2>Rome by Night<br>
Character Sheet</font></div>
<br>
<br>
<font face="Arial"> 
<?php

$dbh=mysql_connect ("localhost", "primevil_rome", "<mypassword>") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("primevil_database"); 

mysql_query("INSERT INTO romesheet (playerid,nick,RealName,password,ShowStats,ViewOnlyPassword,email,WantShown,URLaddress,gender,age,IconID,Comments,ExitMessage,whatru,Strength,Charisma,Perception,Dexterity,Manipulation,Intelligence,Stamina,Appearance,Wits,Alertness,AnimalKen,Academics,Athletics,Crafts,Bureaucracy,Awareness,Demolitions,Computer,Brawl,Drive,Enigmas,Dodge,Etiquette,Finance,Empathy,Firearms,Investigation,Expression,Meditation,Law,Intimidation,Melee,Linguistics,Intuition,Performance,Lore,Interrogation,Repair,Medicine,Leadership,Security,Occult,Streetwise,Stealth,Politics,Subterfuge,Survival,Research,Technology,Science,Willpower,Backgrounds,powers,Advantages,merit,othertraits,equip1,equip2,whenmade,whenupdate) VALUES ('NULL','$nick','$RealName','$password','$ShowStats','$ViewOnlyPassword','$email','$WantShown','$URLaddress','$gender',$age,'$IconID','$Comments','$ExitMessage','$whatru','$Strength','$Charisma','$Perception','$Dexterity','$Manipulation','$Intelligence','$Stamina','$Appearance','$Wits','$Alertness','$AnimalKen','$Academics','$Athletics','$Crafts','$Bureaucracy','$Awareness','$Demolitions','$Computer','$Brawl','$Drive','$Enigmas','$Dodge','$Etiquette','$Finance','$Empathy','$Firearms','$Investigation','$Expression','$Meditation','$Law','$Intimidation','$Melee','$Linguistics','$Intuition','$Performance','$Lore','$Interrogation','$Repair','$Medicine','$Leadership','$Security','$Occult','$Streetwise','$Stealth','$Politics','$Subterfuge','$Survival','$Research','$Technology','$Science','$Willpower','$Backgrounds','$powers','$Advantages','$merit','$othertraits','$equip1','$equip2',NOW() + 0,0)") or die ("Error!  Something messed up, and your sheet wasn't added.  Sorry.  Please contact the administrator at [email][e-mail][/email], and she'll try and fix it up.  If you want to speed things up, email your sheet to her, and she'll add it manually.");

echo "<b>mySQL error no: " . mysql_errno() . "<br>mySQL error: " . mysql_error() . "</b>";

if ($request == "Y") {
	$to = $stemail.", ".$RealName." <".$email.">";
	$subject="Sanction request for ".$nick;
	$message="The following is a sanctioning request for "
	.$nick.", at ".$email.".\n\n"
	.$nick." is a character for Eternal City.  The player has included the following note:\n"
	.$RequestNote."\n\nPlease remember that, if replying, to send to the player's address.  These emails are sent even if the character was not added to the database.\nThank you!";
	$header .="From: Eternal City Request Form <[e-mail]>\n";
	$header .="Reply-To: ".$email."\n";
	$header .="X-Sender: <[e-mail]>\n"; 
	$header .="X-Mailer: PHP/".phpversion()."\n";
	$header .="Return-Path: <[e-mail]>\n";

$to=trim($to);
$subject=trim($subject);
$message=trim($message);
$header=trim($header);

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

}


$siteURL = "http://www.evil-incorporated.com/";

$to = $RealName." <".$email.">";
$subject="Character sheet reminder for ".$nick;
$message="This is a reminder for your character, "
	.$nick.".  You, or someone using this email address, has just created a character for Eternal City.  The name and password to access the sheet are:\n\n"
	."Username: ".$nick."\n"
	."Password: ".$password."\n"
	."View-Only Password: ".$ViewOnlyPassword."\n"
	."You can edit or delete this sheet, or view others' characters, at "
	.$siteURL."\nThese emails are sent even if the character was not added to the database.\n\nThank you!";
$header = "From: Eternal City Reminder <[e-mail]>\n";
$header .="Reply-To: Harley Quin <[e-mail]>\n";
$header .="X-Sender: <[e-mail]>\n"; 
$header .="X-Mailer: PHP/".phpversion()."\n";
$header .="Return-Path: <[e-mail]>\n";

$to=trim($to);
$subject=trim($subject);
$message=trim($message);
$header=trim($header);

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

?>

<p align="justified">&nbsp; &nbsp;Unless an error popped up above, your character, <b><?php echo $nick; ?></b>, has been added to the database, and an email reminder has been sent to your email address.  If you requested sanctioning via an email request, an email has been sent to both you and the Storyteller for the group you specified.
</p>
<br>
<br>
<center>
  <a href="index.php">Eternal City: Rome by Night</a><br>
  <a href="http://www.white-wolf.com/">White Wolf Online</a> 
</center>
</font> 
</body>
</html>

That's it and to imagine that's only the start.... ::bangs her head against her desk::

[nemonoman]

You're not getting the error number because you DIE...

die ("Error! Something messed up, and your sheet wasn't added. Sorry. Please contact the administrator at [e-mail], and she'll try and fix it up. If you want to speed things up, email your sheet to her, and she'll add it manually.");

Befiore you reach this line...

echo "<b>mySQL error no: " . mysql_errno() . "<br>mySQL error: " . mysql_error() . "</b>";

ALSO:

Put your sql into a string

like $query="INSERT....etc."

and then say

mysql_query($query);

THEN ALSO put the variable

$query in your DIE statement so it prints out the way the DB got it.

Often there's an unexpected \ or ' in a variable you're trying to insert, and it's easier to see when you see the statement complete with the actual data included. That's the reason for creating the $query and including it in your error routine.