First try at a login script...

[Nathan__02]

im getting this:

mysql error: You have an error in your SQL syntax near 'FROM users WHERE username='l0tt0' AND password='password'' at line 1

i cant figure it out...heres my script

<?php
session_start();
include("config.php");
include("style.css");

$username=$_POST['username'];
$password=$_POST['password'];

echo("<div style='position:absolute; top:100; left:100; width:800'>");

$query=mysql_query("SELECT FROM users WHERE username='$username' AND password='$password'") or die("mysql error: ".mysql_error());


if(mysql_num_row($query) > 0) {
$row=mysql_fetch_array($query);
        session_register('id'); 
        $_SESSION['first_name'] = $row[id]; 
        session_register('username'); 
        $_SESSION['last_name'] = $row[username]; 
        session_register('password'); 
        $_SESSION['email_address'] = $row[password]; 
        session_register('userlevel'); 
        $_SESSION['user_level'] = $row[userlevel]; 

if ($row[userlevel] == 1) {
echo("<a href='/shelta/news.php'>News</a><br>Forums<BR><a href='/shelta/members.php'>Members</a><BR>Options<BR><a href='/shelta/admin.php'>Admin</a><br>");
} else {
echo("<a href='/shelta/news.php'>News</a><br>Forums<BR><a href='/shelta/members.php'>Members</a><BR>Options<BR>");
}
} else {
echo("You could not be logged in!");
}



echo("</div>");

?>

[brad_fears]

You're going to kick yourself, but:

"SELECT FROM" should read "SELECT * FROM"

--Brad Fears

[Nathan__02]

Ok, i thought i tried htat...actually i kno i tried that...neway thnx alot!

[subkida]

I was going to suggest the SELECT * FROM as well, looks like a pretty simpel script though. If you get it to work mind if I use it? I just need somthing simple to check against a password and username before getting to a certain page.

[subkida]

Do you need to be conncted to the Database to call those?

Like including db.php?

Or am I just being a noob? 😃 😉

[matt_4013]

If you're ever using the mysql functions, you have to be connected to a database, using the mysql_connect() and the mysql_select_db() functions 🙂

[subkida]

What he said too! 😉

[BuzzLY]

Just a suggestion...

$row=mysql_fetch_array($query);
session_register('id');
$_SESSION['first_name'] = $row[id];

Don't use the person's first name as the id for their login. It will not be unique. Instead, create another column called first_name, and use the id field for the id the user chooses when they register on your site.

[Nathan__02]

oops...i forgot to change those...was followin the tutorial...neway ya u can use the script...config.php has all my connections BTW