Hi, i am so annoyed at the moment, i have a query that appear to refuses to run and goes straight to the die command. session_start(); session_register('auth'); session_register('logname'); include("it.inc"); switch (@$do) { case "login": $connection = mysql_connect($host, $user,$password) or die ("Couldn't connect to server."); $db = mysql_select_db($database, $connection) or die ("Couldn't select database."); $sql = "SELECT loginName FROM members WHERE loginName='$logname'"; $result10 = mysql_query($sql) or die("Couldn't execute query.problem"); $num = mysql_num_rows($result10); if ($num == 1) // login name was found { $sql = "SELECT loginName FROM members WHERE loginName='$fusername' AND password=password('$fpassword')"; $result2 = mysql_query($sql) or die("Couldn't execute query."); $num2 = mysql_num_rows($result2); if ($num2 > 0) // password is correct { $auth="yes"; $logname=$fusername; $today = date("Y-m-d h:m:s"); $sql = "INSERT INTO login (loginName,loginTime) VALUES ('$logname','$today')"; mysql_query($sql) or die("Can't execute query."); header("Location: Member_page.php"); i know that the database must be beeing seen as these point give no errors, however when the query runs to.... $sql = "SELECT loginName FROM members WHERE loginName='$logname'"; $result10 = mysql_query($sql) or die("Couldn't execute query.problem"); i just get the die output. all the variables are correct, all the table names are correct, i just dont know whats going on, can anyone spot anything with this, or tell me a different/better way of doing it. Many thanks with this. Ian Howdy

It would be helpful to see mysql's error here, and the final sql query: $result10 = mysql_query($sql) or die("Couldn't execute query.problem: $sql ".mysql_error()); See what that outputs and get back to us. -SN

hey thanks for this bud, im really stuck here, heres that output u wanted, if it helps loginName is a valid field it is a varchar (20) and also the primary key. thanks again. oh and dave21 is in the table in this field, ive just checked manually. cheers Couldn't execute query.problem: SELECT loginName FROM members // 19 WHERE loginName='dave21' 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 '// 19 WHERE loginName='dave21'' at line 1 Howdy

Salts- Somehow, an extra "// 19" is coming in between members and WHERE, and that's screwing it all up. Is the code exactly as posted? No comments in there? This one has got me stumped...I can't see where that // 19 is coming from. The only thing I can think of is to put the sql query all on one line so there's no line break between members and where. Good luck, -SN

thanks man, ill give this a go. the //19 is coming from the end of lines of code, i have many of them going down with my code as a guide, i never thought it would be interfering. Ill get rid of them all now, they aint worth it:) Ill let u know how it turns out. thanks again. Howdy

Yo man, it worked, i really owe u for this, i would have never have got this going if it were not for this forum and ur help. im doing a really big project for my university work and i needed this bad. Thanks again man, many many thanks. Howdy