Need help with SQL query

[Richardtagger]

Hi guys im a real newbie so i need replies in plain English.

im using

<?php
session_start();
include 'db.php';
$username = $_SESSION['username'];

$sql_username_check = mysql_query("SELECT touser FROM mail WHERE touser='$username");
$mails = mysql_num_rows($sql_username_check);

?>

but i get the error

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/sites/site603/users/sheetshare/web/pmsg/mailscount.php on line 7

I really need a solution to this but my php isnt very good. Thanx guys

[rachel2004]

You are missing a closing single quote after your $username. Try this:

WHERE touser='$username'");

Also, you need a link identifier, which is probably in your include file:

$sql_username_check = mysql_query("SELECT touser FROM mail WHERE touser='$username'", $my_connection);

[Richardtagger]

Thanx alot Rachel

[rachel2004]

You're welcome, Richard.