This error has been bugging me for the past several days. What I want to do is create a register script that varifies that the user inputted fields are original and then submits it to the database and sends an email with the information.

Invalid query: 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 ' password = 'test', alias = 'travisbickle', email =''' at line

Here's that line:
$result = mysql_query("SELECT * FROM game_users WHERE username ='".$username."', password = '".$password."', alias = '".$alias."', email ='".$email."'");
if(!$result) {
die('Invalid query: ' . mysql_error());

That error has stumped me and a few of my friends. Any help would be greatly appreciated!

Try removing all the spaces around the equal (=) signs. That's the only thing I can see there ...

Invalid query: 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 'password= 'test',alias= 'travisbickle',email=''' at line 1

I get that when I remove the spaces between the equal sign.

YOURS
SELECT * FROM game_users WHERE username ='".$username."', password = '".$password."', alias = '".$alias."', email ='".$email."'

Which will fail

MINE
SELECT * FROM game_users
WHERE username ='".$username."'
AND password = '".$password."'
AND alias = '".$alias."'
AND email ='".$email."'");

Spotted the difference?

Well in case not you queried on a couple of params but failed to do the right SQL to get it going. You used a comma seperated list when you need AND instead of , .

Ibbo

ibbo, you rule. I NEVER saw that. And I've been doing MySQL, Oracle and the good 'ol SQL queries for over 5 years ....

Yeah, it's working now. There's a parse error, but I can fix that. I'm not that great at SQL queries.
Foobar, no matter how much experience you have at something. You can still miss some of the simplist things (It's why newer players stomped all over me in Halo 2 ). It's no big deal though, atleast you tried to help.

Thanks again guys

Edit: I found out the parse error.

Your code:
SELECT * FROM game_users
WHERE username ='".$username."'
AND password = '".$password."'
AND alias = '".$alias."'
AND email ='".$email."'");

My new code:
mysql_query("SELECT * FROM game_users
WHERE username ='".$username."'
AND password = '".$password."'
AND alias = '".$alias."'
AND email ='".$email."'");

All I added was $result = mysql_query(". I believe I had to because it was down at the end of the script, but without it at the begining, the php engine wouldn't know how to read it. Well, something like that anyway. I know it's not the only way to fix this kind of error in this situation, but for me it was the easiest.
I just posted that because I mentioned the parse error and I for one think it's annoying when I try to help someone, but end up with a problem and they don't tell me what they did to fix it.