Neverside

best method for getting data from a database?

personally i use

PHP:

<?php

mysql_connect("$hostname","$username","$password") OR DIE ("Unable to connect to database");
mysql_select_db("$dbname") OR DIE("Unable to select database");
$result = mysql_query("SELECT * FROM $tablename");
$number = mysql_num_rows($result);
$i = 0;
if ($number == 0) 
    {
    PRINT "No products!";
    }
ELSEIF ($number > 0) 
    {
    WHILE ($i < $number) 
        {
        $blah = mysql_result($result,$i,"blah");
                print "$blah";
        $i++;
        };
    };

?>

to manipulate databases (mysql), just wondering if there are any easier ways, as its a bit of a pain that way

___________________

Infinite Fire - Photoshop, PHP, HTML, CSS and Webmaster Tutorials - Web Design Centre
Photoshop Tutorials | PHP Tutorials | HTML Tutorials | Webmaster Tips and Tricks
Buy Cheap Digital Cameras!

what more do you want?
you must be too lazy to program.

___________________

Haha, I agree with epyon.

___________________

Mugging Scotty Good.
www.muggingscotty.com

is that a phper with pmt's way of saying they dont know a quicker way

___________________

Infinite Fire - Photoshop, PHP, HTML, CSS and Webmaster Tutorials - Web Design Centre
Photoshop Tutorials | PHP Tutorials | HTML Tutorials | Webmaster Tips and Tricks
Buy Cheap Digital Cameras!

your question sense no makes this.

___________________

I code alot.