How do I output two fields in PHP?

Question

I have a database that has two fields: current, and previous.

Here is the code:

                            <?
$username="*****";
$password="*****";
$database="******";

mysql_connect(localhost,$username,$password) or die("Unable to connect to server");
mysql_select_db($database) or die( "Unable to select database");

$query='SELECT * FROM tasks WHERE current=1 OR previous=1';
$result=mysql_query($query);
$num=mysql_num_rows($result); 

mysql_close();

?>

It then output it and manipulate it like this:

<div class="tasklist">
    <div class="currentProject">
    Current Project:
    </div>
<?
$i=0;

while ($i < $num) {
$title=mysql_result($result,$i,"Title");
$link=mysql_result($result,$i,"Weblink");
$description=mysql_result($result,$i,"Description");
$id=mysql_result($result,$i,"ID");
$howto=mysql_result($result,$i,"howto");
$blogpost=mysql_result($result,$i,"blogpost");
$done=mysql_result($result,$i,"done");
$current=mysql_result($result,$i,"current");
$previous=mysql_result($result,$i,"previous");

if ( $current == 1 ) {
    $current = "current";
} else {
    $current = "";
}

if ( $previous == 1 ) {
    $previous = "previous";
} else {
    $previous = "";
}

?>

    <div class="<? echo $done ?> task <? echo $id ?>" id="<? echo $current.$previous ?>">
            <div class="titleWrapper">
                <div class="title">
                    <a class="article"  href="<? echo $link ?>"><? echo $title ?></a>
                </div>
            </div>
    </div><BR>

<?
$i++;
}

echo "</div>";


?>

The problem is that since previous comes before current in the database, it outputs previous and then current.

Question:

How do I make sure to output current first, and then previous?

That's incredible ancient way to query a database. Where did you get that rarity? And your database structure is under questioning too — Your Common Sense
– Your Common Sense, Commented Sep 25, 2010 at 19:57
To be honest, I ripped it off of another coders work. I am not the best with PHP, and I asked a buddy to code that for me.... and mind being more helpful other than "database structure is under questioning too"? — Jared
– Jared, Commented Sep 25, 2010 at 20:13
If you can provide a better way to do it, I would really appreciate it. — Jared
– Jared, Commented Sep 25, 2010 at 20:16

Ignacio Vazquez-Abrams · Accepted Answer · 2010-09-25 19:49:24Z

1

Instead of outputting both directly, store them until you actually have both, and then output both in the correct order.

answered Sep 25, 2010 at 19:49

Ignacio Vazquez-Abrams

804k160 gold badges1.4k silver badges1.4k bronze badges

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

Comments

LatinSuD · Accepted Answer · 2010-09-25 20:04:04Z

0

Just append this to your query order by previous.

It must work as long as current task registry has previous=0 and previous task registry has previous=1.

answered Sep 25, 2010 at 20:04

LatinSuD

1,94914 silver badges20 bronze badges

Collectives™ on Stack Overflow

How do I output two fields in PHP?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related