SQL question

[hitmike]

SQL ----

$unique_model = $db->Execute("SELECT DISTINCT products_model FROM products");

Display ----

while (!$unique_model->EOF) {
echo $unique_model->fields['products_model'];
$unique_model->MoveNext();
}

This will echo out the names as long as your query is bringing back the distinct values. You can also add code to it such as links. To setup the correct reference you may have to build a more complex query.

Example:

echo '<a href="link code" alt="alt name" />'.$unique_model->fields['products_model'].'</a>';

[DigitalShadow]

hitmike could you help build that for me, as that is exactly what i am looking to do.

Have the generated list become clickable and result in each item searching the shop... you follow?

[DigitalShadow]

yay! Thank you all

<?php

$unique_model = $db->Execute("SELECT DISTINCT products_model_number FROM `zen_products_description`ORDER BY products_model_number ASC");

while (!$unique_model->EOF) {
echo '<a href="http://website-here.com/index.php?main_page=advanced_search_result&search_in_description=1&keyword='.$un ique_model->fields['products_model_number'].'" alt="alt name" />'.$unique_model->fields['products_model_number'].'</a><br />';
$unique_model->MoveNext();
}

?>

[DigitalShadow]

Ok one last question, how would I get the above code to only show results from one manufactuers_id? something using left join?

manufactuers_id is in zen_products and products_model_number is in zen_products_description

[DigitalShadow]

Done it

<?php

$unique_model = $db->Execute("SELECT DISTINCT pd.products_model_number, p.manufacturers_id FROM " . TABLE_PRODUCTS_DESCRIPTION . " pd LEFT JOIN " . TABLE_PRODUCTS . " p ON pd.products_id = p.products_id WHERE p.manufacturers_id = '2' ORDER BY pd.products_model_number ASC");

while (!$unique_model->EOF) {
echo '<a href="http://webdomain.com/index.php?main_page=advanced_search_result&search_in_description=1&keyword='.$un ique_model->fields['products_model_number'].'" alt="alt name" />'.$unique_model->fields['products_model_number'].'</a><br />';
$unique_model->MoveNext();
}

?>

[DigitalShadow]

Deleted post...

[DigitalShadow]

Is it possible to go through each manufacturers_id one by one and generate a different list each time without me having to have separate php statements for each manufacturers_id?

<?php

$manufacturers = $db->Execute("SELECT manufacturers_name FROM zen_manufacturers WHERE manufacturers_id = '2'");
$unique_model = $db->Execute("SELECT DISTINCT pd.products_model_number, p.manufacturers_id FROM " . TABLE_PRODUCTS_DESCRIPTION . " pd LEFT JOIN " . TABLE_PRODUCTS . " p ON pd.products_id = p.products_id WHERE p.manufacturers_id = '2' ORDER BY pd.products_model_number ASC");

echo $manufacturers->fields['manufacturers_name'];

while (!$unique_model->EOF) {
echo '<a href="http://webdomain.com/index.php?main_page=advanced_search_result&search_in_description=1&keyword='.$un ique_model->fields['products_model_number'].'" alt="alt name" />'.$unique_model->fields['products_model_number'].'</a><br />';
$unique_model->MoveNext();
}

?>

[DigitalShadow]

The generated list is quite long even when split into the different manufacturers, what I want to know is it possible to make the generated list split into different div columns? Is it possible to get the outputted list to spread itself across 4 div columns?

I'm using the following code

<?php
$manufacturers1 = $db->Execute("SELECT manufacturers_name FROM zen_manufacturers WHERE manufacturers_id = '1'");
$unique_model1 = $db->Execute("SELECT DISTINCT pd.products_model_number, p.manufacturers_id FROM " . TABLE_PRODUCTS_DESCRIPTION . " pd LEFT JOIN " . TABLE_PRODUCTS . " p ON pd.products_id = p.products_id WHERE p.manufacturers_id = '1' ORDER BY pd.products_model_number ASC");
?>

<?php echo '<h3>'.$manufacturers1->fields['manufacturers_name'].' Some text here:</h3>'; ?> 
<ul id="list" class="model-list">

<?php
echo "<br /><br />";
while (!$unique_model1->EOF) {
echo '<li class="list-item"><a href="http://webdomain.co.uk/index.php?main_page=advanced_search_result&search_in_description=1&keyword='.$unique_model1->fields['products_model_number'].'" alt="alt name" /><font color="#0099cc">'.$unique_model1->fields['products_model_number'].'</font></a></li>' . "\n";
$unique_model1->MoveNext();
}
?>

</ul>

[DigitalShadow]

any ideas?

[DigitalShadow]

So to recap my last two requests are to have the php script generate separate lists for each of the manufacturers_id, i.e. start at "1" and end at the last number

Other request is to have the outputted list spread itself across four columns automatically. Just need it to after "x" results place a </div> and then start a new <div> for a new column.

Also would be nice if the first request could then be sorted alphabetically by the manufacturers name "ORDER BY manufacturers_name ASC"