Hi Everyone!
I have a problem with querying in mysql. Well the syntax is correct, the only problem that i see is that im trying to get a very large number of rows. I have around 1gig of data and im trying to get all of them in one query.. is that possible? if not, why?
The code is like this:
echo “Start now <br>”;
// i put a condition to lessen the query count i get but in real action i want no condition at all
$allTopics = mysql_query("SELECT * FROM topics AS t
LEFT JOIN structure AS s
ON t.t_cid=s.s_cid
WHERE t.t_topic like '%Telecommunication%'") or die(mysql_error());
while ($rowTopics = mysql_fetch_array($allTopics)) {
$count++;
$cId = $rowTopics['t_catid'];
$topic = $rowTopics['t_topic'];
$description = $rowTopics['s_description'];
//just to see if i get any result
echo "$catId $topic $description<br>";
}
echo “End”;
if i run that i get no echo at all but if i insert LIMIT 0,30 i get results. Then i tried to limit it to 0,100000 and again i failed. Then i lower it to 10000 only still i get no result. Can someone tell my why.
