can php optimize this

[jeromepelletier]

I have:


PHP Code:
$selectinputslimit=0;
$selectinputs="EXPLAIN SELECT * from inputtable order by ID DESC";
$selectinputs2=mysql_query($selectinputs) or die("Chat Error: 4052");
while(($selectinputs3=mysql_fetch_array($selectinputs)) && $selectinputslimit<20)
{

// some code here
if($wantedinput==1)
{
$selectinputslimit++;
}
else
{

}

}
print "$whateverwasabove";

Basicly, how would i go abouts turning the amount of things it looks throough to get it? When i explain it all the table is searched, i have ID indexed but cant think of a way to take advantage of this. In the code, it takes the data and puts it into 1 string and displays it afterwards but not everything i take i want to use, thats what the $selectinputslimit is for. Just dont know how to reduce what is searched, any ideas?


Is there a way for php to fix this?? or is it all SQL

[GJay]

that doesn't make a lot of sense.

Why are you using Explain? What are you trying to do?

[jeromepelletier]

that doesn't make a lot of sense.

Why are you using Explain? What are you trying to do?
I forgot to remove explain from it, before i came here i was seeing whatt he query was doing, when i explained it it went trhough every single row (30,000 plus rows and frowing every second)

[GJay]

it's still not clear what you're actually trying to do. When it comes to optimisation, knowing the context/purpose is fairly useful...

[Kid Charming]

There's another thread about this in the MySQL forum. Please don't crosspost.