Browser MMO Video #3

[Chriillzz]

webbrowser.png

[OldRod]

The table name is 'spelare'... your script is looking for 'players'.

[Chriillzz]

Aha that is the swedish word for players so I just thougt I'll put that in. But thanks alot!

[Chriillzz]

Works now.

[OldRod]

Great

[Jackolantern]

Looks like you will have to adjust any English words in the videos to Swedish if that is what you are using in your database. Just remember that what you call your columns in MySQL is exactly what you have to have in your code.

[tehbeasthax]

when i hit submit it says "not able to query for password" which is coming from this snippet of code

Code: Select all

$isaddress="SELECT * from players where email='$email'";
    $isaddress2=mysql_query($isaddress) or die("not able to query for password");
    $isaddress3=mysql_fetch_array($isaddress2);
    if($isaddress3)

My table is players what else could be wrong?

[OldRod]

Make sure you have an 'email' field in your table?

[tehbeasthax]

Fixed it i had E-mail and so i just changed it to email works fine now thanks for telling me to look at the table

[Jackolantern]

That is a constant source of errors for almost all of us, and definitely something to check on when you are getting errors from SQL statements.

My best advice would be to come up with a personal standard and stick to it all the way through the project. I use all lower-case, all run-together (no camel case or Hungarian notation) so as long as I can remember what the words are, I know how I entered them in the database without alt-tabbing back over to it