From: Dan Nelson
Date: September 17 2005 8:11pm
Subject: Re: mysql_free_result() WITHOUT mysql_fetch_row()
List-Archive: http://lists.mysql.com/mysql/189210
Message-Id: <20050917201131.GB7779@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Sep 17), Miguel Cardenas said:
> I have a technical doubt, very simple but not mentioned in the manual...
> 
> What happens if I call mysql_free_result() after performing a query
> but without doing mysql_fetch_row() ???
> 
> It may sound strange, but just need to know if a data row exists more
> than the data itself...

A faster way would be to run a "SELECT count(*) WHERE ..." query, and
check the result.  Since you are not selecting any data, mysql is more
likely to be able to use index lookups to speed the query up.

-- 
	Dan Nelson
	dnelson@stripped