better way

viveleroi0

Someone mentioned that the way I have this setup can bhe slow. What I use to improve it?

$result2=mysql_query("SELECT * FROM Products LEFT JOIN Hold ON Products.ID = Hold.HoldID WHERE Hold.HoldID IS NULL AND ProdCat=\"$CatSelect\" ORDER BY Products.ID LIMIT $offset,$resultlimit");
$num2=mysql_num_rows($result2);
$i=0;
while ($i < $num2) {
$ProdCat=mysql_result($result2,$i,"ProdCat");
$SubCat=mysql_result($result2,$i,"SubCat");
$ProdName=mysql_result($result2,$i,"ProdName");

++i}

Bunkermaster

well the way it is it won't work...

++i would prolly be better off with a $

depends on what you want to do and what indexes you've set on your table

viveleroi0

I know its not EXACTLY as it is in my script, you guys dont want to see the whole script. Someone said there was a better way of getting the results, like making an array or something.

dnszero

You'd probably be better off with [man]mysql_fetch_row[/man] than mysql_result. Other than that, you might try using EXPLAIN from sql to determine what if any querry optimizations you should make.