OldGrim
-
Posts
38 -
Joined
-
Last visited
Community Answers
-
OldGrim's post in Help With db Coding was marked as the answer
Barand I tried your solution and it doesn't work (for me) as I don't knw how to code the result of your code however, I found the solution on my own and it works great! Here is the final result:
<?php $runq = mysqli_query($connect, "SELECT * FROM `categories` ORDER BY category ASC"); while ($row = mysqli_fetch_assoc($runq)) { $category_id = $row['id']; $queryac = mysqli_query($connect, "SELECT * FROM `posts` WHERE category_id = '$category_id' and active='Yes'"); $count = mysqli_num_rows($queryac); $cntrow = $count; if ($cntrow == '0' OR $cntrow > '1') { $tc = "s"; } else { $tc = ""; } echo ' <a href="category.php?id=' . $row['id'] . '" class="list-group-item list-group-item-action"><i class="fa fa-arrow-right""></i> ' . $row['category'] . ' - '.$cntrow.' article'.$tc.'</a> '; } ?> If you care to see the outcome here is my url: https://blog.trans-galactic.com
-
OldGrim's post in How to solve: Trying to access array offset on value of type bool was marked as the answer
Thanks again Barand. This now works fine.
$result = dbquery("SELECT post_id, post_title, post_date FROM ".DB_GRIMS_BLOG_POST." WHERE active='1' AND MONTH(post_date) = '$cMonth' AND DAY(post_date) = '$d'"); $data = dbarray($result); if (empty($data['post_id'])) { $id = null; } else { $id = $data['post_id']; } if (empty($data['post_title'])) { $title = null; } else { $title = $data['post_title']; } if (empty($data['post_date'])) { $evday = null; } else { $evday = strtotime($data['post_date']); } As I said before you guys are the greatest! Mainly because you know how to make US work for it and figure it out ourselves.
-
OldGrim's post in Simple php calendar plugin trying to add linkable dates was marked as the answer
Check out my blog site when you get a chance Barand. Everything now works correctly. I have a friend that lives in California and we, together developed this blog and calendar. He has been working on it on his localhost setup on his computer. He took your calendar code as is and it works correctly on his computer so he sent me his calendar.php file to test on my live system and it works beautifully !!! I made the mistake of trying to split things up too much. (old habits die hard)... at any rate this project is now truly complete with all aims accomplished. Thank you so very much Barand. We really appreciate all your hard work. I wish my php skills were anywhere near your skill level.