{"id":5525,"date":"2016-02-05T13:29:02","date_gmt":"2016-02-05T21:29:02","guid":{"rendered":"http:\/\/www.dognmonkey.com\/techs\/?p=5525"},"modified":"2016-02-05T13:29:02","modified_gmt":"2016-02-05T21:29:02","slug":"warning-missing-argument-2-for-wpdbprepare-fixed","status":"publish","type":"post","link":"https:\/\/www.dognmonkey.com\/techs\/warning-missing-argument-2-for-wpdbprepare-fixed.html","title":{"rendered":"Warning: Missing argument 2 for wpdb::prepare() Fixed"},"content":{"rendered":"

When I used a footer that collects the earliest to the newest year to display from the dated posts, I got the “Warning: Missing argument 2 for wpdb::prepare()” on the bottom of the footer. After Googling the problem, I found the fix for it. It’s not a good way to mask the problem like I did before<\/a>.<\/em><\/p>\n

\"wpdb_prepare_1\"<\/a>\u00a0 \u00a0 \u00a0\"wpdb_prepare_2\"<\/a><\/p>\n

The bad codes:<\/em><\/p>\n

\"wpdb_prepare_3\"<\/a><\/p>\n

\u00a0$post_datetimes = $wpdb->get_row($wpdb->prepare(“SELECT YEAR(min(post_date_gmt)) AS firstyear, YEAR(max(post_date_gmt)) AS lastyear FROM $wpdb->posts WHERE post_date_gmt > 1970”));<\/em><\/p><\/blockquote>\n

The good codes: We need to add the blank second argument to make it complete.”1970″,’ ‘));”<\/em><\/p>\n

\"wpdb_prepare_fixed\"<\/a><\/p>\n

$post_datetimes = $wpdb->get_row($wpdb->prepare(“SELECT YEAR(min(post_date_gmt)) AS firstyear, YEAR(max(post_date_gmt)) AS lastyear FROM $wpdb->posts WHERE post_date_gmt > 1970”,’ ‘));<\/p><\/blockquote>\n