Full text search

2003-06-15 Thread Nuno Lopes
. Ex.: %word% works but not word%. Can anybody help me, please?? Thanks, Nuno Lopes -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Full text search

2003-06-15 Thread Nuno Lopes
> On Sunday, June 15, 2003, at 01:36 PM, Nuno Lopes wrote: > > > I have a table with just one column and with 1000 rows. It's indexed > > using > > full text. > > I've tried MATCH with AGAINST and LIKE and nothing works right! > > > > I'v

Re: Full text search

2003-06-16 Thread Nuno Lopes
Sorry... I read mysql page and I read that is need mysql 4 and my server only has mysql 3.23.51!!! I'll try to contact my ISP in order to they update the server. Thanks all, Nuno Lopes > SELECT * FROM 'test' WHERE MATCH (p) AGAINST ('arvor*' in boolean mo

table relations

2003-01-03 Thread Nuno Lopes
n PHP, if it's matters). I want to print all musics from a specific country (first table) using the artist in second table. Can you help me building the SQL statement, please? Thanking in avance, Nuno Lopes - Before posti

PHP and MySQL bug

2003-01-04 Thread Nuno Lopes
'"); --- I don't know why is this? Because I'm used to do more than a query per connection and this never happened! I'm using Win 2k, Apache 2.0.43, MySQL 3.23.49-nt and PHP 4.3. I hope you solve this, Nuno Lopes -

Re: PHP and MySQL bug

2003-01-05 Thread Nuno Lopes
Here is the source code: Seleccione a localização para o download:Localização Principal"; if ($mirrors) { echo " Mirrors"; $m=explode("»",$mirrors); foreach ($m as $v) { $m2=explode("!",$v); echo "$m2[0]"; } echo "Nota: Deve escolher o mirror mais próximo da sua localização, para acelerar o dowloa

Re: [PHP] Re: PHP and MySQL bug

2003-01-06 Thread Nuno Lopes
I done a echo of Mysql_error and it returned: 'Nenhum banco de dados foi selecionado' (I have the mysql server in portuguese, but the translation is something like 'no db was selected') - Original Message - From: "David Freeman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, J

Re: PHP and MySQL bug

2003-01-06 Thread Nuno Lopes
The problem is if I close the connection and reopen it the query is done, but if I remain with the same connection has the previous query, mysql returns an error. - Original Message - From: "Larry Brown" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Sunday, January 05, 20

Re: [PHP] Re: PHP and MySQL bug

2003-01-07 Thread Nuno Lopes
n Networks, Inc. > (727) 723-8388 > > -Original Message- > From: Nuno Lopes [mailto:[EMAIL PROTECTED]] > Sent: Monday, January 06, 2003 1:09 PM > To: MySQL List; [EMAIL PROTECTED] > Subject: [PHP] Re: PHP and MySQL bug > > The problem is if I close the connecti

Re: [PHP] Re: PHP and MySQL bug

2003-01-07 Thread Nuno Lopes
I'm using Windows 2000. - Original Message - From: "Cleber" <[EMAIL PROTECTED]> To: "Nuno Lopes" <[EMAIL PROTECTED]> Sent: Tuesday, January 07, 2003 10:23 AM Subject: Re: [PHP] Re: PHP and MySQL bug > Try add to /etc/hosts the name and ip of DB

Re: [PHP] Re: PHP and MySQL bug

2003-01-08 Thread Nuno Lopes
@mysql_select_db("be"); // this doesn't fail, because only the second (UPDATE) query fails. The first query (SELECT) is done! - Original Message - From: "Marek Kilimajer" <[EMAIL PROTECTED]> To: "Nuno Lopes" <[EMAIL PROTECTED]> Cc: &quo

Re: [PHP] Re: PHP and MySQL bug

2003-01-08 Thread Nuno Lopes
Doesn't you have any simpler answer?? Maybe installing the new version of mysql server - I have version 3.23.49 - should do the trick - Original Message - From: "Larry Brown" <[EMAIL PROTECTED]> To: "Nuno Lopes" <[EMAIL PROTECTED]>; "MyS

version 4 or 3

2003-01-11 Thread Nuno Lopes
Hi, I would like to know what are the main differencies between the version 4 and and version 3 of mysql. I heard that sql changed in mysql 4. Is this true?? Must I change my existing programs to update the queries?? Thanking in advance, Nuno Lopes

add a new column

2001-09-08 Thread Nuno Lopes
Hi everybody, I have an answer. Can you answer it?? Thanks! Here is it: I have a db in mysql (off course!) with a lot of data. Can I add a new column (a new variable) to an existing table??? If yes, what's is the sql query?? Thanks! Thanking in Advance, Nuno Lopes P.S.: When you reply t

copying information

2001-09-17 Thread Nuno Lopes
Dear Sirs, I have a database with a lot of information. Can I copy that information to another server??? It's because I'm gonna change of hosting company!!! (I use PHP and Perl) Thanking in advance, Nuno Lopes P.S.: When you reply to the list, reply to me t

Add, modify and delete entries with PHP or Perl

2001-02-10 Thread Nuno Lopes
ECTED] | --- Thanking in advance, Nuno Lopes P.S.: When you reply to the list, reply to my e-mail ([EMAIL PROTECTED]), too, please...