davidwhiteuk

I think this sounds like the way I'll need to go. I'll have to learn about arrays though. Thanks.

Goes back about 3 years at the moment. Obviously this would increase over time.

Hello, I'm not sure if this is more an issue with PHP or MySQL. I have a piece of code that counts how many records on each date have a specific word. It works fine. foreach($mysqli->query('SELECT DATE(`s_created_at`) , COUNT(*) FROM `tickets` where subject LIKE "%Word%" GROUP BY `s_created_at` order by s_created_at DESC') as $row1) { echo $row1['s_created_at']; echo " "; echo $row1['COUNT(*)']; } So the output format is: 2022-05-16 3 2022-05-13 2 2022-05-12 3 2022-05-11 1 The one issue is that obviously it ignores all dates that don't have the word. I'd like the format to include this so it looks like: 2022-05-16 3 2022-05-15 0 2022-05-14 0 2022-05-13 2 2022-05-12 3 2022-05-11 1 Any ideas? Thanks.

Hello, On my website I wish to have a simple graphic and allow users to write their own text onto the graphic then they can save out the graphic. I'm new to PHP so I'm not that good at it. I've done some research and I think I need to use the GD library. Is this correct? What would be the easiest way to do what I want? Thanks

Thanks for your help guys

Hello, I have a website I programmed with PHP and MySQL. When I take a record from the database, one of the fields is a timestamp and the date is in the format 2009-08-04 17:08:37 or YYYY-MM-DD HH:MM:SS How do I change this so I can make it appear as 4th August 2009 on the site? thanks