[simone]

ok this is real annoying, and dont see any logical reason as too why its not insterting the data into the database ... heres the part we're looking at :

if($action == "submit") {
eval("\$camsubmit = \"".template("cam_submit")."\";");
echo $camsubmit;
eval("\$camfooter = \"".template("cam_footer")."\";");
echo $camfooter;
end_time();
eval("\$footer = \"".template("footer")."\";");
echo $footer;
exit;

if(!$submit) {
eval("\$camsubmit = \"".template("cam_submit")."\";");
echo $camsubmit;
}

else {
$email = checkInput($email, '', '', 'javascript');
$cam = checkInput($cam, '', '', 'javascript');
$website = checkInput($website, '', '', 'javascript');

$description = addslashes($description);
$ip = $_SERVER['REMOTE_ADDR'];
$adate = date("D jS M y");

$db->query ("INSERT INTO $table_cam_temp VALUES ('', '$xmbuser', '$email', '$cam', '$website', '$adate', '$ip')");
}
}

AND HERES MY FORM:

<form method="post" action="?action=submit">
<table cellspacing="0" cellpadding="0" border="0" width="$tablewidth" align="center">
<tr>
<td bgcolor="$bordercolor">
<table cellspacing="$borderwidth" cellpadding="$tablespace" border="0" width="100%" align="center">
<tr>
<td bgcolor="$altbg1" class="tablerow">$lang_cam_addemail</td>
<td bgcolor="$altbg2" class="tablerow"><input type="text" name="email" class="text"></td>
</tr>
<td bgcolor="$altbg1" class="tablerow">$lang_cam_addcam</td>
<td bgcolor="$altbg2" class="tablerow"><input type="text" name="cam" class="text"></td>
<tr>
<td bgcolor="$altbg1" class="tablerow">$lang_cam_addsite</td>
<td bgcolor="$altbg2" class="tablerow"><input type="text" name="website" class="text"></td>
</tr>
</table>
</td>
</tr>
</table>
<br>
<center><input type="submit" name="submit" value="$lang_cam_submitcam" class="submit"></center>
</form>

Can anyone see why this isnt working?

Oh and my database goes,... id, user, email, cam, website, adate, ip

[NeverMind]

it seems you are using OO in this..
but I want to check did you define a function instead of using mysql_query ?
I mean I am seeing this :

PHP Code:

$db->query ("INSERT INTO $table_cam_temp VALUES ('', '$xmbuser', '$email', '$cam', '$website', '$adate', '$ip')"); 

instead of this :

PHP Code:

$db->mysql_query ("INSERT INTO $table_cam_temp VALUES ('', '$xmbuser', '$email', '$cam', '$website', '$adate', '$ip')"); 

anyway please use the highlighter to make the code clearer to view by using [ php ] (without space)

[simone]

see im creating an xmb hack, so basically i should be able to use the coding they use in other part of their script, cept this definetly isnt working ..i also tried $db->mysql_query and i get the same result.

[brett]

Originally Posted by simone

("INSERT INTO $table_cam_temp VALUES ('', '$xmbuser', '$email', '$cam', '$website', '$adate', '$ip')");

I don't believe this is a valid method of inserting a record (could be wrong). I am pretty sure you need and should specify which columns these values are being submitted to.

Ex:

INSERT INTO $table_cam_temp VALUES (id, user, email, cam, website, adate, ip, '$xmbuser', '$email', '$cam', '$website', '$adate', '$ip')");

[simone]

no u can do it how mine is coded ..i also tried your way, with no luck.

[eddyvlad]

Try this?

INSERT INTO $table_cam_temp (id, user, email, cam, website, adate, ip) VALUES ('$xmbuser', '$email', '$cam', '$website', '$adate', '$ip')

[simone]

yehh i've tried that aswell :\

[ermau]

I must ask though, why use eval all over the place when it's really not needed?

[simone]

ah because its following the basic xmb script, its best to stick to the way they do it, so if people were to mod this script, they'd know what everything is.

[tltran]

I suggest to build the SQL string into variable and then display your query

Try to do so:

$sql = "insert... () values ($yourvariable1, .... )";

echo $sql; // display your real sql string
mysql_query($sql)... // call the mysql_query function

if it don't work try to execute your $sql string into phpmyadmin. If it don't work, it mean that your query string is not good.