Dynamic form from database

Expand Post »

I have code to propagate a drop down list that displays people's names. The problem is that the first name and last name are separate fields in the database, and I can only get the drop down list to display one of them. Here's my code:

php Syntax (Toggle Plain Text)
<?php 
$result = mysql_query("SELECT id, `first`, `last` FROM agents ORDER BY agents.id");
?>
 
<form name="Events" method="post" action="<?php echo $php_SELF;?>">
 
<table width="500" border="1" align="center" cellpadding="4" cellspacing="0">
<tr>
<td width="200" align="left">
<select name="Person" id="Person">
<option selected>Select</option>
 
<?php while ($row = mysql_fetch_array($result)){?>
<option><?php echo $row['last'];?></option>
<?php }?>
</select>
</td>
</tr>
</table>
</form>
<?php 
$result = mysql_query("SELECT id, `first`, `last` FROM agents ORDER BY agents.id");
?>

<form name="Events" method="post" action="<?php echo $php_SELF;?>">

<table width="500" border="1" align="center" cellpadding="4" cellspacing="0">
<tr>
<td width="200" align="left">
<select name="Person" id="Person">
<option selected>Select</option>

<?php while ($row = mysql_fetch_array($result)){?>
<option><?php echo $row['last'];?></option>
<?php }?>
</select>
</td>
</tr>
</table>
</form>

If I run this in my browser, I get a list of last names. How can I get both the first names and the last names?

Thanks

Last edited by peter_budo; Nov 28th, 2008 at 5:11 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

Similar Threads

updating multiple rows with one form in PHP
PHP Dynamic Form HELP! in PHP
dynamic row height in PHP
Storing dynamic form values in Arrays for display & insert in PHP
dynamic tables in ASP.NET

dewhickey

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

7 posts
since Sep 2007

Permalink

Nov 28th, 2008

Re: Dynamic form from database

Depends on what you expect to happen next. You can act both in PHP, manipulating the returned array result, or you can change your SQL so that sql returns the first and last name as one column, respectively as one value.

I would go with mysql change of the select statement like this.

PHP Syntax (Toggle Plain Text)
$result = mysql_query("SELECT id, concat(first, ' ',last) as fullname FROM agents ORDER BY agents.id");
$result = mysql_query("SELECT id, concat(first, ' ',last) as fullname FROM agents ORDER BY agents.id");

This code will return the first and last names with space between them.
Then you can access the fullname as associative array, using e.g.
$result_from_query['fullname'];

Try and advise if it works for you.
Also advise if you shall need to separate the names again e.g. during submit or something.

Last edited by Rhyan; Nov 28th, 2008 at 5:02 pm.

Rhyan

Reputation Points: 21

Solved Threads: 26

Posting Whiz in Training

Offline

240 posts
since Oct 2006

Permalink

Nov 28th, 2008

Re: Dynamic form from database

Thanks. That worked fine. Now, I just have to continue learning.

dewhickey

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

7 posts
since Sep 2007

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Problem with where clause or ....??

Next Thread in PHP Forum Timeline: How to set up a search that uses checkboxes?

DaniWeb Message

Cancel Changes

User Name
Password