php problem...

[Joel]

i have a problem, i am tryong to clean up my code, but have run into problems...

before i had :

$result = mysql_query("                SELECT template
                                    FROM template
                                    WHERE template_id = '3'")

or die ("Couldn't Execute Query");

$row = mysql_fetch_array($result);

$templateno = $row[template]; 

i had about 20 of them ^ for each template i am using, but i want to load them all with one loop and query, rather then with 20 or so. the db is layed out in 3 columns; template_id, template_name, and template(which is the one where the template info is stored). i want to load each teplate cell and assighn the contents a varible name, as in the above code, but i dont want to do it with 20 querys if i can help it

[Agent]

Use a while statment with fetch_object. Somthing like :

<?
// do querys here, query = $result

// if records present
if (mysql_num_rows($result) > 0)
{
    // iterate through resultset
    // print whatever is needed.

    while($row = mysql_fetch_object($result))
    {
    ?>

Do whatever you want here, echo the result/s you want, with any HTML formating

<?
// close loops
}}
?>

This will complete the loop, move onto the next result in the array, complete the loop and so on..

edit - missed out the end of the second loop - updated now.

[ICY]

<?php

$result = mysql_query("SELECT template FROM template ORDER BY 'template_id' asc")

or die ("Couldn't Execute Query");

for($i = 0; $i > $result; $i++)
{
    $row = mysql_fetch_array($result);
    
    $row['template'] = $template[$i];
}

while($i >1)
{
    echo $template[$i] .'<br/>';
}

?>

i think this will work, havent tested it myself though, the end bit *should* output the template name in a list, if it works correctly that is...