What is Wrong Here

[DuNuNuBatman]

What is wrong with this query string

$query_string = "SELECT Username, UserPassword, UserPermissions, AdminPermissions, AccountStatus FROM users WHERE Username = '$username' AND UserPassword = '$password'";

[DuNuNuBatman]

In case you wanted to see the whole script here it is

<?php
switch ($query->name) {
	case 'check_user_login':
		$query_string = "SELECT Username, UserPassword, UserPermissions, AdminPermissions, AccountStatus FROM users WHERE Username = '$username' AND UserPassword = '$password'";
		break;
}


// Connect to SQL
$db_connect = mysql_connect ($global->hostname, $global->username, $global->password) or die("Could Not Connect to MySQL.");
// Connect to Database
@mysql_select_db ($global->database);
// Perform Query
$qry_results = mysql_query ($query_string) or die ("Error: Query Error, Please Contact Your Administrator");
?>

[DuNuNuBatman]

Oh, and if you can't see anything wrong with it, you can let me know too 😃

[cvsherri]

at first glance, it looks fine.. what is it doing?

[mrhappiness]

change

$qry_results = mysql_query ($query_string) or die ("Error: Query Error, Please Contact Your Administrator");

to

$qry_results = mysql_query ($query_string) or die (mysql_error().'<hr />'.$query_string.'<hr />');

to get a better error message

[DuNuNuBatman]

Great tip, thanks man. You solved my problem. I didn't have a database selected DOH!!! I thought that might be it. Any way thnks.