Form list options

[NoDoze]

I have tis code already
[code]
<select name="clientcode" class="txtbox">
  <option value="1" selected></option>
<?php
$result = mysql_query("SELECT * FROM clienttype") or die(mysql_error());;
while($row = mysql_fetch_array($result))
{
    echo '<option value="' . $row['client'] .'"> ' . $row['client'] ."</option>\n  ";
}
?>
</select>
[/code]

As you see it pulls the list options from a table.

My questions is how do I modify this to add another table...So that it lists the two tables next to each other? Does that make sense?

See...each client has a code. The clients are in one table and the codes in another table. But on the form, the options list needs to show the client with their code...so I need the two tables listed next to each other so that the clients line up with their code, side by side.

I can't figure it out...

Thanks!

[NoDoze]

ok....

[code]
<select name="clientcode" class="txtbox">
  <option value="1" selected></option>
<?php
$result = mysql_query("SELECT * FROM clienttype") or die(mysql_error());;
while($row = mysql_fetch_array($result))
{
    echo '<option value="' . $row['client'] .'"> ' . $row['client'] ."</option>\n  ";
    echo '<option value="' . $row['code'] .'"> ' . $row['code'] ."</option>\n  ";
}
?>
</select>
[/code]

This gets the lists like this:
client
code
client
code

BUT I need it like this:
client  code
client  code

Any help?

[pocobueno1388]

[code]

<select name="clientcode" class="txtbox">
  <option value="1" selected></option>
<?php
$result = mysql_query("SELECT * FROM clienttype") or die(mysql_error());;
while($row = mysql_fetch_array($result))
{

    echo '<option value="' . $row['client'] .'"> ' . $row['client'] $row['code']."</option>\n  ";

}
?>
</select>

[/code]

Not sure if that will work or not...I don't see why it wouldn't...

[NoDoze]

It's not working...I get a blank page, suspecting it doesn't like the code....Hmmm....

Anyone with any other ideas?

Looks fairly simple, but it's got us stumped...?

[Jessica]

There is a syntax error here:
  echo '<option value="' . $row['client'] .'"> ' . $row['client'] $row['code']."</option>\n  ";
change it to
  echo '<option value="'. $row['client'] .'"> ' . $row['client'].$row['code']."</option>\n  ";

[NoDoze]

SWEET! AWESOME! It worked! :)

At first it was:
client
code
client
code

Now it's:
clientcode
clientcode

Just need the spaces...?

Hmmm...

I'm glad that hard part is over with! ;)

[Jessica]

echo '<option value="' . $row['client'] .'"> ' . $row['client'].'<br />'.$row['code']."</option>\n  ";

[NoDoze]

AWESOME! THANK YOU!

Where have you been! Quickest and best response ever!

Thank you!

[Jessica]

Yeah there was supposed to be a br in there.
You might want to brush up on the BASICS of HTML.

[NoDoze]

A <br> ...?

In this code?

echo '<option value="' . $row['client'] .'"> ' . $row['client'].'
'.$row['code']."</option>\n  ";

But that's in php...not html...

...so you're saying it'd be like '<br>'
or "<br>"
???

Well, it works now is mainly what I was concerned about...You're earlier suggestion was suffecient.
But didn't think a <br> would suffice too...Dunno how that'd play in...

[pocobueno1388]

It is a mix of PHP and HTML toghether. The <option value=""> is HTML that is coded with PHP inside that string. Understand? ^^

[NoDoze]

Yup, I already know that....just don't understand how brushing up on my html would help with a php question...

I guess she's suggesting a "<br>" would work also...???