phpBB.de

Code: Alles auswählen

$sql = "SELECT * FROM `estundenplan_lehrer` WHERE `fach`= 'th'"; 
$result = mysql_query($sql) or die(mysql_error()); 
$row = mysql_fetch_assoc($result); 
echo $row['lehrer'];

Code: Alles auswählen

<?php
//Benˆtigte Dateien und Variablen von phpBB
define('IN_PHPBB', true);
$phpbb_root_path = './phpBB2/';
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);



$leth = mysql_query("SELECT lehrer FROM estundenplan_lehrer WHERE fach='th'");
$lehrerth = mysql_query($leth) or die(mysql_error());

echo($lehrerth);

?>

Code: Alles auswählen

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 'Resource id #17' at line 1

Code: Alles auswählen

<?php 
//Benˆtigte Dateien und Variablen von phpBB 
define('IN_PHPBB', true); 
$phpbb_root_path = './phpBB2/'; 
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); 



$leth = mysql_query("SELECT `lehrer` FROM `estundenplan_lehrer` WHERE `fach`= 'th'"); 
$lehrerth_result = mysql_query($leth) or die(mysql_error()); 
$lehrerth = mysql_fetch_assoc($lehrerth_result);
echo($lehrerth['lehrer']); 

?>

Code: Alles auswählen

#
# Tabellenstruktur für Tabelle `estundenplan_lehrer`
#

CREATE TABLE `estundenplan_lehrer` (
  `fach` varchar(255) NOT NULL default '',
  `lehrer` varchar(255) NOT NULL default ''
) TYPE=MyISAM;

Code: Alles auswählen

$leth = mysql_query("SELECT `lehrer` FROM `estundenplan_lehrer` WHERE `fach`= 'th'"); 
$lehrerth_result = mysql_query($leth) or die(mysql_error()); 
$lehrerth = mysql_fetch_assoc($lehrerth_result); 
echo($lehrerth['lehrer']);

Code: Alles auswählen

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 'Resource id #17' at line 1

Code: Alles auswählen

$leth = mysql_query("SELECT * FROM `estundenplan_lehrer` WHERE `fach`= 'th'"); 
$lehrerth_result = mysql_query($leth) or die(mysql_error()); 
$lehrerth = mysql_fetch_assoc($lehrerth_result); 
echo($lehrerth['lehrer']);

Code: Alles auswählen

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 'Resource id #17' at line 1

Code: Alles auswählen

$lem = mysql_query("SELECT lehrer FROM estundenplan_lehrer WHERE fach='M'");
$rowm = mysql_fetch_row($lem);
$lehrerm = $rowm[0];