php error in sql

[djwouter]

dit is de foutcode....

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 'kamp ORDER BY id DESC' at line 1

dit is mijn php code....

$linkinbox = mysql_connect("localhost", "$username", "$password");
mysql_select_db("$database", $linkinbox );

$resultinbox = mysql_query("SELECT * FROM berichten_inbox WHERE ontvanger = " . $_SESSION['user_name'] . " ", $linkinbox );
$num_rowsinbox  = mysql_num_rows($resultinbox );

$resultoutbox  = mysql_query("SELECT * FROM berichten_inbox WHERE verzender = " . $_SESSION['user_name'] . " ", $linkinbox );
$num_rowsoutbox = mysql_num_rows($resultoutbox );

wat is er mis ?


hij mag trouwens ook geen foutmedling geven als er geen rijen zijn gevonden.... iemand een tip (A)

 

[Dinux]

$linkinbox = mysql_connect("localhost", "$username", "$password");
mysql_select_db("$database", $linkinbox );
 
$resultinbox = mysql_query("SELECT * FROM berichten_inbox WHERE ontvanger = '" . $_SESSION['user_name'] . "' ", $linkinbox );
$num_rowsinbox  = mysql_num_rows($resultinbox );
 
$resultoutbox  = mysql_query("SELECT * FROM berichten_inbox WHERE verzender = '" . $_SESSION['user_name'] . "' ", $linkinbox );
$num_rowsoutbox = mysql_num_rows($resultoutbox );

Waarschijnlijk moet je ff '' toevoegen. Kijk of het bovenstaande werkt.

 

[Tha Devil]

Lijkt mij sterk dat de foutmelding uit deze code komt.

Nergens zie ik iets van een ORDER BY

 

[cars]

$linkinbox = mysql_connect("localhost", "$username", "$password");
mysql_select_db("$database", $linkinbox );
 
$resultinbox = mysql_query("SELECT * FROM berichten_inbox WHERE ontvanger = '" . $_SESSION['user_name'] . "' ", $linkinbox );
$num_rowsinbox  = mysql_num_rows($resultinbox );
 
$resultoutbox  = mysql_query("SELECT * FROM berichten_inbox WHERE verzender = '" . $_SESSION['user_name'] . "' ", $linkinbox );
$num_rowsoutbox = mysql_num_rows($resultoutbox );

kan worden, niet dat het wat uitmaakt wat hier staat idd geen order by tussen.

$linkinbox = mysql_connect("localhost", "$username", "$password");
mysql_select_db("$database", $linkinbox );
 
$resultinbox = mysql_query("SELECT * FROM berichten_inbox WHERE ontvanger = ' " . $_SESSION['user_name'] . " ' ");
$num_rowsinbox  = mysql_num_rows($resultinbox );
 
$resultoutbox  = mysql_query("SELECT * FROM berichten_inbox WHERE verzender = ' " . $_SESSION['user_name'] . " ' " );
$num_rowsoutbox = mysql_num_rows($resultoutbox );