having problems inserting into in table

d2u77

I have created a new table in my database and I am having problems inserting data into it. I have tried manually adding data with no problems. I only have problems when trying to insert using the following code. I have echoed the variables and all the data is getting to this page its just not inserting. Here is the code any help would be great..Thanks

<?php
$db = mysql_connect("localhost", "usrname", "password");
mysql_select_db("hiphopgcom", $db);

$date = (date("Y-m-d H:i:s"));
function tscalc()
{
$arr = explode(" ", microtime());
return $arr[0] + $arr[1];
}
srand(tscalc());
$id = rand();
$ip = getenv("REMOTE_ADDR");

$result = mysql_query ("INSERT INTO artistcards (ids,dates,ip,cardid,uname,uemail,rname,remail,body,track1,track2,track3,track4,track1title,track2title,track3title,track4title,card,link1,link2,link3,link4,link5) VALUES ('$id','$date','$ip','$cardid','$uname','$uemail','$rname','$remail','$body','$track1','$track2','$track3','$track4','$track1title','$track2title','$track3title','$track4title','$card','$link1','$link2','$link3','$link4','$link5')", $db);
//echo "insert: $insert";

echo "result: $result";

//print "<meta http-equiv=\"Refresh\" content=\"0; URL=/main/studio/studio.php?id=$cardid\">";
?>

tomhath

I don't see anything obviously wrong. But rather than guessing, add a call to mysql_error after the mysql_query (and after the mysql_connect and mysql_select_db calls) to see what the dbms thinks is wrong.

http://www.phpbuilder.com/manual/function.mysql-error.php

paulsbooker

yes i suspect you not have connected to the database

you don't need $result handler for an insert

paul

d2u77

Thanks for the suggestion but the mysql_error() never reported an error. I have also tried echoing the results from the insert and they keep coming up blank. Is there anything else I can do to get this data into the table?

Thanks

d2u77

Here is another little twist to the problem. I have a call to the database earlier in the page and it works fine. It pulls from a different table but it still works. I know I shouldn't do this but I am going to post most of the rest of the file here maybe there is something not meshing right and I am just not seeing it.

<?php
session_start();
$username=$username;
$password=$password;
session_destroy();
session_start();
session_register('password');
session_register('username');
session_register("card");
$card=$HTTP_GET_VARS["card"];
?>
<html>

<head> 
	<meta http-equiv="content-type" content="text/html;charset=iso-8859-1">
	<title>HipHopG - Send a card</title>

<SCRIPT LANGUAGE = "JavaScript">
<!--

bName = navigator.appName;
bVer = parseInt(navigator.appVersion);
if ((bName == "Netscape" && bVer >= 3) ||
(bName == "Microsoft Internet Explorer" && bVer >= 4)) br = "n3";
else br = "n2";

if (br== "n3") {
img1ad = new Image();         
img1ad.src = "../images/sponsors/bearcast_banner.gif";   
img2ad = new Image();
img2ad.src = "../images/sponsors/headbob.gif"; 
img3ad = new Image();         
img3ad.src = "../images/sponsors/rapstation.gif";  
img4ad = new Image();
img4ad.src = "../images/sponsors/kddb.gif";  
img5ad = new Image();
img5ad.src = "../images/sponsors/fliphouse-golda.gif";  
img6ad = new Image();
img6ad.src = "../images/sponsors/thebeat985.gif";  
img7ad = new Image();
img7ad.src = "../images/sponsors/wild987.gif";  
img8ad = new Image();
img8ad.src = "../images/sponsors/kmel.gif";  
img9ad = new Image();
img9ad.src = "../images/sponsors/fan2fan.gif";  
img10ad = new Image();
img10ad.src = "../images/sponsors/atlantic.gif";  
img11ad = new Image();
img11ad.src = "../images/sponsors/kmel.gif"; 
}

function imgAct(imgName) {
if (br== "n3") {
document["holder"].src = eval(imgName + "ad.src");
}
}

function imgInact(imgName) {
if (br== "n3") {
document["holder"].src = "../images/sponsors/Slice.gif";
}
}

// -->
</SCRIPT>
<?php
$db = mysql_connect("localhost", "usr", "pass");
mysql_select_db("hiphopgcom", $db);
$result = mysql_query("SELECT * FROM carddata WHERE card = '$card'");
if($myrow = mysql_fetch_array($result))
{
$cardid = $myrow["cardid"];
$track1 = $myrow["track1"];
$track2 = $myrow["track2"];
$track3 = $myrow["track3"];
$track4 = $myrow["track4"];
$track1title = $myrow["track1title"];
$track2title = $myrow["track2title"];
$track3title = $myrow["track3title"];
$track4title = $myrow["track4title"];
$link1 = $myrow["link1"];
$link2 = $myrow["link2"];
$link3 = $myrow["link3"];
$link4 = $myrow["link4"];
$link5 = $myrow["link5"];

}
else {
echo "sql error";
}

?>
	<?php

