hierarchical Structure in Mysql

Hi listErs! I need to design a database, under a hierarchical structure. This Mysql database aims to store a catalog in which I should be able to define: CATEGORIES -> SubCategories -> Sub-SubCategories -> Product the only problem, is that I usually use cascaded indexes, but in this case I sho

Re: Calculating rows in a result set

Got it, Thanks to all of your replies! W.D.F. - Original Message - From: "Cal Evans" <[EMAIL PROTECTED]> To: "Walter D. Funk" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, July 16, 2002 11:44 AM Subject: RE: Calculating rows in a result s

Calculating rows in a result set

Hi everybody, is there a way to calculate the number of rows retrieved by a mysql query, without actually performing it? I want to make a paginated result like in most search engines, and for that I need to display the number of pages the result would have, but I do not want to actually retrieve

Mysql : Problems to make a file dump /n and

Hi, I'm making a CSV from a Mysql table, in which text is stored as is, with all to keep format etc (I need to keep line breaks because the same text has to be printed out in a page taking care of the original fomatting); The problem comes actually when Excell tries to read the CSV (; separates

Mysql SELECT IF()

Hi everybody! I need to count the ACTIVE users of my Mysql users table; where 'active' is a flag showing this status, using the following query it returns all the user in the table, and I need only those who have tha flag active set to 'Y' I know this could be done by using a where clause, but i

Encrypting with PASSWORD() function

Hi, I am trying Mysql Password() function, to encrypt password in a a user/password table, it works fine both ways; it is to say, when I submit a login (user/password) combination it fetches the pair ok. My question is, as I read in the documentation, that the process is irreversible, how can

How can I Sort by Relevance?

I have a query like this select * from PROFILES where UCASE(DESCRIPTION) like '%A%' the result of this will be a set in which any member contains at least an "A", but I'd like to sort them so as the result set becomes like this first: "A" second: "AAA" third: "any string containing an A" and

OT: Please Somebody can explain me what this message means??? Fw: ezmlm warning

Sorry for the length of this message, but, I don´t understand what it means, and why it says my address will be removed from the list without explanation. thanx - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 27, 2002 12:58 AM Subject: ezm

OT: Calculating resources

Hi everybody! I am developing a site under PHP and Mysql which is now in the first steps. My question is, (since I don't administer the server), how can I calculate the resources that the system will need to run as smothly as possible? I mean, for example I am planning to use temporary table to

TEMPORARY TABLES

I´ve just another question, I couldn´t get the info from the manual, I suppose that´s because I don´t know other basics on Mysql .. :-( I´ve been using the temporary table, and it works well, but, I can only display the results set just once in my script, is that normal? I´ve been trying to pagi

Re: UNION

simultaneous connections which create several temporary tables is it posible to knock down the server? thanks in advance - Original Message - From: "David Yahoo" <[EMAIL PROTECTED]> To: "Walter D. Funk" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>

UNION

the same query but for an older engine, like 3.23.33 best regards Walter D. Funk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

Fw: locking specific rows

Hi, I need to implement an access/logging system in mysql+php, which once a user logs in, does not let another individuals log in using the same user-password. I don´t care if users share a user-password, the only thing I want to avoid is that this users sharing the same user-pw combination, don´

Re: Subtracting Dates

Why don´t you try select TO_DAYS(end_date)-TO_DAYS(start_date) as duration : this will return the difference in days if you need mor accuracy i.e. difference in hours, you should word on a TIMESTAMP 14 instead of date ; this data type holds up to seconds and is mathematically easy to operate ... i

Japanese content in Mysql + PHP

HI, does anyone have a clue on how to manage japanese characters in a textfield in MySQL & PHP it works on varchar type fields , defining it as binary; but no way to make it work in a text or blob field thanx - Before pos

Mysql and Japanese Characters

Hi everybody, I need some help !!! does anyone now how to store "japanese" content into mysql ??? I found out that using a VARCHAR field set to binary does seem to work; but how can I manage larger amounts of text, since TEXT data type does not support binary encoding? lease ... or i´ll do h