mysql_fetch_object easier method ?

[TheAvenger]

Hy there peeps,

ive been working with php/Sql now for my website and i keep getting more skilled at it. Half my site / script run on database retrieval & storage and for that i have been using the mysql_fetch_object retrieval method. Scripting like this.

mysql_connect("hostname","username","password");
mysql_select_db("databasename");
$query="select x from tablename";
$sql=mysql_query($query) or die (mysql_error());
while ($obj=mysql_fetch_object($sql)) {
$variable1=$obj->databasefield;  

...
}

where x is needed data fields

The problem is, i think this isnt one of the easiest methods / scripts of retrieving data from a database to work with. Nor is this method easy to remember. So my question is, is there a more easier way to retrieve data in a database to work with.

Any help appreciated

[bogu]

There is always mysql_fetch_assoc() or mysql_fetch_array(), depends on what are u looking for ...

[Plasma]

Fetch array is probably easier for you to work with.

$query = "SELECT * FROM database";
$result = mysql_query($query);

while ($row = mysql_fetch_array($result))
{
echo $row['name'];
}

etc

$row holds an associative array of the current row and its fields.

[bubblenut]

If you're using PHP5 then PDO's pretty damned easy to use (once you get your head around it)

$db = new PDO('mysql:host=localhost;dbname=databasename', 'username', 'password');

foreach($db->query("SELECT x FROM tablename") as $row) {
  // $row combined associative/indexed array like with mysql_fetch_array
}

Plus, once you delve a little deeper you'll see there's loads of really funky things you can do with it.