PHP Tutorials: Creating a Blog (Part 10/11)

Official site

Twitter

[tinklainis]

@YaManTino Thank you for your reply. Well, I'm just looking for an alternative professional way, but it seems that this is the most appropriate way.

[James-ylkk]

if you get stuck you should echo $query to make sure the SQL is valid.

[HerbivoreJesus]

I'd love to see a tutorial on how to add images when creating a post

[vozzen]

I don't want to learn, just have it on my site. I'm finished with the blog anyways so I succeeded.

[kevintipker]

I have the problem that if i go to the category page it only shows me one result on the page and yes i have more then one post

[mgria]

in get_posts() what happens if a category id and a post id is set ?

[tinklainis]

I was wondering about the issue of deleting a category.

One solution that I can think of is a script in "delete_category.php" file. It would check which fields in the "posts" table have the same category ID as the one that you are deleting. Then it would change the category ID of the fields with some default category.

This way of dealing with the issue could be slow (e.x. when working with big tables).

Could you point out some different approaches for making it all work?

[TheAlexKiernan]

Does anyone else get
"PHP Warning: mysql_fetch_assoc(): supplied argument is not a valid "
and nothing loads on their category.php. Everything works fine on the index. I can't my head around it at all

[vozzen]

But I hate when you say: "Try to do this yourself."
I haven't read anything about php and MySQL except this because I have a hard timeline to work with.

[JamWard]

Then maybe you do need to read a little about PHP & MYSQL?
The idea of these tutorials are to help you learn. You'll never learn just by copying line for line.

[Rdmp]

"...and we see that this does not actually seem to work??"

He 'might' be a programmer (you notice might in quotes). But he is for sure not a good teacher!