Displaying posts

[Super-Yombario]

What I'm doing is similar to blog posts; I want to do something like this:

INSERT INTO updates VALUES ( "Title Test", "Body Test" )

Then have something like this on the main page:

<table><tr><td>Title Test</td></tr><tr><td>Body Test</td></tr></table>

And I'm working in PHP

[DearonElensar]

SELECT queries and echo's, i won't write the code needed because it is really basic stuff and you are probably being lazy.

[Super-Yombario]

No, I will have multiple blog posts, and I need to know how to show the last 5

[WoogieNoogie]

Like he said...this is pretty much the first thing you learn if you've looked up MySQL and PHP.

[Super-Yombario]

And I have yet to learn this. I can't find any good tutorials on it either. So I come here, and am redirected back to google?

[TropicalPenquin]

At 4/27/09 03:21 PM, Super-Yombario wrote: And I have yet to learn this. I can't find any good tutorials on it either. So I come here, and am redirected back to google?

Yes, google. Giving it a couple of minutes of your time it always worth while.

[Super-Yombario]

I tried Google before posting, I'm not an idiot :P

But that didn't come up, nor do I find it very helpful. I can't really understand it, and I don't see any PHP being used there at all

[yhar]

Programming is as much about the theory as it is about the actual typing.

You need a theory first, which for you is along the lines of: Select posts from database where the category there in is equal to the ID provided and limit the output to 5.

So, that would be

mysql_query("SELECT * from posts WHERE categoryid='$catid' ORDER BY ID DESC LIMIT 5");

So now you have your query, you need to manipulate the data, so you need to create a loop that goes through each post that matches the criteria provided through the query and echos the data. Look up: mysql selecting data, select WHERE, order by, limit and echo.

[DFox]

At 4/27/09 03:21 PM, Super-Yombario wrote: And I have yet to learn this. I can't find any good tutorials on it either. So I come here, and am redirected back to google?

After a few minutes searching, I found this: http://www.phpfever.com/mysqli-tutorial.
html

That's exactly what you want. It'll show you how to select data using mysqli extension. You could easily be lazy and just copy and paste his code or you could learn it. I highly suggest learning it.

[Super-Yombario]

being as I'm not just going to be using this for one thing, I am forced to learn it

[yhar]

At 4/27/09 04:38 PM, Super-Yombario wrote: being as I'm not just going to be using this for one thing, I am forced to learn it

...I don't get why you posted then. I mean, surely you could have just done a search for php news system tutorial or similar and read how they do it and adapt it for your own use.

[Super-Yombario]

I asked a friend and figured it out. Tutorials don't explain this stuff well enough for me I guess : /

[DFox]

At 4/27/09 07:57 PM, Super-Yombario wrote: I asked a friend and figured it out. Tutorials don't explain this stuff well enough for me I guess : /

Then go to your local book store, and buy a book. That's how I learned at first.