[simone]

oh got it working perfectly now, thanks a great deal blaw!

[simone]

uhh actually i have one more question. (sorry to bother you) but how would i make it show on the page ..using a variable ...like because im using templates, i dont want it to echo straight from the php page, id like it only to show if i place something like $showrows in the template file.

[blaw]

Hi there,

Instead of echoing, you can assign (fetch) it into a variable and display it whenever you want to.

But the thing is, it really depends on what kind of template engine/algorithm you are using. For instance, would you like your $showrows to hold only one row at a time or all rows?

If all, then instead of echoing, you can fetch everything into $showrows with concatination operator (e.g. $output .= "whatever_you_are_fetching"; ):

PHP Code:

// Basically the same as before.

// Note that this time we don't have echo, but $output .=

// Also, I took out <table> tags.

for ($i = 0; $i < 4; $i++) {

    

    // Fetch <tr>.

    $output .= '<tr>';

    

    for ($j = 0; $j < 3; $j++) {

        

        // See if there is still a fetchable row in the result.

        if ($row = mysql_fetch_array($res)) {

            $output .= '<td>'.$row[0].'</td>';

        }

        // If not, fetch the dummy link.

        else {

            $output .= '<td><a href="submit.php">Submit Yours</a</td>';

        }

    

    }

    

    // Fetch </tr>.

    $output .= "</tr>\n";



} 

In the end you'll get $output that holds all the rows. Then simply place(echo) this var between <table> and </table> to display the table. But again, it depends on what you really need to get out of this function.

Hope this gives you some idea.

[simone]

yes, thankyou! that worked magically ..thanks for the major help! <3