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 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 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()); 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 Link to comment https://forums.phpfreaks.com/topic/275255-wont-insert/#findComment-1416652 Share on other sites More sharing options...
teynon Posted March 5, 2013 Share Posted March 5, 2013 Look real hard at this: INSERT INTO videotable (title,,description,video) VALUES ('$vidtitle','$viddescrip','$vidvideo') 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! Link to comment https://forums.phpfreaks.com/topic/275255-wont-insert/#findComment-1416657 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.