Posted by Jim Michaels on 01/11/06 22:52

there probably should be a space after Location: in your header call. I
will insert it. also, after a header() call, it's a good idea to call
exit; I will insert.

"Damien" <gerard@nsecure.nl> wrote in message
news:1135774150.053053.112150@z14g2000cwz.googlegroups.com...
> Ok ik heb dus het volgende script gebruikt alleen krijg ik een error
> melding op regel 17 wat te maken heeft met die SQL query.
>
> <?php
> session_start();
> if (!isset($_POST["submit"])) // checks wheter the page is called using
> the login form
> {
> header("Location: login.html"); // the script sends the user to the
> registration page
exit;
> } else {
> if ($_POST["username"] == NULL || $_POST["password"] == NULL) // check
> wheter both username and password are filled
> {
> echo "<font color=\"red\">Not all fields were filled. Please go <a
> href=\"login.html\">back</a> and fill them</font>";
> } else {
> include("DatabaseConfig.php");
> $usernameexists = mssql_query("SELECT ID FROM tblusers WHERE
> username"=.$_POST["username"]."' &&
> password='".$_POST["password"]."'");
>
> if (mssql_num_rows($usernameexists) != 0)
> {
> $_SESSION["mywebsite_userid"] = mssql_result($usernameexists,'',"ID");
> ?>
> <font color="red">You are successfully logged in.</font><br>
> Go to the secret page: <a href="secret.php">Secret page</a>
> <?php
> } else {
> echo "<font color=\"red\">Wrong combination username/password. <a
> href=\"login.html\">Try login again</a> or <a
>
> href=\"register.html\">register</a></font>";
> }
> mssql_close();
> }
> }
> ?>
>
> De fout zit dacht ik in deze regel:
>
> $usernameexists = mssql_query("SELECT ID FROM tblusers WHERE
> username"=.$_POST["username"]."' &&
> password='".$_POST["password"]."'");
>
> Ik weet niet meer wat ik moet doen :( Deze melding krijg ik:
> Parse error: syntax error, unexpected '=' in
> c:\inetpub\wwwroot\login.php on line 17
>
> Heeft iemand tips of oplossing?
>

[Back to original message]