Simon
|
| Posted: 09/04/2002, 3:39 PM |
|
I have 2 tables in a mysql database with following fields:
"Profiler" "Grupper"
profil_id (integer) prim.key gruppe_id (integer) primary key
gruppe_id (integer) gruppe_text (varchar)
...and some other records but they are not relevant.
I have on a search form a listbox. I want to populate this
listbox with "gruppe_text" from the table "grupper", and each
"gruppe_text" entry refering to a "gruppe_id".
How is that done in CCS and PHP?
I have been messing around a lot, but either i can only get it populated
with the gruppe_id's or nothing at all just a long list of empty spaces.
TIA
|
|
|
|
Joachim Uersfeld
|
| Posted: 09/05/2002, 1:08 AM |
|
It is described in one of the tutorials at http://support.codecharge.com/tutorials.asp. You can find an solution in German language at http://www.devdata.de/ccsh/ccshilfe.htm.
|
|
|
|
Simon
|
| Posted: 09/05/2002, 11:25 AM |
|
Thanx, it works... and its simple :)
|
|
|
|
mrvanjohnson
|
| Posted: 09/05/2002, 12:23 PM |
|
Sounds like you've almost have it.
"I have been messing around a lot, but either i can only get it populated
with the gruppe_id's or nothing at all just a long list of empty spaces."
This usually happens when you forget to change the Type from Integer to Text. What happens is it see a field full of characters when it is expecting numbers and so it just puts blanks up. I know, I've done it before. One of those things you trouble shot from a dozen different angles and then do a Homer Simpson "DUH" when you realize how basic it was to fix..
Hope this helps.
|
|
|
|
|
|
