如何使用memcache缓存mysql_query？

Question

I would like to know if it's possible to store a "ressource" within memcache, I'm currently trying the following code but apparently it's not correct:

$result = mysql_query($sSQL);
$memcache->set($key, $result, 0, $ttl);
return $result;

Answer 1

Why do you need so? Mysql has its own performant query cache

but if you still want to follow your strange idea - you need to fetch all the data into array (with mysql_fetch_assoc or whatever) and after that store that array into the memcached.