Try to search in keyword table:
select * from keywords WHERE MATCH(keyword_txt) AGAINST
('$radio_keyword' IN BOOLEAN MODE);
If it works the problem is in the join.
Santino
$query = SELECT page.* FROM `page` LEFT JOIN `keywords` USING
(`page_id`) WHERE MATCH (`keywords`.`keyword_txt`) AGAINST
Hi!
On Oct 15, Jason McManus wrote:
Good afternoon,
I have had reason to use the new (as of 4.1.1) INSERT .. ON DUPLICATE KEY
UPDATE syntax in MySQL. However, I am a bit confused as to the return
value. Issuing the INSERT .. ON DUP KEY UP statement, upon finding a
duplicate key and
My statements are all working but I'm not sure if
things are set up correctly. I say this because at
one point the first $query failed, yet the rest of
inserts wre committed. Now I believe I need to set
autocommit to 0 , yet the query failed due to a syntax
error. Hence the rule about 0 records
I just noticed that a restricted user to only one database can still run
show databases;
and see all the names of the databases in MySQL.
You would think that it would only return the databases that that user
is allowed to connect to.
Is there a way I can show only those databases that he has
You have a problem, what if the first insert give a error, then you
don't know. You have to check each statement for error and if no error
if found in all the statements then issue a commit if not a rollback
Osvaldo Sommer
-Original Message-
From: Stuart Felenstein [mailto:[EMAIL
Thank you Osvaldo, That is what I was thinking.
Sometimes when you try to learn from example or manual
it's a bit unclear because they generally show a
simple transaction (1 insert into 1 table)
Stuart
--- Osvaldo Sommer [EMAIL PROTECTED] wrote:
You have a problem, what if the first insert
On Fri, 15 Oct 2004 20:05:57 -0400, leegold [EMAIL PROTECTED]
said:
On Fri, 15 Oct 2004 15:00:10 -0700, Chris W. Parker
... But maybe there's a better way? I
wish I could do *searchstring* in Fulltext even if the speed was slow as
molasass it's the spec the user wants.
Of course
Hello all,
I have a remote server that has a harddrive almost full. Therefore I
need to dump a huge table to my other host.
OK, I've set the permissions so that I can log in to the server as root
from my host. I've try to connect to it and it works.
I have to do the dump to the host because the
- Original Message -
From: Skip Taylor [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, October 16, 2004 5:08 PM
Subject: Can MySQL do this?
Hello,
I'm new to MySQL, SQL in general and even PHP which may be needed to do
this.
My intention is to implement this on an Internet
...snip
Is there a database generation system that would be able to handle this
task and generate a webpage as output?
Try, AMP [Apache-MYSQL-PHP]
See the tutorial,
http://www.devarticles.com/c/a/Apache/Installing-PHP-under-Windows/
This tutorial is helpful. It's geared to MS Windows, so
Your tables aren't setup very well. You should google for
normalization and 'boyce codd normal form'
-Eric
On Sat, 16 Oct 2004 22:27:51 +0200, owca [EMAIL PROTECTED] wrote:
I'm trying get current week, starting from monday to sunday:
select UNIX_TIMESTAMP(day), g15, g16, g17, g18, g19, g20,
Based on may observations, derived tables (subselect) are not cacheable:
select column1, column2 from (select SQL_CACHE * from MyTable) as b
The second part is not inserted to QueryCache nor is it retrieved if
already in
cache.
Also the file comments in sql_cache.cpp - Make derived tables
At 10:02 -0400 10/16/04, Michael J. Pawlowsky wrote:
I just noticed that a restricted user to only one database can still
run show databases;
and see all the names of the databases in MySQL.
You would think that it would only return the databases that that
user is allowed to connect to.
Is
At 16:03 -0600 10/16/04, C.F. Scheidecker Antunes wrote:
Hello all,
I have a remote server that has a harddrive almost full. Therefore I
need to dump a huge table to my other host.
OK, I've set the permissions so that I can log in to the server as
root from my host. I've try to connect to it and
I just posted two detailed issues WRT the perfomance of ALTER table and
what I think are pretty significant issues.
For the last few days I've been using MySQLs ALTER and REPAIR table
functionality and its caused tons of countless problems and a great
deal of lost sleep.
The first problem I
I'm trying get current week, starting from monday to sunday:
select UNIX_TIMESTAMP(day), g15, g16, g17, g18, g19, g20, g21, g22, id
from tydzien where to_days(day) between
to_days(now())- mod(to_days(now()),7)+2 /*some parameter setting a starting
day*/ and
(to_days(now())-
16 matches
Mail list logo