select from

bigdaddysheikh

Hello,

I am a bit confused on how the sql statment is working.

$sql = "select ct_id from tbl_cart 
		        WHERE ct_session_id = '$sid' AND pd_id = $productId";		
		$result =& dbQuery($sql);

Shouldnt this grab the value in the field ct_id and return it in the variable $result. When I echo the $result i get resoucre ID#14. I dont quiet understand why this happens. I am trying to avoing usin ghte mysql_fetch_array function.

drew010

there is no way to avoid the mysql_fetch_array/row functions. when you issue a query it gets the results from the database and puts them in a list. by calling one of those functions it grabs the next result from the list and returns it. even if there is only 1 result you still need to use it.

bradgrafelman

Perhaps I don't understand completely, but in this case, what drew said is entirely incorrect.

If you're just retrieving one column, look at using [man]mysql_result/man. Are you only expecting 1 row? If so, you could retrieve the value like this:

$sql = "select ct_id from tbl_cart  

                WHERE ct_session_id = '$sid' AND pd_id = $productId";         

        $result =& dbQuery($sql);
        $ct_id = mysql_result($result, 0);

When the third parameter for mysql_result() is blank (the field parameter), the first field in the result is given. Since you only select'd ct_id, this would be a way to retrieve the value of the first row in the result set without using array functions.

drew010

ok yeah, so there is the mysql_result function, which goes along the same lines of mysql_fetch_row except you specify which row you want to retrieve

i suppose the comparison is

$row = mysql_fetch_row($res);
echo $row[0]; //id

versus

$id = mysql_result($res, 0);

a bit shorter yes. so good point

bradgrafelman

Shorter and it would be quicker. Rather than "fetching" an entire array of potentially huge columns, you can only retrieve one column. Since only one column was selected in the query, this point is a bit moot.