How can I have my php return only a certain id from mysql

Question

How can I have my php page only return rows with a certain id. I am working on a webpage set up like a blog, i post using mysql, i it to only show entries with the id of 1, so i don't have to worry about deleting old posts or having 100 posts on 1 page.

        <?php
        include ("includes/includes.php");

        $blogPosts = GetBlogPosts();

        foreach ($blogPosts as $post)
        {
            echo "<div class='post'>";
            echo "<h2>" . $post->title . "</h2>";
            echo "<p>" . $post->post . "</p>";
            echo "<br />";
            echo "<span>Posted By: " . $post->author . "&nbsp Posted On: " . $post->datePosted . "&nbsp Tags: " . $post->tags . "</span>";
            echo "</div>";
        }

        ?>

You can by using a SELECT query. For example: SELECT title, content, date FROM entries WHERE id = 1 — GolezTrol
– GolezTrol, Commented Oct 24, 2011 at 22:26

batoutofhell · Accepted Answer · 2011-10-24 22:27:52Z

1

$result = mysql_query("SELECT * FROM entries WHERE id=1");

answered Oct 24, 2011 at 22:27

batoutofhell

1,3093 gold badges12 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How can I have my php return only a certain id from mysql

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related