newhip Posted March 5, 2013 Share Posted March 5, 2013 i dont understand why my script wont insert can someone help me out per chance? <?php include 'xconnect.php'; $songtitle=$_POST['songtitle']; $songartist=$_POST['artist']; $songsingle=$_POST['single']; $songdescrip=$_POST['songdescription']; $songinsrt=mysql_query("INSERT INTO songtable (title,song,description) VALUES ('$songtitle','$songsingle','$songdescrip')"); $vidtitle=$_POST['videotitle']; $ARTISRS=$_POST['artist']; $vidvideo=$_POST['video']; $viddescrip=$_POST['viddescrip']; $insert=mysql_query("INSERT INTO videotable (title,,description,video) VALUES ('$vidtitle','$viddescrip','$vidvideo')"); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> <link rel="stylesheet" href="uploadstyle.css" type="text/css" /> </head> <div class="supercont"> <body><div id="songupload"><center><h2>SONGS</h2></center> <form enctype="multipart/form-data" method="post" action="uploadstyle.php"> <center><h4>Title:</h4></center><input type="text" name="songtitle" /><br /><br /> <center><h4>Artist:</h4></center><input type="text" name="artist" /><br /><br /> <center><h4>Single:</h4></center><input type="text" name="single" /><br /><br /> <center><h4>Description:</h4></center><center><textarea id="songdescrip" name="songdescription"></textarea></center> <center><input type="submit" name="submit" /></center> </form></div> <div id="videoupload"><center><h2>VIDEOS</h2></center> <form enctype="multipart/form-data" method="post" action="uploadstyle.php"> <center><h4>Title:</h4></center><input type="text" name="videotitle" /><br /><br /> <center><h4>Artist:</h4></center><input type="text" name="artist" /><br /><br /> <center><h4>Video:</h4></center><input type="text" name="video" /><br /><br /> <center><h4>Description:</h4></center><center><textarea id="viddescrip"name="viddescrip"></textarea></center> <center><input type="submit" name="submit" /></center> </form> </div> </div> </div> </body> </html> It wont insert into the videotable but does for others Quote Link to comment https://forums.phpfreaks.com/topic/275255-wont-insert/ Share on other sites More sharing options...
teynon Posted March 5, 2013 Share Posted March 5, 2013 (edited) Among many other things: $songtitle=$_POST['songtitle']; $songartist=$_POST['artist']; $songsingle=$_POST['single']; $songdescrip=$_POST['songdescription']; $songinsrt=mysql_query("INSERT INTO songtable (title,song,description) VALUES ('$songtitle','$songsingle','$songdescrip')") or die(mysql_error()); $vidtitle=$_POST['videotitle']; $ARTISRS=$_POST['artist']; $vidvideo=$_POST['video']; $viddescrip=$_POST['viddescrip']; $insert=mysql_query("INSERT INTO videotable (title,,description,video) VALUES ('$vidtitle','$viddescrip','$vidvideo')") or die(mysql_error()); Edited March 5, 2013 by teynon Quote Link to comment https://forums.phpfreaks.com/topic/275255-wont-insert/#findComment-1416649 Share on other sites More sharing options...
newhip Posted March 5, 2013 Author Share Posted March 5, 2013 its giving me You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'videodescription) VALUES ('','','')' at line 1 still dont get ti Quote Link to comment https://forums.phpfreaks.com/topic/275255-wont-insert/#findComment-1416652 Share on other sites More sharing options...
Solution teynon Posted March 5, 2013 Solution Share Posted March 5, 2013 Look real hard at this: INSERT INTO videotable (title,,description,video) VALUES ('$vidtitle','$viddescrip','$vidvideo') Quote Link to comment https://forums.phpfreaks.com/topic/275255-wont-insert/#findComment-1416654 Share on other sites More sharing options...
newhip Posted March 5, 2013 Author Share Posted March 5, 2013 wow thnx teynon feel like a fool been stressing on this forever! Quote Link to comment https://forums.phpfreaks.com/topic/275255-wont-insert/#findComment-1416657 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.