使用MySQL数据库PHP中的计数填充List

Question

I am trying to create a list based off of results selected with a wildcard from a column in a MySQL database. I am able to do it, however it seems very slow, and probably the wrong way. Here is the code I am tinkering with now

$optarr = array("leather", "cruise", "tint", "sunroof", "moonroof", "navigation", "antilock");
 foreach ($optarr as $i) {
    $refquery = "SELECT stock, COUNT(stock) FROM vehicle_list AND options LIKE '%$i%'"; 
    $refresult = mysql_query($refquery) or die(mysql_error());
    $row = mysql_fetch_array($refresult);

    if ($row['COUNT(stock)'] != '0') {
    echo "".ucfirst($i)." (".$row['COUNT(stock)'].")<br />";
    }
}

This will output the following

Leather(234)
Cruise(343)
Tint(231)
Sunroof(343)
.....

This list will eventually be around 20-30 different filter options, right now at 4-5 I can see a substantial delay. I'm doing something wrong, Just don't know what. Maybe the entire approach?

The options column in the Database is an entire block of text separated by @ symbols so I am using the Like wildcard to extract vehicle options.

Thanks!

Answer 1

Make the database call prior to the foreach loop. This is calling the database on each loop and will be slow as expected.