XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Q and A 
  4.  / mysql_fetch_array
Register
1
MS-2001
mysql_fetch_array

  • 2004/11/3 15:46

  • MS-2001

  • Quite a regular

  • Posts: 204

  • Since: 2004/7/27


Lets do it quite short:

Code:
$catresult = mysql_query("SELECT * FROM ".$nukeprefix."_forums WHERE type='group'");

while($cat = mysql_fetch_array($catresult)) {

Error:
Warning [PHP]: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in file xoopsforum.php line 21


Why?
2
MS-2001
Re: mysql_fetch_array

  • 2004/11/3 16:21

  • MS-2001

  • Quite a regular

  • Posts: 204

  • Since: 2004/7/27


problem solved.
$nukeprefix was wrong (a upper-case letter instead of a lower-case was in it)
3
Mithrandir
Re:mysql_fetch_array

mysql_query is missing the second parameter (the connection object)

But why not use the $xoopsDB object instead?
4
MS-2001
Re:mysql_fetch_array

  • 2004/11/3 16:22

  • MS-2001

  • Quite a regular

  • Posts: 204

  • Since: 2004/7/27


why should i use it?
its just a script i launche one time in my life
(it converts my old phpnuke 4nforum posts to my new XOOPS newbb2 board ;))
5
Mithrandir
Re:mysql_fetch_array

Ah, I see - then just disregard that comment

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

450 user(s) are online (66 user(s) are browsing Support Forums)

Members: 0

Guests: 450

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Sep 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits