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_fetc
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
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 yo
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 integrit
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-We
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 SELEC
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
: Re: [PHP-DB] Drop down box NOT populated
From: "Humberto Silva" <[EMAIL PROTECTED]>
> Instead of:
> > $row = mysql_fetch_array($sql)
>
> Use:
> $row = mysql_fetch_assoc($sql)
While I'm in the habit of doing that, using fetch_array() isn't going
From: "Humberto Silva" <[EMAIL PROTECTED]>
> Instead of:
> > $row = mysql_fetch_array($sql)
>
> Use:
> $row = mysql_fetch_assoc($sql)
While I'm in the habit of doing that, using fetch_array() isn't going to
cause any problems with regard to the original post. Which one you use is
really a matter
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Drop down box NOT populated
From: <[EMAIL PROTECTED]>
> Jsut a guess...
> Your row has a capital 'A' in the SQL statement, and a lower case 'a'
> in teh $row[] call..
>
> does that matter?
Yep, that would matter
From: <[EMAIL PROTECTED]>
> Jsut a guess...
> Your row has a capital 'A' in the SQL statement, and a lower case 'a' in
> teh $row[] call..
>
> does that matter?
Yep, that would matter, but not the exact problem. I don't know if this
thread has already been answered or not, so...
The real problem
Jsut a guess...
Your row has a capital 'A' in the SQL statement, and a lower case 'a' in
teh $row[] call..
does that matter?
"Larry Sandwick" <[EMAIL PROTECTED]>
22/01/2004 15:46
Please respond to
<[EMAIL PROTECTED]>
To
<[EMAIL PROTECTED]>
cc
Subject
[PHP-DB] Drop down box NOT populated
- Original Message -
From: Larry Sandwick
To: [EMAIL PROTECTED]
Sent: Thursday, January 22, 2004 3:46 PM
Subject: [PHP-DB] Drop down box NOT populated
Can anyone tell me what I am missing here,
The Select statement does not populate my drop down window?
My drop dow
Larry Sandwick wrote:
Can anyone tell me what I am missing here,
The Select statement does not populate my drop down window?
My drop down box is empty !
$how = mysql_query("SELECT count(distinct(account)) from Backlog") or
die ("Something bad happened: " . mysql_error());
$how_many = mysql_re
user a interface
>with less "clicks"? May be we can reach another interface approach which
>turn it possible.
>
>Jayme.
>
>
>-Mensagem Original-
>De: Ron Brogden <[EMAIL PROTECTED]>
>Para: <[EMAIL PROTECTED]>
>Enviada em: quinta-feira, 1 de
ser a interface
with less "clicks"? May be we can reach another interface approach which
turn it possible.
Jayme.
-Mensagem Original-
De: Ron Brogden <[EMAIL PROTECTED]>
Para: <[EMAIL PROTECTED]>
Enviada em: quinta-feira, 1 de março de 2001 18:48
Assunto: Re: [PHP-D
Here is my code:
---
Time
Channel
Summary
Select Date :
$current_date\n");
?>
$row[3]\n");
$id++;
}
}
?>
\n");
print("\n");
print("$row[1]$row[2]$row[4]\n");
print("$row[12]
(0$row[10]:0$row[11])$row[13]\n");
print("Starring :Shannen
Doher
At 06:32 PM 3/1/2001 -0300, you wrote:
>The action you want is only available using JavaScript.
True but the action *you* want is most definitely not what many of your
*users* are going to want. If you use Javascript this way your site will
be un-navigable if Javascript is turned off or the br
> The action you want is only available using JavaScript.
>
> You need to submit the form without a submit button.
> The "" tag has the "OnChange" event which is scriptable. You
> can use the JavaScript statement "this.form.submit();" associated
> with the "OnChange" event.
>
> ... ...
> ...
It
The action you want is only available using JavaScript.
You need to submit the form without a submit button.
The "" tag has the "OnChange" event which is scriptable. You can use
the JavaScript statement "this.form.submit();" associated with the
"OnChange" event.
... ...
...
HTH
Jayme.
-M
>From: Ben Cairns <[EMAIL PROTECTED]>
>To: php-db <[EMAIL PROTECTED]>
>Subject: RE: [PHP-DB] Drop down box
>Date: Thu, 1 Mar 2001 14:06:21 +
>
>Hope this helps
>
>-- Ben Cairns - Head Of Technical Operations
>intasept.COM
>Tel: 01332 365333
&g
Hope this helps
-- Ben Cairns - Head Of Technical Operations
intasept.COM
Tel: 01332 365333
Fax: 01332 346010
E-Mail: [EMAIL PROTECTED]
Web: http://www.intasept.com
"MAKING sense of
the INFORMATION
TECHNOLOGY age
@ WORK.."
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe
22 matches
Mail list logo