Posted by jsd219 on 06/14/07 17:55

On Jun 14, 12:31 pm, ZeldorBlat <zeldorb...@gmail.com> wrote:
> On Jun 14, 12:23 pm, jsd219 <i...@musiclanerecording.com> wrote:
>
>
>
> > here is my code:
>
> > $query = "SELECT SEC_TITLE
> > FROM section
> > WHERE SEC_TITLE != ''";
>
> > $result = mysql_query($query);
>
> > echo "<form action='#'>\r\n<select name='section'>\r\n";
> > while ($row = mysql_fetch_array($result, MYSQL_NUM))
> > {
> > echo " <option value='{$section[0]}'>$row[0]\r\n";
>
> > }
>
> > It works great but I need it to also select the ID from the section
> > table without displaying it. so the client only sees a drop down box
> > with the section titles but when they select one and send the form it
> > will send both the section title and sec id
>
> > I have tried changing the SELECT SEC_TITLE to SELECT SEC_TITLE, SEC_ID
> > but i am lost from there.
>
> > Anyone please :-)
>
> > God bless
> > jason
>
> Change your query as you described above, then replace section[0] (not
> sure what that was anyway) with row[1].

Actually turns out the above code was not working properly. it needs
to be this:

$query = "SELECT SEC_TITLE
FROM section
WHERE SEC_TITLE != ''";

$result = mysql_query($query);

echo "<form action='#'>\r\n<select name=section>\r\n";
while ($line = mysql_fetch_array($result, MYSQL_NUM)) {
$section = $line[0];

echo " <option value=$section>$section\r\n";
}

This allows the client to select a section from a dynamically
generated drop down box, when they submit the form whatever section
they selected get placed in the section field of the new row in the
category table. i need the ids from the section table to be the same
as the corresponding categories added. so if i create a section called
Jack and it has an (auto increment) id of 1. And then i create a
category called Jack's Pale by selecting Jack from my drop down box.
My category table should populate a row with the CAT_TITLE=Jack's
Pale, CAT_SECTION=Jack and CAT_ID=1

Everything is working except i can not figure out how to grab the
SEC_ID and send it along with the SEC_TITLE

[Back to original message]