Re: Count

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I am wanting to create an select menu for displaying the order of the item
on a page. I am guessing that I need to get the count of how many items are
in the db and them put them into a select menu.

Your question doesn't really make a great deal of sense. Your SQL could be:

SELECT COUNT(*) FROM your_table WHERE 1

Which will give you a single numeric value back (the number of rows). To put them into an HTML page:

<select name="mySelect">
    <option>Choose...</option>
    <option value="1">Foo</option>
</select>

This is a very basic select. You can simply loop through your query results adding more option tags to add more items to the select.

--
Richard Heyes
http://www.websupportsolutions.co.uk

Mailing list management service allowing you to reach your Customers
and increase your sales.

** NOW OFFERING FREE ACCOUNTS TO CHARITIES AND NON-PROFITS **

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux