hello there

my question is what is the best way to get a singe value (field) from the database. i would like to know what is the most efficient and fastest way to get it. i was thinking about mysql_result() but is there anything else that might be helpful? is there anyway i can store values for usage in other pages? thanks :):):)



the genuine genius

__________________
www.campusgrind.com - college portal

mysql_result is the way to go if you only need ONE field. Of course, if you only need the one field, be sure to write your query such that it only selects the field you need! Don't select more rows or columns than you plan on using.


Take care,

Nik
http://www.bigaction.org/

well code below should be better for u :

<?
$server = "localhost";
$db = "database_name";
$sqlQuery = "Select * from tablename"
$link = $mysql_connect($server);

$mysql_select_db($db,$link);
$result = mysql_query($sqlQuery,$link);

for($row=mysql_fetch_array($result)){

echo stripslashes[$row("field_name")]
}
?>

happy coding