Hello Xavier,
can't you do the transforming of your keywords before doing the query ?
to transform all special characters in php it would be :
$keywords = strtr($keywords,"éè^éëàãâä","_");
add other special characters and a JOKER sign in mysql '_' for each.
Cheers,
Damien
--
Hello,
I have, for the first time, a website to do in several languages.
I'll do a variable replacement whereever needed, with several lang files (as
I've seen so many times in open source PHP applications)
but I am wondering how in sql I could do for translating items' names..
I explain :
I hav
Hello and hope that everybody on this list will pass a wonderful 2003 year,
Here's my worry:
I have 3 tables, one for genre, one for html and one for shockwave
html and shockwave have a foreign key genreID
I want to count for each genre how many html and shockwave entries have the
same genreID, s
Hello,
I have been unable to get a better result than the multiplication of 2
tables where I want the addition.
I explain :
3 tables, one for genre, one for html and one for shockwave
html and shockwave have foreign key genreID
I want to count how many html and shockwave entries have the same genr
Hello, you're right, creating the table with 2 primary keys works fine.
What I was doing is try to convert my personID and carID fields into
primary, and it says:
Error MySQL :
Invalid SQL: ALTER TABLE `varmalinalliax`.`tgl_rel_rest_card` CHANGE
`restID` `restID` INT (11) DEFAULT '0' NOT NULL ,
CH
Hello,
I've tried your way, but my SQL reports error, that I have specified more
than ONE primary key, so I can't do the primary key on both fields. Is that
a mySQL 3.X limitation ? My tables are ISAM.
Following your advice, I've deleted the relation_person_carID, so only
cardID and personID are le
TheTable*ID', but what would be the backdraws when coding
queries and server scripts ?
Any critics on my beginner way of handling relations is most welcome.
Cheers,
Damien COLA
Cordialement,
__ Alliax ~CV : http://LingoParadise.com/cv.php
Un site pour Toulon : http://ww
Sorting by number is not important, it was more a general question about
sequences of "variousnameXXX" and how to order them correctly with a simple
query.
Splitting in 2 fields seems the only way then. For the postcode it's just to
provide the user with an easy lookup table, but it's not *that* im
Hi,
yes, that would do, except that I don't know how many letters are in front
of the numbers.
And since they're not the same letters perhaps ORDER by 1,2 would have done
it perfectly, if only we could substring() intelligently first.
Cheers,
Damien COLA
> -Message d'origine-
> SQL:
> sel
Thank you and Yes, separating the postcodes into field letters and numbers
may be the only way to be able to order a sequence like that:
CV1,CV2,..,CV10,..
It would also work since there could as many letters as needed
Anyone has a simple query for odering sequences correctly ?
Cheers,
Damien COL
Sorry, I forgot to say that postcode can be one or 2 letters in front of the
numbers.
> -Message d'origine-
> They can be E1,E2,..,E12,E13
> Order by name would do:
> E1,E10,E11,E12,E13,E2,E3,E4,...
> how can I get with a simple ORDER BY query
> E1,E2,E3,E4,E5,... ?
-
Hi,
What about if you want to sort UK Postcodes ?
They can be E1,E2,..,E12,E13
Order by name would do:
E1,E10,E11,E12,E13,E2,E3,E4,...
how can I get with a simple ORDER BY query
E1,E2,E3,E4,E5,... ?
Cheers,
Damien COLA
-
Before
Hello, yes I've thought of using less fields, separated by commas, but I'd
like to use much more SQL queries than PHP to process the result.
I have one question : if I go the RestTimes route, that is having a row per
day and so 7 row per restaurants : can I, in one SQL request, know if THAT
restau
Thank you for this and for the previous answer about create temporary table,
your RestTimes is a nice way to do it, but it multiplies the number of rows
of the table.
So you say it's better to have more rows than have less row, when doing
simple select query?
I'll do it your way then, except if so
I am not sure I understand your question, I thought the line you showed
would give proper results (100 total-ordered lines) but maybe :
So there is a similar thread running now, Re: SQL Select Idea [ORDER BY] by
Michael, he says creating a temporary table is the way to go :
"create temporary tabl
Hello,
I have a table of restaurants, I want to store opening times so I can
display in real time if the restaurant is open or not.
What is the optimal way to store the times ?
Since there is no common denominator for opening times, I thought of having
another table with 28 (!!) fields. I'm doubtf
Hello, I am new to the list, I've subscribed in last ressort when I couldn't
find an answer, neither the web or the list archives...
I've had a question from a client that I've answered in this way :
"
> One other question, when you have built the
> database, will it be
> expandable to the size fo
17 matches
Mail list logo
