How to relate database info in a select file??

[Rambaldi]

Categoria:<select name="categoria"> 
<option value="<?php echo $categoria;?>" SELECTED><?php echo $categoria;?></option> 
<option value="Geral">cat1</option> 
<option value="2">cat2</option> 
<option value="3">cat3</option> 
<option value="4">cat4</option> 
<option value="5">cat5</option> 
<option value="6">cat6</option> 
</select> <br>

[Please use CODE tags when posting source code. Thanks! --pbmods]

the question is: the camps where is named cat1, cat2, etc... how i can put values from the database???
I know how to open and do the query's but i dont know how to put in the select camps

[nathj]

Hi,

I have done just this sort of thing to display a drop down box of country names based on a table in a database. Here is the code I used and obviously this relies on my particular data strucutre but you should be able to modify it.

 
// get the data
$lcSelectStr = 
            "SELECT 
            a.ID, a.countryName as description, a.isDefault
            FROM countrycode a
            ORDER BY a.countryName ASC";    
$laResults=$loDB->queryGetData($lcSelectStr); // using a data abstraction layer
 
// loop through the results loading them into the drop down
echo "<select id='list1'>"; // this is actually dynamic for me based on another variable 
           foreach($laResults as $lcDataLine)
        {               
            echo "<option value=" ."'" . $lcDataLine['ID'] . "'" ;
            if($lcDataLine['isDefault'])
            {
                echo "selected='selected'";
            }
            echo ">" . $lcDataLine['description'] ."</option>";
        }
        echo "</select>";
 

So having retreived the data you run through the array that is set and load each item into the drop down. I have an extra check so that the default can be set. As my site will be aimed at UK residents I set the UK as the default to save them looking through the list for it.

If you have any questions about this then give me a shout and I'll do my best to help you out further.
nathj

[Rambaldi]

Thanks my friend, this code help me to organize my categories []

Another similar situation:

How can i get values from links???

I mean, imagine that the client wanna search videos through categories.

Instead put the categories by select boxes, i could show them by normal links that whe a client press it, the next page would show all the videos from the category selected.

my question is: how i can identify each category by is id and how i can save the id on the next page so i could use it to make a query to find the videos???

if y'all didnt understand, alert me ;)

Rambaldi

[nathj]

Thanks my friend, this code help me to organize my categories []

Another similar situation:

How can i get values from links???

I mean, imagine that the client wanna search videos through categories.

Instead put the categories by select boxes, i could show them by normal links that whe a client press it, the next page would show all the videos from the category selected.

my question is: how i can identify each category by is id and how i can save the id on the next page so i could use it to make a query to find the videos???

if y'all didnt understand, alert me ;)

Rambaldi

It sounds to me like the links to the categories need to end with ?id=xx where xx is the id of the category so that on the next page yu can used $_GET['id'] to retreive the data from the database. This means that one page could be used to chow videos of any category.

If you do not have a database then array or a formatted text file could serve as a useful substitue.

It is definitley a query string you require though.

Cheers
nathj