No result - need advice.

From: Date: Tue, 20 Feb 2001 18:14:13 +0000
Subject: No result - need advice.
Groups: php.general 
Request: Send a blank email to php-general+get-40778@lists.php.net to get a copy of this message
I'm having problem with a php script. I get a valid insert statment echoed to the screen but I don't get a result from it. If I cut and paste into the SQL query box in PHPMyadmin, it insert fine, but it will not do it from the script. Through debuging (echoing to the screen), I have determinde that it is connecting to the database and it does get the variables passed to it, but it just won't work. Here is the PHP. <html> <!-- Coded by the grace of God! --> <LINK REL=stylesheet HREF="../index.css" TYPE="text/css"> <? $db = mysql_connect("localhost", "root", ""); mysql_select_db("memberstest",$db); echo "db = ".$db."<p>"; $date = date("m.d.y"); echo "date ".$date."<p>"; if (!$name || !$year || !$make || !$model || !$pass || !$cab || !$drive || !$active || !$mlist || !$pass || !$loc) { echo "<P><CENTER><TABLE WIDTH=\"500\" BORDER=\"0\" CELLSPACING=\"0\" CELLPADDING=\"0\"> <TR> <TD WIDTH=\"500\"><P><CENTER><FONT SIZE=\"+2\">You didn't fill in the required fields!</FONT></CENTER><P><CENTER><FONT SIZE=\"+2\">Press the back button on your browser and fill in the required fields which have a </FONT><FONT COLOR=\"#ff0000\" SIZE=\"+2\">*</FONT><FONT SIZE=\"+2\"> next to them.</FONT></CENTER></TD> </TR> </TABLE> "; exit(); } echo "passed requirements<p>"; $sql = "INSERT INTO memberstest VALUES ('', '$name', '$icq', '$loc', '$active', '$date', '$mlist', '$email', '$url', '$year', '$make', '$model', '', '$et', '$mph', '$six', '$track', '$engine', '$notes', '', '$pass', '$drive', '$cab', '$length', '', '$aim', '$irc', '$city', '$bday', '$color', '$emods', '$tmods', '$elec', '$hmods', '$bmods', '$app', '$audio', '$user', '$vin')"; echo "sql = ".$sql."<p>"; $result = mysql_query($sql); echo "result = ".$result."<p>"; $myrow = mysql_fetch_array($result); echo "my row = ".$myrow."<p>"; if ($result) { echo "<p><center><B>Thank you!</B><P>Your Member info has been added to the database.</center>"; $sql = "SELECT id FROM memberstest WHERE name=$name AND date=$date AND model=$model"; $result = mysql_query($sql); $myrow = mysql_fetch_array($result); echo "id = ".$id."<p>"; $pic1 = $id.$picture1_name; $pic2 = $id.$upicture1_name; echo "pic1<p>"; if($picture1 == 'none'){ $pic1="na.gif"; } echo $pic1."<p>"; echo "pic2<p>"; if($upicture1 == 'none'){ $pic2="na.gif"; } echo $pic2."<p>"; $sql = "UPDATE memberstest SET $pic1='$pic1' and $pic2='$pic2' WHERE id=$id"; exec("cp $picture1 /var/www/html/members/images/$pic1"); exec("cp $upicture1 /var/www/html/members/images/$pic2"); echo $pic1."<p>"; echo $pic2."<p>"; echo "<head><meta HTTP-EQUIV=\"Refresh\" CONTENT=\"10\" URL=\"http://www.s-series.org/member/detail-wip?".$myrow["id"]."></head>"; Here is what gets echoed to the screen. db = Resource id #1 date 02.20.01 passed requirements sql = INSERT INTO memberstest VALUES ('', 'Kenneth R Zink II', '5095094', 'Texas', 'yes', '02.20.01', 'yes', 'Hellcat1@S-Series.Org', 'http://www.s-series.org/htm/firestorm/firestorm.htm', '1985', 'Chevrolet', 'Blazer', '', '0.000', '0.000', '0.000', '', '3.4L', '', '', '', '2WD', '2 Door', '', '', '', '', 'Spring', '14 December 1976', 'Red', 'See my project page for details.', 'See my project page for details.', 'See my project page for details.', 'See my project page for details.', 'See my project page for details.', 'See my project page for details.', 'this is a test. let\'s see if this goes through.', '', '1gtcs14r3h8515786') result = Warning: Supplied argument is not a valid MySQL result resource in /var/www/html/member/add2-wip.php on line 31 my row = What am I doing wrong??? I can cut and pas Kenneth R Zink II Hellcat1@S-Series.Org ICQ# 5095094 '87 2.8L TBI GMC S-15 Ext. Cab (Hurricane) ...524 in the works !!! http://www.s-series.org/htm/windstorm/project-windstorm.htm '85 3.4L Carbed Chevy S-10 Blazer (FireStorm) ...Soon to be 3.4L SFI DIS !!! http://www.s-series.org/htm/firestorm/firestorm.htm Racing by the Grace of God!!

« previous php.general (#40778) next »