I just installed phpfanbase for a new fanlisting i had approved, but I get warnings like "Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /admin.php on line 20". this is the first time i've used it, so i'm really confused X___x <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/blink.gif" style="vertical-align:middle" emoid=":blink:" border="0" alt="blink.gif" /><!--content-->
You probably used a number as your table name or possibly a reserved word. Try using letters instead, and not any of the reserved words.<br /><br /> A list of reserved words is <a href="http://www.mysql.com/doc/en/Reserved_words.html" target="_blank">here</a> (scroll down).<!--content-->
I changed it, but its still the same...<!--content-->
What name are you using? or which were you using?<!--content-->
the table name is called members.. it used to be just a whole bunch of numbers<!--content-->
Hmm...You might need to restart the whole install from fresh. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/smile.gif" style="vertical-align:middle" emoid="
" border="0" alt="smile.gif" /><!--content-->
If you are getting the same message for line 25 and also a mysql_fetch_array error towards the bottom of admin.php (above the footer), and the message when you login says something like "You have a total of members, of which are approved" (instead of having numbers, i.e. "You have a total of 50 members, 30 of which are approved"), then your table was probably never created, or the table you did create does not match the name given in config.php<br /><br />That's all phpfanbase v 2.1, if you have a different version then this may not apply..<!--content-->
Remember that your tables may have a predefined prefix depending on how the tables were created.<!--content-->
You probably used a number as your table name or possibly a reserved word. Try using letters instead, and not any of the reserved words.<br /><br /> A list of reserved words is <a href="http://www.mysql.com/doc/en/Reserved_words.html" target="_blank">here</a> (scroll down).<!--content-->
I changed it, but its still the same...<!--content-->
What name are you using? or which were you using?<!--content-->
the table name is called members.. it used to be just a whole bunch of numbers<!--content-->
Hmm...You might need to restart the whole install from fresh. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/smile.gif" style="vertical-align:middle" emoid="
" border="0" alt="smile.gif" /><!--content-->If you are getting the same message for line 25 and also a mysql_fetch_array error towards the bottom of admin.php (above the footer), and the message when you login says something like "You have a total of members, of which are approved" (instead of having numbers, i.e. "You have a total of 50 members, 30 of which are approved"), then your table was probably never created, or the table you did create does not match the name given in config.php<br /><br />That's all phpfanbase v 2.1, if you have a different version then this may not apply..<!--content-->
Remember that your tables may have a predefined prefix depending on how the tables were created.<!--content-->