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 Modules Support forums / 
  3. Module usage questions 
  4.  / Xdirectory Alphabetic Order Hack ... need fresh eyes
Register
41
tzvook
Xdirectory Alphabetic Order

  • 2005/3/31 14:24

  • tzvook

  • Just can't stay away

  • Posts: 875

  • Since: 2003/2/1 2


Yep Martijn
Sorry ... Back again, If your'e not despert of it too
Still walking by foot .. the car and all ...

Where were we ?
all seems to act the same ... even with one query (no cat invouved) ...
more ideas ?
42
wtravel
Re: Xdirectory Alphabetic Order Hack ... need fresh eyes

Hope you'll get wheels again soon

About the query, it's the key to the failure. If you cannot get the query to work correct in phpMyAdmin, it will not work in the script either. Why doesn't it work?

SELECT * FROM 'prefix_xdir_link' WHERE title LIKE 'a%'

(table name may be different)

This should only get all titles starting with the letter "a".

Martijn
43
tzvook
Re: Xdirectory Alphabetic Order Hack ... need fresh eyes

  • 2005/3/31 17:49

  • tzvook

  • Just can't stay away

  • Posts: 875

  • Since: 2003/2/1 2


Something is wrong in query, PhpMyAdmin gives me "error" thingy for "

SELECT * FROM 'xoops2_xdir_links' WHERE title LIKE 'a%'
44
wtravel
Re: Xdirectory Alphabetic Order Hack ... need fresh eyes

Sorry, table name should be without quotes.

SELECT * FROM xoops2_xdir_links WHERE title LIKE 'a%'

Martijn
45
artigas
Re: Xdirectory Alphabetic Order Hack ... need fresh eyes

  • 2005/3/31 19:36

  • artigas

  • Quite a regular

  • Posts: 208

  • Since: 2004/12/21


Greetings -

I just tried the following query in phpMyAdmin and it works.

SELECT * FROM `xoops_xdir_links` WHERE title LIKE 'a%'

Note that the single quotes around the table name are different than around the 'a%'.

Hope That Helps.
46
tzvook
Re: Xdirectory Alphabetic Order Hack ... need fresh eyes

  • 2005/3/31 20:53

  • tzvook

  • Just can't stay away

  • Posts: 875

  • Since: 2003/2/1 2


Greets artigas

Query @ MyAdmin gives the same resuts: all 4 first letters (160 results instead of ~ 75).
47
wtravel
Re: Xdirectory Alphabetic Order Hack ... need fresh eyes

I am truly gasping at my screen, not believing my eyes Tzvook What is going on your database?

Which character encoding do you use?

Martijn
48
tzvook
Re: Xdirectory Alphabetic Order Hack ... need fresh eyes

  • 2005/3/31 21:34

  • tzvook

  • Just can't stay away

  • Posts: 875

  • Since: 2003/2/1 2


Quote:

wtravel wrote:
I am truly gasping at my screen, not believing my eyes Tzvook What is going on your database?

Which character encoding do you use?

Martijn



I'm using Hebrew Charset ( charset=windows-1255 ) ...
And it works fine with MySql + php or in general - SQL syntex , works great through XOOPS and XOOPS search
and if you'll look at the begining of our thread you'll find this:

Quote:
Some other people have pointed out similiar problems with WF-Downloads and I never been able to put my finger on it yet (due to the fact that it sometimes works abd sometimes doesn't)

If we find a solution to this issue we will let you know =)

Scott
_________________
Liquid

WF-Projects Team Developer
Home of WF-Sections, WF-Downloads and more.


Which probably means:
1. It's not a Hebrew charset problem ...
2. solution is not trivial ...

49
wtravel
Re: Xdirectory Alphabetic Order Hack ... need fresh eyes

So sorry, but I don't know what could cause this. I would post a topic on a MySQL or phpMyAdmin support site as well. There may be more people there who could know what causes this problem.

Perhaps someone else who reads this knows why the query is also coming up with words starting with another letter than the one selected in the WHERE clause?

Perhaps a workaround would be like the suggested handling in php, to query all records and only return the records where title starts with a '$list'. Let me know if you find another way to solve the root of the problem, which is the database. If there is not, I will have a look on a short workaround in php.

Martijn
50
artigas
Re: Xdirectory Alphabetic Order Hack ... need fresh eyes

  • 2005/3/31 22:14

  • artigas

  • Quite a regular

  • Posts: 208

  • Since: 2004/12/21


Greetings -

While all this is beyond what I already know about PHP and MySQL, all things being the same, has anyone looked at the data in the table itself?

I will make the sugestion that you dump (not sure of how to do this) the data to a text file and have a look to see that it all looks reasonable and that there are no 'unsual' (what would those be?) characters in the data.

At this point this is just a unscientific wild asset guess (UWAG). You can ingore this post if you like.

Hope This Helps.
« 1 2 3 4 (5) 6 7 »

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

132 user(s) are online (88 user(s) are browsing Support Forums)

Members: 0

Guests: 132

more...

Donat-O-Meter

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

Latest GitHub Commits