|
Posted by Jim S on 07/18/06 14:17
Is there a simple method to return the value of a selected field in a
form to a php variable?
IE--I want to be able to use the result of this form as a constraint in
the query to populate another drop down box. Do I need to use the HTML
post/get methods if I am still within the same php script?
Jim S wrote:
> I think I am just missing something silly. I have tested my query and
> it seems to be functioning fine. I have another similar query that runs
> just before this one so the issue isn't a connection. If you have any
> other questions I'd be happy to answer them.
>
> Platform: mysql 3.x, php5
>
> <?php
> $res=mysql_query("SELECT job_name FROM oats_jobs_users_laborCode where
> user='$username' order by job_name");
> echo "<select name=jobname> <option default='default'>Choose
> One</option>";
> for ($i=0; $row=mysql_fetch_assoc($res); $i++)
> {
> echo "<option value='<? echo $row[0];?>'><? echo
> $row[0];?></option>";
> }
> echo "</select>";
> ?>
Navigation:
[Reply to this message]
|