retrieving a large amount of data using multiple queries

[numerical25]

Everytime when I try to do a single query to retireve rows of data, I get the error

2008: MySQL client ran out of memory

I decided the best way to retrieve this data is to do mulitiple query calls using the LIMIT command

SELECT * FROM table1 LIMIT 0 , 10
SELECT * FROM table1 LIMIT 10 , 20
SELECT * FROM table1 LIMIT 20 , 30
SELECT * FROM table1 LIMIT 30 , 40

But first. I need to figure out how large the query is as a whole. so wont atleast go over the LIMIT. Anyone can tell me the best method of doing this ??

[numerical25]

Here is a query I got so far. But I need to know the total result over all in order to do this

for($i = 0; $i < $query_times; $i++)
		{
			$query = "SELECT calc_cities.id, calc_cities.city 
					  FROM calc_cities, calc_locations 
					  WHERE calc_locations.state_id = ".$_GET["getCities"];
			$query .= " LIMIT ".($i * 6).", ".(($i + 1)*6);  

		if(!$result = mysql_query($query))
		{
			echo mysql_errno().": ".mysql_error()."<BR>";die();
		}

		while ($row = mysql_fetch_assoc($result)) {
			echo $row['id']." ".$row['city']."<br/>";
			//echo "<option value='".$row['id']."'>".$row['city']."</option>";
		}
	}

[sneakyimp]

You should check to see if your query returned no rows and if it does, you could [man]break[/man] out of your loop. Either that or you could add another check to your for loop to make sure the last query actually returned some rows.