Re: [PHP-DB] Problem with select-tag within a php-script

2003-07-03 Thread - Edwin -
Hi,

Ruprecht Helms [EMAIL PROTECTED] wrote:

[snip]
 while($row = mysql_fetch_object($result))
 {
 echo option value=\'.$row-ID.\';
[/snip]

Should be:

  echo option value=' .$row-ID. ';

 ?

- E -
__
Do You Yahoo!?
Yahoo! BB is Broadband by Yahoo!
http://bb.yahoo.co.jp/


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



[PHP-DB] Problem with select-tag within a php-script

2003-07-02 Thread Ruprecht Helms
Hi,

I've some trouble with a select-tag in a php-script.
In a database should be written the ID of a table, the user could select
the recordset by the Name. My problem is that the fieldentry of the
selecttag is not transfered to the executionscript. The different Names
within the recordset are shown correctly.

Here my listing

?
mysql_connect(localhost,root);
$result=mysql_db_query(chorportal,SELECT * FROM choere ORDER BY
Name);
echo select value='chorid';
while($row = mysql_fetch_object($result))
{
echo option value=\'.$row-ID.\';
echo $row-Name;
echo /option;
}
echo /select;
?

Regards,
Ruprecht


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



RE: [PHP-DB] Problem with select-tag within a php-script

2003-07-02 Thread Snijders, Mark
the select has to be a name and not the id

the id has to be within the option value!



-Original Message-
From: Ruprecht Helms [mailto:[EMAIL PROTECTED]
Sent: woensdag 2 juli 2003 15:51
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Problem with select-tag within a php-script


Hi,

I've some trouble with a select-tag in a php-script.
In a database should be written the ID of a table, the user could select
the recordset by the Name. My problem is that the fieldentry of the
selecttag is not transfered to the executionscript. The different Names
within the recordset are shown correctly.

Here my listing

?
mysql_connect(localhost,root);
$result=mysql_db_query(chorportal,SELECT * FROM choere ORDER BY
Name);
echo select value='chorid';
while($row = mysql_fetch_object($result))
{
echo option value=\'.$row-ID.\';
echo $row-Name;
echo /option;
}
echo /select;
?

Regards,
Ruprecht


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