11
rpclarke
Re: Dev: Database access
  • 2004/11/29 23:30

  • rpclarke

  • Just popping in

  • Posts: 28

  • Since: 2004/11/6


Ok I redid the SQL statement again, and this time it works. *pulls hair out*

$sql = "SELECT `charid`,`character` FROM `xoops_ffxi_manager` WHERE `charid` = 1";

Is the statement I used. picky picky.

Thanks Mith for trying to help me out with this, it is much appreciated!

Is there a configuration for mySql in linux to make it not need the ` in statements?

12
m0nty
Re: Dev: Database access
  • 2004/11/29 23:59

  • m0nty

  • XOOPS is my life!

  • Posts: 3337

  • Since: 2003/10/24


looks like it's not recognising the dbquery function.. maybe u haven't included a file somewhere in the include/require statements so that XOOPS objects are recognised.. (again i'm no php coder) just a learner..

13
Dave_L
Re: Dev: Database access
  • 2004/11/30 0:31

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


The backquotes `` around table names or column names are only needed if those names contain spaces (or possibly other special characters), which is not the case here.

Also, WHERE 'charid' = 1 is not what you want. That's comparing the character string 'charid' with the value 1, not comparing the value of the column charid with the value 1. The character string 'charid' is obviously never equal to 1, so WHERE 'charid' = 1 is equivalent to WHERE 0, which is valid, but produces no output.

Login

Who's Online

242 user(s) are online (159 user(s) are browsing Support Forums)


Members: 0


Guests: 242


more...

Donat-O-Meter

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

Latest GitHub Commits