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 mode ); Santino Hello, I have

Full text search

2003-06-15 Thread Nuno Lopes
?? 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've tried: SELECT * FROM 'test' WHERE MATCH (p) AGAINST ('arvor

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

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: MySQL List [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday

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]; MySQL List [EMAIL PROTECTED] Sent: Tuesday, January 07, 2003

Re: [PHP] Re: PHP and MySQL bug

2003-01-07 Thread Nuno Lopes
get. I have read some unfavorable statements about using pconnect with a large number of hits so if it works you should read the comments about it on php.net. Do a search for mysql_pconnect. Larry S. Brown Dimension Networks, Inc. (727) 723-8388 -Original Message- From: Nuno

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 is located - Original Message - From

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,

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, 2003 4:16

Re: PHP and MySQL bug

2003-01-05 Thread Nuno Lopes
Here is the source code: ? @MYSQL_CONNECT(localhost, nlopes, testing) or die(Erro 1); @mysql_select_db(be); $r=MYSQL_QUERY(SELECT n,u,m,h FROM d WHERE id='$id'); if (mysql_num_rows($r)==0) { die (Erro); } else { $re=mysql_fetch_array($r, MYSQL_NUM); $nome=$re[0]; $url=$re[1]; $mirrors=$re[2];

PHP and MySQL bug

2003-01-04 Thread Nuno Lopes
this, Nuno Lopes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL

table relations

2003-01-03 Thread Nuno Lopes
, 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 posting, please

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 too, Thanks

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

Add, modify and delete entries with PHP or Perl

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