FUDforum: PHP discussions

Home » General » PHP discussions » help

Show: Today's Messages :: Polls :: Message Navigator

Re: help [message #6653 is a reply to message #6650]

Mon, 21 October 2002 01:23

ezdb

Messages: 158
Registered: May 2002
Location: china

Karma:

Senior Member

yes I agree with you !

I only want to find a way(search) to fix data structure like fud

fud is splited a message with " " and insert the word to fud.search!

but when you write with chinese ," " isn't be used!

so I must change the type of "word" from varchar(255) to TEXT,and save all the msg to the field

because it is no space ,the msg may be like this "abc,def.g....."

so I have three way to do this

1.save all msg to the field (type is text)
2.splited msg with "," or "." or ":"....... and save the sentence to the field (type is varchar)

sql:

select * from fud.search where word like '%bc%' or word like '%de%'

select * from fud.search where word like '%bc%' and word like '%de%'

3.splited msg with each letter(chinese is multibyte languages),and save the letter to the field(type is varchar).

sql:
used the fud's method

Report message to a moderator

[Message index]

		help By: ezdb on Thu, 05 September 2002 06:34
		Re: help By: Ilia on Thu, 05 September 2002 14:17
		Re: help By: ezdb on Fri, 06 September 2002 00:43
		Re: help By: ezdb on Fri, 06 September 2002 01:27
		Re: help By: Ilia on Fri, 06 September 2002 03:03
		Re: help By: valiant on Sun, 20 October 2002 23:52
		Re: help By: ezdb on Mon, 21 October 2002 01:23
		Re: help By: valiant on Mon, 21 October 2002 10:15
		Re: help By: valiant on Mon, 21 October 2002 22:40
		Re: help By: ezdb on Tue, 22 October 2002 01:14

Previous Topic:	the ? operator
Next Topic:	OOP php

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 13:51:54 GMT 2024

Total time taken to generate the page: 0.05174 seconds