Re: [PHP-DB] Drop-down box in php
From: andy amol
>I am using the following code, but it is not populating my script. If
you can help I would be grateful.
> I am using mysql as database.
> $sql = "SELECT course_id FROM course";
> $sql_result = mysql_query($sql)
> or die("Couldn't execute query.");
> while ($row = mysql_fetch_array($sql_result)) {
> $type = $row["course_id"];
> $typedesc =$row["dept_id"];
> $option_block .= "$typedesc";
You're using ["dept_id"], but not selecting that column in your query.
---John Holmes...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Drop-down box in php
hi,
I am using the following code, but it is not populating my script. If you can help
I would be grateful.
I am using mysql as database.
$typedesc";
}
?>
thanks.
"John W. Holmes" <[EMAIL PROTECTED]> wrote:
From: "andy amol"
> I would like to know how to create and populate drop down boxes in php.
> I want the value to be populated from database.
> What I am try to do is to provide the forign key value as combo box
option, so that I do not have to check for referential integrity.
You still have to check. Just because you provide a discreet number of
options in a box doesn't mean that's really all the user can choosefrom. There are
many ways to manipulate the data.That being said, just create a loop as you draw items
from your database.echo '';
$sql = "SELECT name FROM products WHERE ...";
$result = query($sql);
while($row = fetch_assoc($result))
{ echo "{$row['name']}\n"; }
echo "";
I don't know what database you're using, so query() and fetch_assoc() are
generic.
---John Holmes...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
-
Do you Yahoo!?
Yahoo! Photos: High-quality 4x6 digital prints for 25¢
RE: [PHP-DB] Drop-down box in php
If it is a MySWL database, the following code works great
\n";
while ($view_list = mysql_fetch_array($result))
{
$view_code = $view_list[choice];
$view_desc = stripslashes($view_list[description]);
$viewing .= "$view_desc\n";
}
$viewing .= "";
?>
Of course you'll have to change it to fit your needs, but I just have a
while loop that gets the information and then dumps each line it gets
out to a temp variable. On the pages that include this one is where the
displaying comes out.
HTH,
Robert
-Original Message-
From: andy amol [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 20, 2004 11:53 AM
To: David Robley; [EMAIL PROTECTED]
Subject: [PHP-DB] Drop-down box in php
hi,
I would like to know how to create and populate drop down boxes in
php. I want the value to be populated from database. What I am try to do
is to provide the forign key value as combo box option, so that I do not
have to check for referential integrity.
Also if you can help me with a date validation program I will be
grateful.
Thanks in advance.
-
Do you Yahoo!?
Yahoo! Photos: High-quality 4x6 digital prints for 25¢
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Drop-down box in php
From: "andy amol" <[EMAIL PROTECTED]>
>I would like to know how to create and populate drop down boxes in php.
> I want the value to be populated from database.
> What I am try to do is to provide the forign key value as combo box
option, so that I do not have to check for referential integrity.
You still have to check. Just because you provide a discreet number of
options in a box doesn't mean that's really all the user can choose
from. There are many ways to manipulate the data.
That being said, just create a loop as you draw items from your database.
';
$sql = "SELECT name FROM products WHERE ...";
$result = query($sql);
while($row = fetch_assoc($result))
{ echo "{$row['name']}\n"; }
echo "";
I don't know what database you're using, so query() and fetch_assoc() are
generic.
---John Holmes...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Drop-down box in php
At 10:53 4/20/2004, andy amol, wrote: >hi, > >Also if you can help me with a date validation program I will be grateful. You could use a Regular Expression: http://tinyurl.com/yr6up http://www.Google.com/search?q=regular+expressions+site%3Aphp.net Start Here to Find It Fast! -> http://www.US-Webmasters.com/best-start-page/ $8.77 Domain Names -> http://domains.us-webmasters.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Drop-down box in php
You mean html dropdown-s?
print '';
$r = mysql_query("SELECT id, field1, fieldn FROM table WHERE fieldn = 'sg'");
while($RESULT = mysql_fetch_array($)) {
print ''.$RESULT['fieldn']'.';
}
print '';
Validating: just check the $_POST['sg'] value, against is_numeric(), then you can do a SELECT, to
check whether the id exists.
You can find some more examples, on php net manual pages
andrej
andy amol wrote:
hi,
I would like to know how to create and populate drop down boxes in php.
I want the value to be populated from database.
What I am try to do is to provide the forign key value as combo box option, so that I do not have to check for referential integrity.
Also if you can help me with a date validation program I will be grateful.
Thanks in advance.
-
Do you Yahoo!?
Yahoo! Photos: High-quality 4x6 digital prints for 25¢
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Drop-down box in php
I use html forms with select field size 1 and the option values and/or what is supposed to appear in the box. This you populate by your DB query, maybe using an array and a loop (from 0 to ..). Torsten andy amol schrieb: hi, I would like to know how to create and populate drop down boxes in php. I want the value to be populated from database. What I am try to do is to provide the forign key value as combo box option, so that I do not have to check for referential integrity. Also if you can help me with a date validation program I will be grateful. Thanks in advance. - Do you Yahoo!? Yahoo! Photos: High-quality 4x6 digital prints for 25¢ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
