PHP and MySQL content displaying out of order

Question

While dynamically generating a page with different types of contents , the "post" content is appearing above the static content which is being generated.I want it the other way around. Does there appear to be anything in my code that would make this happen, or do you think the problem has something to do with my database? Thanks.

$query = "SELECT * FROM content WHERE pages LIKE '%$pageID%'";
$result = mysql_query($query) or die(mysql_error());
while ($row = mysql_fetch_assoc($result)) {

// Display pages's static content

if ($row['type'] == "static") {

    echo "
        <h2>" . $row['tile'] . "</h2>
        <content>" . $row['body'] . "</content>
    ";
}

// Display pages's posts

else {
    echo "
        <h2>" . $row['tile'] . "</h2>
        <content>" . $row['body'] . "</content>
    ";
}

Add a separator between types.Check if your $row['type'] is a correct variable — elo
– elo, Commented Jul 21, 2012 at 21:33

Rab Khan · Accepted Answer · 2012-07-21 21:27:41Z

1

SELECT * FROM content WHERE pages LIKE '%$pageID%' ORDER BY type desc

answered Jul 21, 2012 at 21:27

Rab Khan

35.7k4 gold badges52 silver badges66 bronze badges

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

1 Comment

americanknight Over a year ago

Perfect. Nice and easy. Thanks.

bfavaretto · Accepted Answer · 2012-07-21 21:26:10Z

0

Add this to the end of your query:

ORDER BY CASE WHEN type = 'static' THEN 0 ELSE 1 END

answered Jul 21, 2012 at 21:26

bfavaretto

72k18 gold badges118 silver badges162 bronze badges

2 Comments

americanknight Over a year ago

THANK YOU, that did the trick! I wasted hours stressing over this one. Any chance you could explain to me what that code does exactly? Looks like I need to learn MySQL better.

bfavaretto Over a year ago

Sure. ORDER BY [somecolumn] will order the results by the column you pass. Instead of passing a column, I'm passing a conditional expression (CASE WHEN ... THEN ... END), to force rows where the type equals 'static' to be returned first (0).

Collectives™ on Stack Overflow

PHP and MySQL content displaying out of order

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related