spraypray12

I've tested diffferent tables, and made new ones, with id set to auto_increment and still returns zero everytime. Won't work in mysql query browser, or in php script. Mysql version 4.1.20 for server

Right now i have a form like this: www.redmond.k12.or.us/rhs/php/orderform/form.php I have a table with these columns: Date,Requestor,Student_Body,District,Grant_or_Other,Vendor_Name,Address, Address_Line_2,Phone,Fax,q1,q2,q3,q4,q5,q6,c1,c2,c3,c4,c5,c6,d1,d2,d3,d4,d5,d6,p1, p2,p3,p4,p5,p6,e1,e2,e3,e4,e5,e6,Shipping_Estimate,Total I want to split into something like this: order_desc id date requestor student_body district grant_or_other vendor_name addr1 addr2 phone fax order_items id order_id quantity catalog desc price ext_price I want to be able to submit each row of data in the bottom part of my form to the order_items table, but i don't know how to relate them to the order_desc table. Also, i don't know how i would keep the order_id the same for each row, for that query. Any help would be appreciated.

ok, i see now. How would i use the order id? How would i keep it the same during for each row, during that order. I'm having trouble wrapping my head around it right now. Also, this isn't for buying or anything like that. It's just for people to send in stuff they want to get ordered.

don't have to time to post now, but have that many, because each new row of desc, catalog, ect..., needs to have it's own place here are current coulmns Date,Requestor,Student_Body,District,Grant_or_Other,Vendor_Name,Address,Address_Line_2,Phone,Fax,q1,q2,q3,q4,q5,q6,c1,c2,c3,c4,c5,c6,d1,d2,d3,d4,d5,d6,p1,p2,p3,p4,p5,p6,e1,e2,e3,e4,e5,e6,Shipping_Estimate,Total

http://www.redmond.k12.or.us/rhs/php/orderform/addrow.php < -- adds the rows(test) http://www.redmond.k12.or.us/rhs/php/orderform/form.php<--working (doesn't add rows)

I have a table with about 30 columns, each for a different text input, and the rows are ordered by id, to seperate out each submission sent in. I would like to add row(to the form) which would in turn, mean more text inputs, hence more colums. I know that i can do the alter table (table) add column (column) if need be, but i don't want to have a giant table

I have a form where users can submit orders for review, and the data is stored in a mysql table. I've added a function in javascript to add rows to the form as needed, so they can submit all there data at one time. The problem i have now is, i have to add columns to the mysql table, for each of the new rows added to the form. Should i limit the amount of rows that can be added, or make a script that adds another colum to mysql after so many rows added. I hope you understand what i'm trying to say. Any suggestion would be greatly appreciated.

Hey no problem man.

try: <?php if ($_SERVER['HTTP_REFERER'] != 'www.steamfootball.com/authorize.php') header("Location: www.steamfootball.com/login.php "); ?>

this won't work, what formatting should i apply: $mail->Body = "$user.",\n\n" ."We've generated a new password for you at your " ."request, you can use this new password with your " ."username to log in.\n\n" ."Username: ".$user."\n" ."New Password: ".$pass."\n\n" ."It is recommended that you change your password " ."to something that is easier to remember, which " ."can be done by going to the My Account page" ."after signing in.\n\n"";

ok , i was thinking of doing that. I'll go ahead and see if that'll work. If any1 has any other suggestion feel free to post, else i'll marked this one solved in about a half hour.

I have a form, that gets sent to itself, and submits the data to a mysql database, then allows users to update their info, if it was wrong or they want to add something. Is their a way to get the id number (I have mysql table with id set to auto_incremet) from the submission that is initially sent so that it can be used in an update statement later. ( Where id= '".$id.''' or something) Thanks for any help!

I have a form that sends data to mysql, and you get shown the submitted data. But i also want the users to be able to update their sent info, after thay see what they've sent, to make changes if something was incorrect. I want to make an update feature that will let them do that, but their is no user authentication on these pages, so i want to use php session. I don't know where to start. I want the form data to be saved in the session, so when they go to the update page, their info is still there. I want the session to end after they update. Any tips on how to do any of this. Please HELP!

Thanks, wassn't sure i needed to pass the variable, makes sense now that i think about it. I'll remember that one

Heres my code function grabit() { $mySQL_query2 = "SELECT Requestor FROM ordrfrm WHERE id LIKE" . " $id"; echo "<pre>\n$mySQL_query2\n</pre>"; $f = mysql_query($mySQL_query2); while($row = mysql_fetch_assoc($f)) { echo "Name :{$row['Requestor']} <br>"; } } grabit(); echo $id When i take this code out of a function, it works fine and gets me the results. It's the firsts steps for a little bit bigger function i'll build later, bit i can't get this one working. Any Suggestions?