[jQuery] Re: jquery, php question (Probably the wrong place to ask)

[Greg Evans]

Thanks a bunch. I didn't even notice that I had forgot to close stuff,  
I am sure that error would have been glaring out at me had I paid  
closer attention. :)

Next question, and I am now going to make an ass of myself more than I  
already have and assume that this part actually does relate to jQuery :)

Now, with the fixes below, it works, but when I go to display the  
fields, it clears the entire page and just displays the fields. I  
would like them to appear in the dialog that I am using. I would guess  
that there is some probably not too fancy jQuery stuff I need to do??  
I will be messing around with it and trying to figure it out today  
(this is the last major stumbling block on my UI), but any help would  
be appreciated :)



On Jul 22, 2009, at 4:23 AM, p_W wrote:


lol forgot to close the tags myself...

document.write("<tr><td><input type=\"text\" name=\"c\" + i + \"\"></
td></tr>");

or

document.write("<tr><td><input type='text' name='c' + i + ''></td></
tr>");




On Jul 22, 7:22 am, p_W <paulwoolcoc...@gmail.com> wrote:
I'm not quite sure about your question, but I will say that I see  
some
problems with your code...

In the document.write(); function, I see 2 main problems...

one is that it doesn't look like you are closing your <tr><td>
tags...after the input tag you should add </td></tr>

The other is in the name="" attribute of the input tag...it looks  
like
you are escaping some but not all of your quotes, and not including a
closing paren for the .write function.  It should be like this:

document.write("<tr><td><input type=\"text\" name=\"c\" + i +  
\"\">");

or if that looks too confusing, use single quotes inside, like this:

document.write("<tr><td><input type='text' name='c' + i + ''>");

On Jul 21, 5:16 pm, Greg Evans <greg.djr...@gmail.com> wrote:

The code now is like this:

<div id="dialog" title="Create Manifest">
                                         <form id="myForm"  
action="pl/
newload.pl" method="post">
                                         <table>
                                                 <td>Chest:</td>
                                                 <td><SELECT
NAME="Aircraft">
                                                         <option>
                                                                <? 
php
                                                                        $ 
user="user";

$password="pass";

$database="completChest";

mysql_connect('127.0.0.1',$user,$password);

@mysql_select_db($database) or die( "Unable to select database");

$query="SELECT * from Chests where chest_active=1";
                                                                        $ 
result =
mysql_query($query);
                                                                        while
($myinfo= mysql_fetch_row($result)) {

print "<option onselect( populate($myinfo[5]) ) value= 
\"$myinfo[0]\">".
$myinfo[2]." ".$myinfo[3]." ".$myinfo[1];
                                                                        }
                                                                        ?>
                                                        </select></ 
td><tr>
                                                        <tr><td
colspan="2">Items in Chest</td>
                                                                  
<script type="text/
javascript">
                                                                 
function
populate(max_chest){

for(var i=0;i<=max_chest;i++){

document.write("<tr><td><input type=\"text\" name=\"c"+i+"\">";
                                                                        }
                                                                }
                                                 </script>
                                         </table>
                                         </form>
                                 </div>

On Jul 21, 2009, at 1:41 PM, Glazz wrote:

Hi,

What is the code that you now? If you have none we can help you  
create
the code you need

But you are going to use $.ajax() to get the numbers that you are
talking about from the MySQL table.

And then you can update the form as your needs.

Btw, im a neewbie too but i can help in what i can :)

Regards,
Bruno.

On 21 Jul, 21:24, raisputin <greg.djr...@gmail.com> wrote:
Hello, newb here ;)

This is probably the wrong place to ask, but maybe someone could
point
me in the right direction if that is the case :)

I am pulling data from a mysql database to partially populate a  
form.
This is all done in a 'dialog' which is really slick, so when I  
open
that dialog, i get (please excuse the crude drawings)

Dropdown menu
[ Chest 1 ]
[ Chest 2 ]
[ etc...     ]

That part I have working fine, what I need to do now is make it so
that when someone selects Chest_N it will populate the form with  
say
the number of drawers in that chest as each chest may have any  
number
of drawers (within reason of course). The information for each  
chest,
such as mfr, etc. and including the number of drawers is stored in
the
'chests' table in mysql like

Table: Chests
chest_id
chest_name
chest_color
chest_serial
chest_num_drawers

so when I select a chest in the dropdown, I need to create fields
like
"Drawer 1 - Drawer N" as text boxes in the form. The mySQL  
queries I
can do as that is super simple, I am just not sure how to make  
it do
the query once a chest is selected.

Any help appreciated, and if I am asking in the wrong place, a
direction to the proper place to ask would also be appreciated. :)

Thanks in advance