Lecz niestety skrypt wywala mi błąd:
Kod
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/LOGIN/domains/XYZ.com/public_html/cron/ca.php on line 19
Dlaczego? Mój pełny kod:
<?php /* Host bazy danych */ $cfg['dbhost'] = "localhost"; /* PREFIX TABELI WORDPRESS */ $PREFIX = "wp_"; /* Nazwa użytkownika bazy danych */ $cfg['dbuser'] = "user"; /* Hasło użytkownika bazy danych */ $cfg['dbpassword'] = "haslo"; /* Nazwa bazy danych */ $cfg['dbname'] = "nazwa"; $post = mysql_query("SELECT * FROM `".$PREFIX."_posts` WHERE `post_status`='publish' AND `post_type`='post'"); $id = $post_var['ID']; for($i=0;$i<$ile;$i++){ (`comment_ID`, `comment_post_ID`, `comment_author`, `comment_author_email`, `comment_author_url`, `comment_author_IP`, `comment_date`, `comment_date_gmt`, `comment_content`, `comment_karma`, `comment_approved`, `comment_agent`, `comment_type`, `comment_parent`, `user_id`) VALUES('', '".$id."', '".$linie_pliku[$ktora_linia]."', '".$linie_pliku[$ktora_linia]."@gmail.com', '', '".$ip."', '".$linie_pliku_koment[$ktora_linia_koment]."', '0', '1', 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:23.0) Gecko/20100101 Firefox/23.0', '', '0', '0')"); if($add){ } } $commenters = queryNumrows("SELECT * FROM `".$PREFIX."comments` WHERE `comment_post_ID`='$id'"); $update = mysql_query("UPDATE `".$PREFIX."posts` SET `comment_count`='$commenters' WHERE `post_status`='publish' AND `ID`='$id'"); } ?>