leeroy1

I'm trying to create something like the sql below to automatically insert several records into a table. Then once it's done I need the page to automatically forward to another php page. Is this possible? I'm also trying to design the page so that the user can enter a starting number such as 5 and then col35 in tbl95 will sequentially add numbers for each record added. I'm not sure where to begin for all this though. Can dreamweaver do it? INSERT INTO tbl95 ( col13, col2, col27, col28, col30, col31, col32, col33, col34 ) SELECT view1.col23, view1.col2, view1.physician, view1.totaltopay, view1.col4, view1.col5, view1.col6, view1.col7, view1.col8 FROM view1 WHERE (((view1.col23)=recordid66))

Is it possible to execute a sql statement or something in order to check if a field a user has enter already exists in a table, and if it does tells the user and does not try to submit the form? Or is there a better way to do this?

Yes, this has been done already. This is the page number with the parameter added: page2.php?recordid41=<?php echo $_GET['recordid41']; ?> The problem is, is that the url parameter is not submitted, it's lost. When the page reloads with the search I get this url: page2.php?a99b=t&Submit=Search The a99b was a paramter of a query, but the 'recordid41' is nowhere.

I have a search form on a page(page2.php) that lists the results of the search on the same page after the form is submitted.. When you first visit this page it includes a url parameter (recordid41),that it received from the previous page. Whenever I then do a search, it loses the url parameter. How can I fix this? On the "form" properties I've included page2.php?recordid41=<?php echo $_GET['recordid41']; ?> for the page that it's suppose to go to after submitted but this doesn't work. It errors with: Notice: Undefined index: recordid41 in c:\test\page2.php on line 340

I thought I was using css with my layers. Do you have an CSS example that would overlap and be on top?

I have a layer that I'm using as a drop down menu for my site. Problem is that it does not overlap menu/list box's in forms. It's kind of weird. When the layer appears it will overlap(be on top) of everything on the page except for any menu/list boxes that might be in any forms on the page. Not sure if there's a reason for this or not.

I'm not sure where to start with file uploading. Can someone suggest some good tutorials or anything that would help me out. I'm interested in uploading pdf to the server.

I have a form that adds a new record. On submit I'd like it to submit it to an "edit" page where the user can edit the record they just created. How can I get the record id into the url parameter in order to do this?

i've tried inserting php code into the "Go to after inserting" page of a "Insert Record" form. dreamweaver seems to only like actual page entries like test.php. if i try and put a url paramater that equals a page link the form breaks and dreamweaver erases half the code automatically. does anyone know of a way to create a form in dreamweaver but assign the page it goes to after submitting to a "dynamic" entry.

As a newbee i just created a page like that myself a couple months ago. Just set the defaults for the parameters to 9999999999 or some record that doesn't exist. That way records will not show up when the page first opens. Also, use the server behaviour that hides results if no records exist can help make the page look better too.

I'm having the exact same problem. My table has border="0" cellspacing="0" cellpadding="0" and it still pushes the cell height about double than it needs to be.

I have a record set with record id in a repeating region on my page. It can show a max of 10 records at a time. When I click the "View Details" link I have in each repeated region I need it to open that specific record using a session variable. I've included the session variable in one of the repeated regions, but when I click on any of the events it always pulls the record id/session variable of the very last record instead of the one I've clicked on. Where exactly should I declare the session variable?

dreamweaver always pushes my session start php info down past the recordset info. so, my code for the recordset never get's to use my session variables properly. is there some way to have dreamweaver input the session start code instead of me doing it manually so that it doesn't try to move my code around?

i checked my code over. looks like dw pushed the start session info past my recordset. put it at the top of the page and now it works fine.

i've created a simple record set that is filtered by a session variable. but the session variable doesn't take. it always defaults to whatever the default is set for the variable in the recordset settings page. i would think this is because it can't find the session variable, but i can list the session variable on the same page no problem in order to verify it's actually keeping the session alive. i checked the spelling of the variables as well and everything looks good. not sure what else to check. i've tried it on a new page right from scratch as well but still doesn't work. is there anything else i can look for?