WordPress database error: [Table 'wp_comments' is marked as crashed and should be repaired]
SELECT ID, COUNT( comment_ID ) AS ccount
FROM wp_posts
LEFT JOIN wp_comments ON ( comment_post_ID = ID AND comment_approved = '1')
WHERE ID IN (24,23,22,21,20)
GROUP BY ID
Variable Naming
The Variable Naming standard you choose, can be anything you want, bearing in mind that different languages have restrictions on what can be used to name variables, and some keywords are banned from being included in variable names. Some languages are also case sensitive, or insensitive, and that also has as effect on variable names. (more…)
WordPress database error: [Table 'wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 24 AND comment_approved = '1';
WordPress database error: [Table 'wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '24' AND comment_approved = '1'
Output Information
We have been displaying information as we have progress through these tutorials, now we are going to take a step back and look in some detail about the different ways to display information from our php scripts (more…)
WordPress database error: [Table 'wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 23 AND comment_approved = '1';
WordPress database error: [Table 'wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '23' AND comment_approved = '1'
Php - Scope of Variables
We just introduced functions, now along with functions comes Scope of variables. In common day example i will try to give a general explanation of scope. If you have 4 tvs in different rooms, with 4 cables box, then each tv can show a different channel. Thus each “variable/tv” has it own “scope/show”. If you have 4 tvs, and 3 cables boxes and 2 tvs sharing a cable box. Then you will only have 3 different shows. In this instance a “variable/tv will have the same value on “2 area/rooms” and the other 2 (tv/variables) will have their own “scope/show”. So that if you change the value in one room where the tv is shared the other room is affected. That is how scope works, depending on the section you are in a variable can have one value and in another section it could have a different value, all depends on where is declared… (more…)
WordPress database error: [Table 'wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 22 AND comment_approved = '1';
WordPress database error: [Table 'wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '22' AND comment_approved = '1'
Functions in PHP
Functions are the robots/machines of any programming languages and in PHP they just the same. They are mainly used to make code reusable and easy to read. If you need to record a show on television only one time, do you program the VCR? However, if you need to record the same show everday, you use the timer and the programmer on the VCR to make it happen. (more…)
WordPress database error: [Table 'wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 21 AND comment_approved = '1';
WordPress database error: [Table 'wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '21' AND comment_approved = '1'
Pre/Post Increment, Decrement
We touched on these features in PHP before, now lets go a little deeper into the operation of these functions.
(more…)
WordPress database error: [Table 'wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(comment_ID) FROM wp_comments WHERE comment_post_ID = 20 AND comment_approved = '1';
WordPress database error: [Table 'wp_comments' is marked as crashed and should be repaired]
SELECT COUNT(*) FROM wp_comments WHERE comment_post_ID = '20' AND comment_approved = '1'