Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - MySQL newbie syntax question
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

MySQL newbie syntax question

 Post Reply Post Reply Page  <12
Author
freakdaddy View Drop Down
Groupie
Groupie


Joined: 24 January 2008
Status: Offline
Points: 79
Post Options Post Options   Thanks (0) Thanks(0)   Quote freakdaddy Quote  Post ReplyReply Direct Link To This Post Posted: 27 February 2008 at 7:49am
help... still stuck Unhappy
Back to Top
StarDust View Drop Down
Senior Member
Senior Member


Joined: 14 May 2007
Location: Bangladesh
Status: Offline
Points: 310
Post Options Post Options   Thanks (0) Thanks(0)   Quote StarDust Quote  Post ReplyReply Direct Link To This Post Posted: 27 February 2008 at 9:13am
freakdaddy,

If the problem still persists, then there might be some other things wrong. Here is a checklist for you:

1. Make sure the changes you have made in the code of wwf is correct.
2. In some rare occasions, when database is corrupt, i have seen the same error. Try with a fresh database.
3. Make sure GID has a numeric value when executing the SQL statement. Change it from GID = "5" to GID = 5
4. In your code, the value of strDBNoLock might be wrong. Try following SQL statement:

strSQL = "SELECT " & strDbTable & "Author.* " & _
"FROM " & strDbTable & "Author " & _
    "WHERE " & strDbTable & "Author.Author_ID=" & GID & " ;"

This way my problems were gone.



Edited by StarDust - 27 February 2008 at 9:18am
Back to Top
freakdaddy View Drop Down
Groupie
Groupie


Joined: 24 January 2008
Status: Offline
Points: 79
Post Options Post Options   Thanks (0) Thanks(0)   Quote freakdaddy Quote  Post ReplyReply Direct Link To This Post Posted: 28 February 2008 at 1:25am
Thanks..

Yeah, I had done all of the above already. There's something else that's not right, but I don't know enough about mysql to figure it out. It's kind of beyond frustrating because it shouldn't be that difficult. I just want to open the WWF mysql database and from the author_id, or actually the user_code table.

My whole syntax may be incorrect, so just some direction about how you'd set this up to open the database would be very very helpful.


Back to Top
StarDust View Drop Down
Senior Member
Senior Member


Joined: 14 May 2007
Location: Bangladesh
Status: Offline
Points: 310
Post Options Post Options   Thanks (0) Thanks(0)   Quote StarDust Quote  Post ReplyReply Direct Link To This Post Posted: 28 February 2008 at 6:38am
Is everything else is running? The forum? If it is, the solution is unknown to me. Sorry.
Back to Top
freakdaddy View Drop Down
Groupie
Groupie


Joined: 24 January 2008
Status: Offline
Points: 79
Post Options Post Options   Thanks (0) Thanks(0)   Quote freakdaddy Quote  Post ReplyReply Direct Link To This Post Posted: 28 February 2008 at 7:15am
Everything is running 100% fine. I just need to know how to open the database. I've tried everything that I think would be beyond obvious, and I just can't get it to work. 
Back to Top
freakdaddy View Drop Down
Groupie
Groupie


Joined: 24 January 2008
Status: Offline
Points: 79
Post Options Post Options   Thanks (0) Thanks(0)   Quote freakdaddy Quote  Post ReplyReply Direct Link To This Post Posted: 29 February 2008 at 12:46am
Ok, I bet if I say I'll pay someone money I'll get a response.

I need someone to work out this issue, and also pull data from WWF's cookies properly. If someone is interested in doing this, PM me.
Back to Top
 Post Reply Post Reply Page  <12

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.