On Sat, 20 Oct 2001, Clyde Jones wrote:
Did you try that? replace should recursively replace ALL double spaces,
if it is a problem just run and rerun the query
UPDATED hotel
set nome_hotel replace(nome_hotel, , )
until all the double spaces are gone.
Ok. I tried it but of no use.
) and carriage returns (\r) with a space, and repeat the above.
And from now on, make sure the data gets put in right :)
Well that would only get the first two spaces. I do not know how many
spaces are there
Adrian
Steve Meyers
-Original Message-
From: Adrian D'Costa
Neil [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 18, 2001 4:46 AM
To: Adrian D'Costa; Mysql Mailing List
Subject: Re: how to get the correct result -- Thrid Time --
You didn't appear to answer last time (grump) - reply repeated below.
=dn
- Original Message
are there.
Adrian
On Fri, 19 Oct 2001, Adrian D'Costa wrote:
| Date: Fri, 19 Oct 2001 10:43:31 +0530 (IST)
| From: Adrian D'Costa [EMAIL PROTECTED]
| To: Clyde Jones [EMAIL PROTECTED]
| Subject: Re: how to get the correct result -- Thrid Time --
|
| Hi,
|
| Thanks. It gave an error but it work
On Thu, 18 Oct 2001, Jani Tolonen wrote:
Adrian D'Costa writes:
If you 'office system' is, for example, Sun Solaris, you will see only
1 mysqld process with 'top'. The fact that in Linux 'top' shows
actually more than 1 process can be regarded as a bug in the way 'top'
shows
Hi,
I have some records that I need to group by a field. This is easy using
group by in the sql statement. What I happening is that I get some data
in html format that I have written a script that will extract the data I
require an dump it into a table. Everything working fine. The problem
On Wed, 17 Oct 2001, Jani Tolonen wrote:
Adrian D'Costa writes:
Hi,
I have been using Mysql that was provided on my RH7.0 cd. It works on my
office system and it shows only one process. The same thing I installed
on my home system, it show 4 processes one safe_mysqld and other
On Sat, 29 Sep 2001, Benjamin Pflugmann wrote:
Hi.
On Sat, Sep 29, 2001 at 12:43:25PM +0530, [EMAIL PROTECTED] wrote:
[...]
I am trying the below sql statement:
select na.id as naid, na.nid, na.date from newsarticles na, newscodes nc
where na.nid=nc.id and na.nid=1 or na.nid=3 or
-Original Message-
From: Adrian D'Costa [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 21, 2001 12:56 AM
To: Mysql Mailing List
Subject: last week, this week
Hi,
I have a table that hold a lot of information about pricing and dates. I
would like to list the of differnce
Hi,
I have a table that hold a lot of information about pricing and dates. I
would like to list the of differnce of prices between last week and this
week.
Adrian
-
Before posting, please check:
Hi,
I am trying the below sql statment:
mysql select c.city, t.periodo, t.vitofferta from travel t, city c where
t.cityid=c.id and t.periodo2001-07-20 and
month(t.periodo)=month(2001-07-20) and
YEAR(t.periodo)=YEAR(2001-07-20) and rand() limit 7;
The result:
Hi,
I am trying the below sql statment:
mysql select c.city, t.periodo, t.vitofferta from travel t, city c where
t.cityid=c.id and t.periodo2001-07-20 and
month(t.periodo)=month(2001-07-20) and
YEAR(t.periodo)=YEAR(2001-07-20) and rand() limit 7;
The result:
/rc.d/mysql stop
I had the same problem on a cobalt raq
running a variant of red hat and that
solved it.
Sean
-Original Message-
From: Adrian D'Costa [mailto:[EMAIL PROTECTED]]
Sent: 17 July 2001 08:32
To: Mysql Mailing List
Subject: mysql error
Hi,
I just installed
Hi,
I just installed a new version of mysql (not the latest) 3.23.36 which
came with rh 7.1 cd. I know that it is buggy but I have the following
problems that have been discussed in the list. I search the archives but
did not see how the problem got solved.
The error:
ERROR 2002: Can't
On Fri, 22 Jun 2001, Thomas J Keller wrote:
select zip, city, county from zipcodes where zip between 68400 and 68500;
here is a portion of the garbled output:
|68442 | STELLA | RICHARDSON
|43 | STERLING | JOHNSON
|444 | STRANG | FILLMORE
|5 |
Hi,
On Wed, 20 Jun 2001, Benjamin Pflugmann wrote:
This is my sql statement:
mysql select count(*),travel.nome_hotel,travel.tour_operator,
city.city,travel.vitofferta from travel,city where city.id=travel.cityid
group by travel.nome_hotel limit 5;
The result:
Hi,
Thanks for assisting me in my earlier query. I never had the time to try
it out as my office needs keep changing. In connection to my earlier
question, this is just an extension :) The hotel names repeat in the
travel table.
My travel table's required fields from the hotel table are:
the rows. I need to update the travel table with
the id of hotel table based on the hotel names being the same.
TIA
Adrian
-Original Message-
From: Adrian D'Costa [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 14, 2001 1:49 AM
To: Mysql Mailing List
Subject: how do I do
Hi,
I have two table:
mysql select * from hotel limit 10
- ;
+++
| id | hotelname |
+++
| 1 | Adams Beach|
| 2 | Aegean Village |
| 3 | Angela |
| 4 | App. in Ayja |
| 5 | Apt Alfaga |
| 6
Hi Benjamin,
On Wed, 13 Jun 2001, Benjamin Pflugmann wrote:
Sounds as if you have to install a newer MySQL package. Use
Seems like. Which is the stable version now?
rpm -qf /usr/lib/mysql/libmysqlclient.so.9.0.0
The result mysql-3.23.22-6
Or compile it yourself. ;-)
That is my last
Hi,
My setup
MySQL version : Ver 8.8 Distrib 3.23.22-beta
OS : RH 7.0
I downloaded MyODBC-2.50.37-1.i386.rpm from mysql's site but when I tried
to install it, give this error:
libmysqlclient.so.10 is needed by MyODBC-2.50.37-1
In /usr/lib/mysql I have the following entries
the submit button is pressed.
On the next php file I do the following:
$tname =urldecode($name);
$tname1 = stripslashes($tname1);
$updtStmt = update vusers set orgname='$tname1' where id=$tid;
This works fine, but suppose in by table I have a name Adrian D'Costa
This starts all the problems. I
On Fri, 8 Jun 2001, Gabriele Bartolini wrote:
$tname =urldecode($name);
$tname1 = stripslashes($tname1);
$updtStmt = update vusers set orgname='$tname1' where id=$tid;
It all depends on these 2 variables settings:
magic_quotes_gpc= On
magic_quotes_runtime= Off
I
On Fri, 8 Jun 2001, Rolf Hopkins wrote:
- Original Message -
From: Adrian D'Costa [EMAIL PROTECTED]
To: Mysql Mailing List [EMAIL PROTECTED]
Sent: Friday, June 08, 2001 13:59
Subject: php/mysql question
Hi,
I am not sure whether this relates to this list
database,sql,query
On Fri, 8 Jun 2001, Gabriele Bartolini wrote:
magic_quotes_gpc = On ; magic quotes for
incoming GET/POST/Cookie data
And, what about: magic_quotes_runtime ?
Off.
Adrian
On Wed, 6 Jun 2001, Ian Ford wrote:
Name your config file config.inc and if any of the below situations
happen your password and username will not show up in plain text for the
casual browser.
(EXAMPLE:
CONFIG.INC
?
$DBname = 'test';
$DBuser =
Thanks,
Will try that out.
Adrian
On Thu, 31 May 2001, g_gosho wrote:
You can try this link: http://www.bonev.com/s
there is PHP session handling librarary and documentation how to use it
- Original Message -
From: Adrian D'Costa [EMAIL PROTECTED]
To: php general list
Hi,
I am trying to use session instead of cookies as my targeted customers are
either behind a firewall or disable cookies.
My system
php 4.0.1pl2
rh 7.0
What would be the best way to use a session. I a database to store
the session id and then delete it on exit or expiry. I hope someone can
On Wed, 23 May 2001, Don Read wrote:
!-- end --
/script
form
?php
while($row = mysql_fetch_object($result))
Do you plan on executing a mysql_query() some time before this ?
Actually it is executed before this. This scripts works fine on my local
host running php 4.0.1pl2.
On Mon, 21 May 2001, indrek siitan wrote:
order by rand() didn't work back in 3.22.
if i remember correctly (if this doesn't work, you can try to search
the list archives), the workaround was:
SELECT col1,col2,RAND() as r FROM table ORDER BY r LIMIT 1;
Thanks. Now I am into another
Hi,
I have four table that have common fields like: date, destinazione and
price.
I what to create a temporary table with all four fields from four tables,
what would be the correct sql syntax.
TIA
Adrian
-
Hi,
I have been trying this on my localhost and this works
select special.contid, special.cityid, special.curr1, special.catalogo,
special.hf, special.curr2, special.vitofferta, special.fh, special.club,
special.stars, city.city from special,city where
DATE_SUB(special.periodo, INTERVAL 3
Hi,
I have the following tables:
Country:
id | int(5) | | PRI | NULL| auto_increment |
country | varchar(35) | | MUL | ||
contid | int(5)
City:
id| int(5) | | PRI | NULL| auto_increment |
city | varchar(35) | |
On Thu, 12 Apr 2001, ilker YILDIZ wrote:
Install MyODBC
Adrian
Hi,
I want connect mysql databse with ms front page 200.
How?
What do i?
Thanks.
-
Before posting, please check:
http://www.mysql.com/manual.php (the
In your odbc setup did you give the host name that you defined on the
linux box?
Adrian
On Wed, 11 Apr 2001, Fenn Rider wrote:
I am trying to get myODBC working on an NT 4.0 ws, sp6a client, connecting
to a MySQL db running on a linux box. When I try to connect, I get a dialoge
that says:
I think you need myODBC.
Adrian
On Tue, 10 Apr 2001, Daniel Chase wrote:
I have just installed version 3.23.36 on an Intel running windows 2000
Pro.
I am trying to use MS Access as a front end but can not get a connect
string to recognize the mysqld server.
My event viewer is showning
Usually it is not in the folders that are listed below. It is in one of
the server's folder that you don't usually have access to view.
Since you have only ftp you need to install phpMyAdmin from phpMyAdmin.net
on your server, htdocs.
Export your database using mysqldump dbname somename.sql
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
What did you do to get the error
Adrian
On Fri, 30 Mar 2001, Lebrun Jonathan wrote:
What's error 1062 ?
Thanks.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.2 (GNU/Linux)
Comment: For info see http://www.gnupg.org
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
What are the results you expect. There are always workarounds
Adrian
On Fri, 30 Mar 2001, Ramasamy Palaniappan wrote:
Sir,
created the following tables as primary and secondary
primary : partycode(primary key),partyname
secondary :
I know this question is not related here, but while on the Oracle
Question, could someone tell me how to install Oracle for Linux of the
list :)
Adrian
On Thu, 29 Mar 2001, Freaked Personality wrote:
Yea oracle has been ported for a while already, been running it for like 6
months on SuSE
First of all, since you are not a programmer, it is going to be
difficut. I have done something similar but for a travels site using php
and mysql. I suggest you send me a private mail I will help you if I can
Adrian
I've got mysql and php installed on my server and i was wondering if
anyone
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sun, 19 May 2002, Luis wrote:
#mysqladmin -u root -p password 'newpassword'
or
#mysqladmin -u root password 'newpassword'
i got a error. but when i tried the 2 one it work. But in the manual it says to do
the top one
I'm
I think that you would have got the answer by now, but initally mysql does
not need a password. You can just login without the password, then change
it using mysqladmin newpassword.
Adrian
On Fri, 9 Mar 2001, Luis wrote:
I read the manual plus look on the site. I been having trouble
based on the one selected from the country drop down. I do not want
to use a submit button. I use a javascript and using onChange pass the
country.id to the javascript but do not know how to pass it back to the
php script. Any pointers
Adrian
--
===
Adrian D'Costa
[EMAIL
78 records, when I do insert
|secondly, it dispalys 58th record firstly and others in reverse order.
|Anybody know why? (I use PHP script)
Depends on what way you have set up your script.
--
===
Adrian D'Costa
[EMAIL PROTECTED]
www.pcsadvt.com
45 matches
Mail list logo