Welcome to the Gamebase 64 forums.                 An attempt to document ALL Commodore 64 gameware before it's too late!

Advanced search form: single quotes trouble!

This is the place for your GB64.COM feature requests and bug submissions!

Moderator: Jimbo

andreas2
Keen Member
Keen Member
Location:        ...ADVENTURE GUY...
Posts: 116
Joined: Sun Sep 21, 2003 9:16 am

Advanced search form: single quotes trouble!

Tue Jun 05, 2007 10:41 am

Yes there are indeed some publishers which do have single quotes in the name, e. g. the German mag "64'er":
(and in case you didn't know, this is what has been confusing mySQL from its "birth")

- Go to Advanced Search
- Enter "64'er" (without double quotes) into the Publisher field
- Press "Go" button

You'll get over 450 results.

Now go to page 1, 2, 3 >>> boom.
You'll get "search returned no games" and the publisher field will show a whopping sort of "64\\\\\\\'er" text.

Would be nice if this could be fixed. Thanks.
andreas2
Keen Member
Keen Member
Location:        ...ADVENTURE GUY...
Posts: 116
Joined: Sun Sep 21, 2003 9:16 am

Fri Aug 15, 2008 1:13 am

Bumped. Got a whopping 2700+ views on this, but no fix yet.
Please... 8)
Brataccas
Keen Member
Keen Member
Posts: 157
Joined: Thu Aug 12, 2004 1:53 am

Fri Aug 15, 2008 1:54 am

It looks like the problem is in the routine that accepts input from the web form.. this would be whatever inserts those backslash characters and prints "Alpha-numeric characters only please!"

The SQL query works perfectly fine. For example, here is the link for the fourth page:

http://www.gb64.com/search.php?a=6&adv_ ... 18&h=0&p=3

Chage that last value "p=3" to "p=5" to get to the sixth page, etc.
andreas2
Keen Member
Keen Member
Location:        ...ADVENTURE GUY...
Posts: 116
Joined: Sun Sep 21, 2003 9:16 am

Sun Aug 17, 2008 1:24 pm

thanks, but I know of this ugly workaround already ;)

it is very awkward to advance pages that way, so what is needed is a proper fix!

usually it also happens that the backslashes are added up to the URL, which also explains that there are no results anymore after a couple of sub-pages!

Return to “The GB64 Website”

Who is online

Users browsing this forum: No registered users and 59 guests