phpBB.de

Code: Alles auswählen

SQL Error : 1064 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' WHERE 'video_id' = '1'' at line 1

SELECT * FROM 'video' WHERE 'video_id' = '1'

Line : 47
File : player.php

Code: Alles auswählen

$video_id = $_GET['video'];

//
//Generate Page
//
$page_title = 'Video-Player';
include($phpbb_root_path . 'includes/page_header.'.$phpEx);



if ($userdata['session_logged_in']){
$sql  = "SELECT * FROM '".video."'";
$sql .= " WHERE 'video_id' = '".$video_id."'";

if (!($result = $db->sql_query($sql))){
 message_die(CRITICAL_ERROR, "Konnte Querrie auf Allgemeine Video-tabelle nicht ausführen!<br><br>Could not querrie video information!", "", __LINE__, __FILE__, $sql);
}

Code: Alles auswählen

$sql  = "SELECT * FROM `video` WHERE `video_id` = intval($video_id)"; 

Code: Alles auswählen

define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);


//Session auslesen und Benutzer-Informationen laden
$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);

$video_id = $_GET['video'];

//
//Generate Page
//
$page_title = 'Video-Player';
include($phpbb_root_path . 'includes/page_header.'.$phpEx);


if ($userdata['session_logged_in']){
$sql  = "SELECT * FROM phpbb2_video";
$sql .= " WHERE 'video_id' = '".$video_id."'";
if (!($result = $db->sql_query($sql))){
 message_die(CRITICAL_ERROR, "Konnte Querrie auf Allgemeine Video-tabelle nicht ausführen!<br><br>Could not querrie video information!", "", __LINE__, __FILE__, $sql);
}
$video_row = $db->sql_fetchrow($result);
 echo "Halloooo:".$video_row['titel']." DE";

}
else {
redirect('login.'.$phpEx);
}


include($phpbb_root_path . 'includes/page_tail.'.$phpEx); 


?>

Code: Alles auswählen

$sql  = "SELECT * FROM phpbb2_video"; 
$sql .= " WHERE video_id = " .$video_id;