thesavior
05-16-2009, 01:16 AM
When I run my query through php, I get a 1064 error (normally means im using a reserved word).
However when I run it directly through phpMyAdmin, i don't get any error, and the query works sucessfully.
This is my query:
SELECT lower( 'topic' ) AS
TYPE , `id` , `name` , '' AS displayname, `posterid` , `post_count` , `dateadded` , '' AS message, `lastpostdate` , `lastposterid` ,
MATCH (
name
)
AGAINST (
'eli'
) AS score
FROM new_topics
WHERE MATCH (
name
)
AGAINST (
'eli'
)
UNION SELECT lower( 'post' ) AS
TYPE , p.id, t.name, '', p.posterid, p.topicid, p.postdate, p.message AS message, '', '',
MATCH (
message
)
AGAINST (
'eli'
) AS score
FROM new_posts AS p
INNER JOIN new_topics AS t ON p.topicid = t.id
WHERE MATCH (
message
)
AGAINST (
'eli'
)
UNION SELECT lower( 'user' ) AS
TYPE , `id` , `username` , `displayname` , `avatar` , '', `date_added` , '', '', '',
MATCH (
username
)
AGAINST (
'eli'
) AS score
FROM new_users
WHERE MATCH (
username
)
AGAINST (
'eli'
)
ORDER BY score DESC
And the MYSQL version is: 5.0.51am
PHP Version 5.2.42
and the php client mysql version is 5.0.75
However when I run it directly through phpMyAdmin, i don't get any error, and the query works sucessfully.
This is my query:
SELECT lower( 'topic' ) AS
TYPE , `id` , `name` , '' AS displayname, `posterid` , `post_count` , `dateadded` , '' AS message, `lastpostdate` , `lastposterid` ,
MATCH (
name
)
AGAINST (
'eli'
) AS score
FROM new_topics
WHERE MATCH (
name
)
AGAINST (
'eli'
)
UNION SELECT lower( 'post' ) AS
TYPE , p.id, t.name, '', p.posterid, p.topicid, p.postdate, p.message AS message, '', '',
MATCH (
message
)
AGAINST (
'eli'
) AS score
FROM new_posts AS p
INNER JOIN new_topics AS t ON p.topicid = t.id
WHERE MATCH (
message
)
AGAINST (
'eli'
)
UNION SELECT lower( 'user' ) AS
TYPE , `id` , `username` , `displayname` , `avatar` , '', `date_added` , '', '', '',
MATCH (
username
)
AGAINST (
'eli'
) AS score
FROM new_users
WHERE MATCH (
username
)
AGAINST (
'eli'
)
ORDER BY score DESC
And the MYSQL version is: 5.0.51am
PHP Version 5.2.42
and the php client mysql version is 5.0.75