Re: Video#3
Posted: Mon Feb 01, 2010 7:01 pm
Page 4 of 8
Re: Video#3
Posted: Mon Feb 01, 2010 9:16 pm
The table name is 'spelare'... your script is looking for 'players'.
Re: Video#3
Posted: Mon Feb 01, 2010 9:34 pm
Aha that is the swedish word for players so I just thougt I'll put that in. But thanks alot!
Re: Video#3
Posted: Mon Feb 01, 2010 9:38 pm
Works now.
Re: Video#3
Posted: Mon Feb 01, 2010 9:41 pm
Great 
Re: Video#3
Posted: Mon Feb 01, 2010 10:42 pm
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.
Re: Video#3
Posted: Thu Feb 25, 2010 6:53 pm
when i hit submit it says "not able to query for password" which is coming from this snippet of code My table is players what else could be wrong?
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)Re: Video#3
Posted: Thu Feb 25, 2010 7:16 pm
Make sure you have an 'email' field in your table?
Re: Video#3
Posted: Thu Feb 25, 2010 7:32 pm
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
Re: Video#3
Posted: Thu Feb 25, 2010 11:00 pm
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
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