Mysql_fetch_object database retrieval

[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 problmel is, i think this isnt one of the easiest methods 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

[Xnuiem]

fetch_row is about the same.


$result = mysql_query("select x from table");
while(list($listFields) = mysql_fetch_row($result)){

}

[Theavenger]

thx but thats not totally what im looking for, in some of my scripts i only need 1 or 2 fields from a certain table / database. so when i need multiple fields out of multiple different databases this isnt one of the easiest scripts to work with.

My question exactly is, is there an easier way to the whole $sql ....
while .... stuff. I'm lookin for a complete easier method / and easier to remember. Currently the only way i succeed at this is to open a page where it is already active, and copy/modify where needed.