CSS Menu writer

Is there a tutorial to create a menu bar of the alphabet ABC…

I need it to work where a user clicks on the letter A and all the products that start with that letter will appear on the results page in alphabetical order.

Thanks

no, there is not a tutorial for this

first create the recordset to return all products

You would need to set the links to pass the letter as a URL variable:

page.php?sort=a

go to the bindings panel, click the plus button and add a new url variable binding named "sort"

then use data assist search. open the server behaviors panel and click the plus button, select WebAssist -> DataAssist -> dataAssist Search

for the trigger, click the lightning bolt icon and select the sort url variable.

add a new criteria, select the product name column, use the Begins With comparison.

in the filter type, select Key Word, for the filter value click the lightning bolt icon and select the sort url variable.

Okay I set all that up, thanks. Now do I go and use CSS Menu Writer to create my nav bar?

you could use CSS Menu writer, or add it another way, the key is to add the letters in url variable variable.

Okay, thank you

So the link for the letter "A" would be "results.php?sort=A"

yes, that is correct.

Here is what I get:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0, 10' at line 1

See PM

I'll need to troubleshoot directly, see the private message section.

I sent the file in the previous reply. I am developing on my local server so there's no address to send you. If you don't see the issue then I will upload it to a staging server