Insert Into ... From

Anthony_john5

I've decided to have an automated script pick the highest rated joke and sms message at the end of every month. Here is the query that I have tried for the jokes part:

INSERT INTO `phpbb_content_top` ( `oldid` , `title` , `author` , `author_id` , `warning` , `score` , `type` , `date` ) 
SELECT `id` , `title` , `author` , `author_id` , `warning` , (
score / votes
) AS `score` , 'jokes', '04-04-04'
FROM `phpbb_content_jokes` 
ORDER BY (
score / votes
) DESC 
LIMIT 1

However, the date, score and type are not entered (the joke does not have a warning.) If unsure see screenshot.

I'm also running what I feel to be an identical query for the sms section:

INSERT INTO `phpbb_content_top` ( `oldid` , `title` , `author` , `author_id` , `warning`, `score`, `type`, `date`) 
SELECT `id` , `title` , `author` , `author_id` , `warning`, (score/votes) AS `score`, 'sms', '04-04-04'
FROM `phpbb_content_sms` 
ORDER BY (
score / votes
) DESC 
LIMIT 1

which leads to everything being added successfully.

What am I doing wrong?

Anthony

planetsim

on the end of the query add mysql_error()

that will tell what the error is or close to. I cant see anything wrong besides this

ORDER BY (
score / votes
) DESC

i think that should be done like this

SELECT `id` , `title` , `author` , `author_id` , `warning` , avg(
score / votes
) AS `scores` , 'jokes', '04-04-04'
FROM `phpbb_content_jokes` 
ORDER BY (
scores
) DESC 
LIMIT 1

Its not tested by the way

Anthony_john5

I surpress the errors and use this to show them the way I want...

@mysql_query($query_topjokes, $connection)
	or ThrowError("error with query: " . mysql_error() . "\n\nQuery: " . $query_topjokes);

and none appear for this script. I think I may compare and post screen shots of the table types, because if the same code works for sms I dont see why it shoiuldn't work for jokes.

Anthony