[RESOLVED] set pull-down variable

[chrisj8221]

Once again after consulting book after book and researching the web - I am stuck.

I have created a pull-down menu bar that is populated from a table in my database - code snippet follows...

<?php
// populate project pull-down menu
$query_projpull = "SELECT cds_proj_id, cds_proj_name FROM cds_projects ORDER BY cds_proj_name ASC"; 
$pull_proj = @mysql_query ($query_projpull); 
$pulldown_proj = '<option>- - Choose Project - - </option>'; 

while ($row = mysql_fetch_array ($pull_proj, MYSQL_ASSOC)) { 
$pulldown_proj .= "<option value=\"{$row['cds_proj_id']}\">{$row['cds_proj_name']}</option>\n"; 
} 

// create form for user input utilizing dbase populated pull-down
<form action="proj_form_dbase_insert.php" method="post">

	<div align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
	<b>Project Client :</b><br /><select name="cds_user_company"> 
	  <?php 
		echo $pulldown_client; ?> 
		</select></div><br />

What I would like to do is to assign a value to the choosen pull-down value that is passed to the next page for inclusion in a SELECT statement.

The first page where the user will select a value is
www.cdsplan.com/logs/logs.php

the second page would look something like this
http://www.cdsplan.com/logs/logs_view.php

second page is all records in table right now, but would like to be able to select only entries with a particular client.

thanks in advance.

chris

[Houdini]

How is the data stored in your database as an enum like "yes' , 'no' or a boolean like 0 or 1 or just how are these fields accessed. You will need to run a check to see if the expected values are in the database and then set the option to checked if that is true or equal to a variable of some sort.

[chrisj8221]

client data is stored in cds_users table as a varchar - examples would be company name 1, company name 2, project name 2, project name4, etc.

client data is reference in the cds_projects table as varchar also but with typical row number to reference cds_users record - 1, 24, 56, etc.

If the visitor chooses "sample company" from the pull down menu, I am assuming the thing to do would be to assign $company = sample company then pass to second page for SELECT code. But I could be way, way off on what I am trying to do.

hopefully the webpages as linked above can help explain where I am starting from

chris