Echo results of mysql query with php

I have this query

$people = "SELECT name FROM people";
$people = mysql_query($people) or die(mysql_error());
$row_people = mysql_fetch_assoc($people);
$totalRows_people = mysql_num_rows($people);

I can echo the results within a unordered list using a while loop like this

<ul>

<?php {do { ?>

    <li><?php echo $row_people['name'];?></li> 

<?php } while ($row_people = mysql_fetch_assoc($people));}?>

</ul>

But I can't used this as m开发者_如何学JAVAy html does not allow it.

<ul>
    <li class="first">
        <a href="?name=kate">Kate</a>
    <li>
    <li class="second">
        <a href="?name=john"><img src="john.jpg" />John</a>
    <li>
    <li class="third">
        <a href="?name=max"><span>Max</span></a>
    <li>
</ul>

My question is how can echo the name that was retrieved from the database into the appropriate place within this html?

Thanks for your help.

---

Try this:

<?php

$people = "SELECT name FROM people";
$people = mysql_query($people) or die(mysql_error());

if(mysql_num_rows($people) > 0){
?>
    <ul>
    <?php
        while ($row_people = mysql_fetch_assoc($people)){ 
    ?>
            <li><?php echo htmlentities($row_people['name']);?></li> 
    <?php
        }      
    ?>
    </ul>

<?php
}

?>

---

You'll just have to create a renderer for each "type" of user (assuming you have a type property on the user rows) or based on their attributes. For example, let's say you're going to have to filter based on the attributes:

<?php

function render_simple($person) {
    return '<a href="?' . $person['name'] . '">' . $person['name'] . '</a>';
}

function render_with_image($person) {
    return '<a href="?' . $person['name'] . '"><img src="' . $person['image'] . '.jpg"/>' . $person['name'] . '</a>';
}

function render_special($person) {
    return '<a href="?' . $person['name'] . '"><span>' . $person['name'] . '</span></a>';
}

function render_person($person) {
    if ($person['image']) {
        return render_with_image($person);
    }
    if ($person['special']) {
        return render_special($person);
    }
    return render_simple($person);
}

$i = 0;
while ($row_people = mysql_fetch_assoc($people)){ ?>
    <li class="index<?php echo ++$i; ?>">
        <?php echo render_person($person); ?>
    </li>
<?php
}      
?>

This should work, with the exception that instead of class names first, second, etc, you'll now have index1, index2, etc.