if($action == "post") {
//require('posting.inc');
//$db = mysql_connect("localhost", "usr", "pass");

//mysql_select_db("hiphopgcom", $db);

$date = (date("Y-m-d H:i:s"));
function tscalc()
{
$arr = explode(" ", microtime());
return $arr[0] + $arr[1];
}
srand(tscalc());
$id = rand();
$ip = getenv("REMOTE_ADDR");

$insert = "INSERT INTO artistcards (ids,dates,ip,cardid,uname,uemail,rname,remail,body,track1,track2,track3,track4,track1title,track2title,track3title,track4title,card,link1,link2,link3,link4,link5) VALUES ('$id','$date','$ip','$cardid','$uname','$uemail','$rname','$remail','$body','$track1','$track2','$track3','$track4','$track1title','$track2title','$track3title','$track4title','$card','$link1','$link2','$link3','$link4','$link5')";
$result = mysql_query($insert);
//echo "error" .mysql_errorno().;
echo "insert: $insert";
mysql_error();
echo "result: $result";

print "<meta http-equiv=\"Refresh\" content=\"0; URL=/main/studio/studio.php?id=$cardid\">";

exit;
}
?>
<table width="75%" border="0">
<tr>
<td valign="top"><table width="100" border="0">
<tr>
</tr>
<tr>
<tr>
<td width="165" align="center" valign="top" height="250"> <table width="166" border="0" height="120">
<tr align="center">
<td colspan="3" height="50"><img name="holder" src="../images/sponsors/Slice.gif" width="124" height="74" border="0"></td>
</tr>
<tr align="center" valign="middle">
<td colspan="2" height="9"><a href="http://bearcast.uc.edu" onMouseOver = "imgAct('img1')" onMouseOut = "imgInact('img1')" target="blank"><img src="../images/sponsors/bearcast_bannerSm.gif" width="105" height="28" border="0" name="img1"></a></td>
<td width="51" height="9"><a href="http://www.headbob.com" onMouseOver = "imgAct('img2')" onMouseOut = "imgInact('img2')" target="blank"><img src="../images/sponsors/headbobSm.gif" width="51" height="30" border="0" name="img2"></a></td>
</tr>
<tr align="center" valign="middle">
<td colspan="2" height="2"><a href="http://www.rapstation.com" onMouseOver = "imgAct('img3')" onMouseOut = "imgInact('img3')" target="blank"><img src="../images/sponsors/rapstationSm.gif" width="102" height="30" border="0" name="img3"></a></td>
<td width="51" height="2"><a href="http://www.kddb.com" onMouseOver = "imgAct('img4')" onMouseOut = "imgInact('img4')" target="blank"><img src="../images/sponsors/kddbSm.gif" width="51" height="30" border="0" name="img4"></a></td>
</tr>
<tr align="center" valign="middle">
<td height="30" colspan="2"><a href="http://www.hiphopg.com/welcome/under.html" onMouseOver = "imgAct('img5')" onMouseOut = "imgInact('img5')" target="blank"><img src="../images/sponsors/fliphouse-goldaSm.gif" width="101" height="30" border="0" name="img5"></a>
<td width="51" height="30"><a href="http://kbbt.netmio.com/homepage/0,2257,SI40,00.html" onMouseOver = "imgAct('img6')" onMouseOut = "imgInact('img6')" target="blank"><img src="../images/sponsors/thebeat985Sm.gif" width="51" height="30" border="0" name="img6"></a></td>
</tr>
<tr align="center" valign="middle">
<td width="52"><a href="http://www.wild987.com" onMouseOver = "imgAct('img7')" onMouseOut = "imgInact('img7')" target="blank"><img src="../images/sponsors/wild987Sm.gif" width="36" height="30" border="0" name="img7"></a></td>
<td width="49"><a href="http://www.106kmel.com" onMouseOver = "imgAct('img8')" onMouseOut = "imgInact('img8')" target="blank"><img src="../images/sponsors/souljamstvSm.gif" width="36" height="30" border="0" name="img8"></a></td>
<td width="51"><a href="http://www.fan2fan.com" onMouseOver = "imgAct('img9')" onMouseOut = "imgInact('img9')" target="blank"><img src="../images/sponsors/fan2fanSm.gif" width="36" height="30" border="0" name="img9"></a></td>
</tr>
<tr align="center" valign="middle">
<td colspan="3"> <table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr align="center" valign="top">
<td width="51" height="30"><a href="http://www.atlantic-records.com/" onMouseOver = "imgAct('img10')" onMouseOut = "imgInact('img10')" target="blank"><img src="../images/sponsors/atlanticSm.gif" width="51" height="30" border="0" name="img10"></a></td>
<td width="51" height="30"><a href="http://www.106kmel.com" onMouseOver = "imgAct('img11')" onMouseOut = "imgInact('img11')" target="_blank"><img src="../images/sponsors/kmelSm.gif" width="51" height="30" border="0" name="img11"></a></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
<td align="center"><?php
include("../inc/newmenu/top.php");
?>

tomhath

mysql_error returns a string, it doesn't print it. Try it this way:

$result = mysql_query($insert) or die('insert failed: ' . mysql_error() );

d2u77

thanks I will try that tonight.

d2u77

tomhath.....thank you so much, that line you gave worked like a charm. It turned out to be an extra single quote that was causing all the problems. Thanks again you a lifesaver.