[PHP] question on listbox.
Hello friends.
I have a listbox which I populate from a query with the database. It is working fine.
But additinally, I want the first item to be Select category. Can someone please
help me how to modify by below written code to do the above?
My code : Quote :
?php
//connecting to the database
$link = mysql_connect(localhost,MyDomain,MyPass);
if ($link){
Print ;
} else {
Print No connection to the database;
}
if (!mysql_select_db(MyDomain_com)){
Print Couldn't connect database;
} else {
Print .br\n;
}
$sql=SELECT DISTINCT CategoryName From Categories ORDER BY CategoryName;
$result=mysql_query($sql);
While($Category=mysql_fetch_array($result))
{
Print(OPTION VALUE=\$Category[0]\$Category[0]\n);
}
?
Unquote
Thanks very much
Denis
Re: [PHP] question on listbox.
On Saturday 01 February 2003 19:08, Denis L. Menezes wrote:
Hello friends.
I have a listbox which I populate from a query with the database. It is
working fine. But additinally, I want the first item to be Select
category. Can someone please help me how to modify by below written code
to do the above?
My code : Quote :
?php
//connecting to the database
$link = mysql_connect(localhost,MyDomain,MyPass);
if ($link){
Print ;
} else {
Print No connection to the database;
}
if (!mysql_select_db(MyDomain_com)){
Print Couldn't connect database;
} else {
Print .br\n;
}
echo option ...;
$sql=SELECT DISTINCT CategoryName From Categories ORDER BY CategoryName;
$result=mysql_query($sql);
While($Category=mysql_fetch_array($result))
{
Print(OPTION VALUE=\$Category[0]\$Category[0]\n);
}
?
Unquote
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
--
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-general
--
/*
If you are good, you will be assigned all the work. If you are real
good, you will get out of it.
*/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] question on listbox.
- Original Message -
From: Denis L. Menezes [EMAIL PROTECTED]
To: PHP general list [EMAIL PROTECTED]
Sent: Saturday, February 01, 2003 6:08 AM
Subject: [PHP] question on listbox.
Hello friends.
I have a listbox which I populate from a query with the database. It is
working fine. But additinally, I want the first item to be Select
category. Can someone please help me how to modify by below written code
to do the above?
something like this would do it:
$valueToSelect = 'foo';
{
Print(OPTION VALUE=\{$Category[0]}\
$selected = ($Category[0] == $valueToSelect) ? ' selected' : '';
Print($selected);
Print({$Category[0]}\n);
}
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] question on listbox.
Thanks Jason.
Looks like I am too dumb. I still cannot do it. can u please help me
further?
Thanks
Denis
- Original Message -
From: Jason Wong [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, February 01, 2003 8:21 PM
Subject: Re: [PHP] question on listbox.
On Saturday 01 February 2003 19:08, Denis L. Menezes wrote:
Hello friends.
I have a listbox which I populate from a query with the database. It is
working fine. But additinally, I want the first item to be Select
category. Can someone please help me how to modify by below written
code
to do the above?
My code : Quote :
?php
//connecting to the database
$link = mysql_connect(localhost,MyDomain,MyPass);
if ($link){
Print ;
} else {
Print No connection to the database;
}
if (!mysql_select_db(MyDomain_com)){
Print Couldn't connect database;
} else {
Print .br\n;
}
echo option ...;
$sql=SELECT DISTINCT CategoryName From Categories ORDER BY
CategoryName;
$result=mysql_query($sql);
While($Category=mysql_fetch_array($result))
{
Print(OPTION VALUE=\$Category[0]\$Category[0]\n);
}
?
Unquote
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
--
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-general
--
/*
If you are good, you will be assigned all the work. If you are real
good, you will get out of it.
*/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] question on listbox.
On Saturday 01 February 2003 20:40, Denis L. Menezes wrote:
Please don't top-post.
Looks like I am too dumb. I still cannot do it. can u please help me
further?
I could write out the complete code for you -- but then I'll have to charge
you for it :-)
OTOH I can walk you through the process (in doing so it will, hopefully, help
you solve your own problems) -- not that there is much of a process as it is
frankly, really basic HTML.
I have a listbox which I populate from a query with the database. It is
working fine. But additinally, I want the first item to be Select
category. Can someone please help me how to modify by below written
code
to do the above?
Can I assume that you are at least familiar with basic HTML? If not, then you
really ought get up to speed on HTML before playing with PHP.
OK, you want to display a select box. A properly written select box would look
something like:
select name=category
option value=28Basket/option
option value=21Bathroom/option
option value=08Bird feeder/option
/select
You want to add an extra option to it, AND you want the extra item to be
displayed first, so it would now look like:
select name=category
option value=%ANY CATEGORY/option
option value=28Basket/option
option value=21Bathroom/option
option value=08Bird feeder/option
/select
So, look at your code and determine how/where you would insert that extra
item. I've already indicated previously _where_ the extra code should go, and
also hinted at _how_. It is a simple matter for you to fill in the blanks (or
... to be precise).
Also, do note that your code at present does not output well formed HTML. You
may want to fix that.
My code : Quote :
?php
//connecting to the database
$link = mysql_connect(localhost,MyDomain,MyPass);
if ($link){
Print ;
} else {
Print No connection to the database;
}
if (!mysql_select_db(MyDomain_com)){
Print Couldn't connect database;
} else {
Print .br\n;
}
echo option ...;
$sql=SELECT DISTINCT CategoryName From Categories ORDER BY
CategoryName;
$result=mysql_query($sql);
While($Category=mysql_fetch_array($result))
{
Print(OPTION VALUE=\$Category[0]\$Category[0]\n);
}
?
Unquote
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
--
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-general
--
/*
I hope you will find the courage to keep on living
despite the existence of this feature.
- Richard Stallman
*/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] question on listbox.
Might this be better?
print select name=category_selection\n;
print option value=0Select Category/option\n
//Query
$sql=SELECT DISTINCT CategoryName From Categories ORDER BY CategoryName;
$result=mysql_query($sql);
if ($result)
{
While($Category=mysql_fetch_array($result))
{
PrintOPTION VALUE=\$Category['auto']\$Category['name']/option\n;
}
mysql_free_result($result[$a]);
print /select\n;
}
Leonard.
www.phpna.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
