bh

$sql = "Select photos.*, categories.cat FROM photos, categories WHERE photos.cat_id = categories.id AND photos.status ='1' AND videos.dateposted >= DATE_SUB(videos.dateposted, INTERVAL 24 HOUR) ORDER BY (videos.up-videos.down) DESC LIMIT $start, $limit"; $result = mysql_query($sql); Anyway, i cant see "videos" in your query. And date sub only return a date -> date = videos.dateposted - 24 hour

Maybe the script was wrong, still you have the trigger script?

Hi, DATE_SUB(dateposted, INTERVAL 168 HOUR);

Hi, If you dont wanna do from your PHP script, yes you can use MySql Triggers. The MySQL manual helps you.

I mean do you need the users table in your query? Not enough to check whether a submission has a user? If you need users datas and dont specify a user or users set in WHERE clause your query is ok i think.

unlink

Hi, Use isset to decide is the variable is set and not null. Eg like this: if (isset($_POST['submit'])) { }

Dont enough if you join the site and submission table where submission.userid is not null?

You see its get all of the users (77369)...

The problem is in the first row: "ALL". Is there an index on s.siteID?

Yeah, Group by cause "Using temporary; Using filesort", and these are the bad ones. edit: Anyway, with "SELECT DISTINCT" and without "GROUP BY" ?

Maybe if you Analyze the table?

I gave you a link. Or Google...

Refresh the page at a fix time? Youre mean a console script? Eg in Linux: Write a console PHP script, and than create shell script what calls your PHP script and then put your shell script into CRON.

Hi, I dont see "Using index" in your Explain datas. So, indexes may helps a bit. Another thing is optimization, try to optimize your table. It helps you if your table has had a lots of deleted rows.

Its rather a HTML topic, i think. Example use HTML tables?

Hi, Whats wrong with the "NOT IN"? Its working very well.

Hi, You can use DATE_FORMAT(date, format). Eg. like this: SELECT DATE_FORMAT(NOW(), '%Y-%m-%d 00:00:00');

Hi, $date = '2010-08-06'; // or 07/08/2010... date('d/m/Y', strtotime($date));

Google helps you.

Yeah, and whats the problem. First use google, and if you stuck than ask a question: simple_xml_tutorial Anyway, if you know a specific element what you want to get use xpath.

Hi, You should get the affected rows when you run UPDATE / DELETE queries.

Hi, for loop Read the notes too.

Use while statement. while ($row = mysql_fetch_assoc($eid2)) { echo $row['id']; }

Hi, Example return with an array or use referenced parameters (out parameter).