Query met SESSION variabele
Code:
Code (php)
1
2
3
2
3
<?
$query = "SELECT * FROM `members` WHERE `username`= ".$_SESSION['myusername']."";
?>
$query = "SELECT * FROM `members` WHERE `username`= ".$_SESSION['myusername']."";
?>
Alvast bedankt!
Controleer:
- wat geeft echo $query?
- voer je de query wel uit (met mysql_query() oid)
- is er foutafhandeling
- staat error_reporting() goed?
Code (php)
1
2
3
4
5
6
7
2
3
4
5
6
7
<? $link = mysql_connect("localhost",$dbusername,$dbpassword);
mysql_select_db($dbname,$link);
$query = "SELECT * FROM `members` WHERE `username`= ".$_SESSION['myusername']."";
$result = mysql_query($query);
echo $link['Bedrijfsnaam'];
?>
mysql_select_db($dbname,$link);
$query = "SELECT * FROM `members` WHERE `username`= ".$_SESSION['myusername']."";
$result = mysql_query($query);
echo $link['Bedrijfsnaam'];
?>
Heel erg bedankt!