[PHP] Mysql search query ignoring dots

2011-01-24 Thread Barbara Picci
+POSE' IN BOOLEAN MODE) OR (replace(aziende.ragione_sociale, '.', '') = replace('POSE', '.', '')) order by aziende.ragione_sociale limit 0, 10 The alternative choice could be REGEXP but I've red that it make my query slow in a tabl

[PHP] Re: die function

2005-03-23 Thread Barbara Picci
68.1","user","password") or die(die_script($errmsg)); mysql_select_db ("dbnamei"); Thanks for your help Regards Barbara Barbara Picci wrote: Hi all, I have a machine that must insert in cron in a mysql db in another remote machine. The problem is that I cannot kn

[PHP] die function

2005-03-21 Thread Barbara Picci
Hi all, I have a machine that must insert in cron in a mysql db in another remote machine. The problem is that I cannot know if the connection in the first machine (adsl) go down because no entry in the machine log is generated. I would like to redirect the die function in a e-mail that say me

[PHP] group queries result

2004-09-13 Thread Barbara Picci
Hi all, I've to extract data from a mysql db using two different queries and I must have an unique output sorting them alphabetically. For istance, query1: select * from ads where guest='PK'; count the number of results, make the difference between a given number and the number of results (var

[PHP] group queries result

2004-09-13 Thread Barbara Picci
Hi all, I've to extract data from a mysql db using two different queries and I must have an unique output sorting them alphabetically. For istance, query1: select * from ads where guest='PK'; count the number of results, make the difference between a given number and the number of results (var

[PHP] group queries result

2004-09-13 Thread Barbara Picci
Hi all, I've to extract data from a mysql db using two different queries and I must have an unique output sorting them alphabetically. For istance, query1: select * from ads where guest='PK'; count the number of results, make the difference between a given number and the number of results (var

[PHP] group queries result

2004-09-13 Thread Barbara Picci
Hi all, I've to extract data from a mysql db using two different queries and I must have an unique output sorting them alphabetically. For istance, query1: select * from ads where guest='PK'; count the number of results, make the difference between a given number and the number of results (var

[PHP] help with regular expression

2004-07-29 Thread Barbara Picci
Hi all, I'm trying from much days to solve a problem with a regular expression... I'm going to be crazy! I've a script that must strip a string when it find the first word containing at least 4 characters; it must print the content of the string before that word, that word, a separator and the re