adamlacombe Posted September 12, 2009 Share Posted September 12, 2009 I have this code: <?php function centercontent() { global $template; if(mysql_num_rows(mysql_query("Select * from video_cat")) == 0){ echo "<div class='error'>Please add a video category first!</div>"; }else{ if($_POST['submit']){ $video_name=clean_up($_POST['video_name']); $video_link=clean_up($_POST['video_link']); $video_des=clean_up($_POST['video_des']); $video_cat=clean_up($_POST['video_cat']); $video_type=clean_up($_POST['video_type']); if(!$video_name || !$video_link || !$video_des || !$video_cat){ echo "<div class='header'>Add A Video</div>"; echo "<div class='error'>Please fill in all fields!</div>"; include ('templates/'.$template.'/footer.php'); exit; }else{ if($video_type == youtube){ $video_link = str_replace("http://www.youtube.com/watch?v=","",$video_link); $video_link = str_replace("http://youtube.com/watch?v=","",$video_link); $video_link = str_replace("&feature=rec-HM-rn","",$video_link); $video_link = str_replace("&feature=related","",$video_link); $video_link = str_replace("&feature=fvw","",$video_link); } if($video_type == dailymotion){ $video_link = str_replace("http://www.dailymotion.com/video/","",$video_link); $video_link = str_replace("http://dailymotion.com/video/","",$video_link); $video_link = str_replace("http://www.dailymotion.com/us/lang/en/video/","",$video_link); $video_link = str_replace("http://dailymotion.com/us/lang/en/video/","",$video_link); } if($video_type == metacafe){ $video_link = str_replace("http://www.metacafe.com/watch/","",$video_link); $video_link = str_replace("http://metacafe.com/watch/","",$video_link); } mysql_query("INSERT INTO video `video_name`='$video_name', `video_link`='$video_link', `video_des`='$video_des', `video_cat`='$video_cat', `video_by`='{$_SESSION['username']}', `video_type`='$video_type'") or die(mysql_error()); echo '<div class="done">Video Added!</div><br />'; } } echo "<div class='header'>Add A video</div>"; echo "<form action='admin.php?action=addvideo' method='post'><div class='content'> <b>Name:</b><br /> <input class='tarea' type='text' name='video_name' size='30'><br /> <b>Link: <small>(URL location of the video)</small></b><br /> <input class='tarea' type='text' name='video_link' size='30'><br /> <small><a style='color:red;'>If its from metacafe.com, please leave off the / at the end of the link</a></small><br /> <b>Description:</b><br /> <textarea class='tarea' name='video_des' rows='5' cols='40'></textarea><br /> <b>Category:</b><br /> <select class='tarea' size='1' name='video_cat'>"; $cat=mysql_query("Select * from video_cat"); while($cat2=mysql_fetch_array($cat)) { $catname=clean_up($cat2[vid_cat]); $catid=clean_up($cat2[vid_id]); print "<option value='$catid'>$catname</option>"; } print "</select><br />"; echo "<b>Video Site:</b><br /> <select size='1' name='video_type'> <option value='youtube'>Youtube</option> <option value='dailymotion'>Daily Motion</option> <option value='metacafe'>Metacafe</option> </select><br />"; echo " <input type='submit' name='submit' value='Add'></div></form>"; } }; $title="$tt_admin_addvideo"; ?> I dont see what could possibly be wrong with it.. but I get this error: 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 '`video_name`='Casting Crowns - Does Anybody Hear Her', `video_link`='uhOJW4Uwy3c' at line 2 Any help would be greatly appreciated, Thanks! Link to comment https://forums.phpfreaks.com/topic/173987-solved-mysql-error-help/ Share on other sites More sharing options...
DEVILofDARKNESS Posted September 12, 2009 Share Posted September 12, 2009 you're supposed todo: INSER INTO databasename('columns') you did INSERT INTO databasename 'columns' Link to comment https://forums.phpfreaks.com/topic/173987-solved-mysql-error-help/#findComment-917158 Share on other sites More sharing options...
adamlacombe Posted September 12, 2009 Author Share Posted September 12, 2009 ok got it. thanks Link to comment https://forums.phpfreaks.com/topic/173987-solved-mysql-error-help/#findComment-917164 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.