Re: [PHP-DB] date format to dateformat
What if $date=10-02-2002; I tried it this way and the explode causes problems with the - in it What would be the best way to deal with this should i just parse out the -? Andrey Sosnitsky [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hello CrossWalkCentral, Sunday, September 22, 2002, 7:06:18 AM, you wrote: Try this $date= 10 01 2002; list ($day, $month, $year) = explode( , $date); echo $year-$month-$day; C I am having problems coverting the followign date format. Does any one have C any insight on this. C $date= 10 01 2002 C I need to conver this to Y-m-d C any help would be great www.pskov.ru www.invest.pskov.ru -- Best regards, Andreymailto:[EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Date Select help
Any one have any information on selecting a rake of dates from a mysql database? my current query reads. $result = mysql_query(SELECT * FROM CWC_Memory); I neeed to select where date is between todays date and todays date +10. Any help would be realy great thanks in advanced. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: Re[2]: [PHP-DB] date format to dateformat
That did it thanks Andrey Sosnitsky [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hello, CrossWalkCentral. You wrote 23 ñåíòÿáðÿ 2002 ã., 2:05:38: So, explode() requires a seperator as a first argument. You code is $date= 10-01-2002; list ($day, $month, $year) = explode(-, $date); echo $year-$month-$day; See PHP manual at http://www.php.net/manual/en/function.explode.php C What if C $date=10-02-2002; C I tried it this way and the explode causes problems with the - in it C What would be the best way to deal with this should i just parse out the -? www.pskov.ruwebmaster|programmer|DBA www.invest.pskov.ru www.education.pskov.ru -- Best Regards, Andrey mailto:[EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] date format to dateformat
I am having problems coverting the followign date format. Does any one have any insight on this. $date= 10 01 2002 I need to conver this to Y-m-d any help would be great -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] getting table structure
I need help getting a specific table structer. Does any one have any code snips that I can follow on this I want to get the structer of a table and display it on the screen. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] AVG fucntion help
Using PHP I need some help running and AVG qery the syntax is as follows $results=sql_query(Select AVG(rate) from MYTABLENAME where id=$id,$dbi) This works but I am not sure how to get is value into a variable. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] NEW help finding sum or average
I have a table called TEST , it cotains 3 fileds A B C I can have several rows where A is the same value. I need help with PHP I need to obtain the AVERAGE of B where A=1 Can some one help me on this? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] mail function
When using this fucntion listed bellow with the HTML headder the email sent does not show the FROM in the FORM filed it just displays it in the email message Any one have any ideas. $headers .= From: CrossWalkCentral [EMAIL PROTECTED] \n; -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] limiting the amount of data to be show on one page.
If I want to use the bellow liste senario. How would i go about setting up the 1 2 3 4 5 6 7 8 page #'s how would I know when to stop counting? You should also add an ORDER BY clause in there, as the SQL standard doesn't guarantee the order that rows are retrieved in. There's a chance that you'll get, say, 20 rows on the first page, go to the second page and get some of the rows you've already seen on the first page. If you use an ORDER BY, you'll at least guarantee that you'll get them in the same order each time. J Kevin Stone wrote: $query = SELECT * FROM mytable LIMIT $i, 20; Where 20 is the number of rows to retrieve and $i is the starting row. By incrementing $i + 20 you can do next, prev buttons, or parse the total number of rows into page links (prev - 1, 2, 3, 4, 5, 6.. 10.. 20 - next). Search www.mysql.com for more information about using LIMIT in your queries. -Kevin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] SORT resutls
I am using the code bellow however this is not a proper way to sort my data it groups my data. Is their a similar command that i can replace the group with like sort? SELECT * FROM supportsys WHERE status=1 and know=0 GROUP BY $G); -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] SORT resutls
thanks that did it. Beau Lebens [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... ORDER BY foo [ ASC | DESC ] // -Original Message- // From: CrossWalkCentral [mailto:[EMAIL PROTECTED]] // Sent: Wednesday, 22 May 2002 10:42 AM // To: [EMAIL PROTECTED] // Subject: [PHP-DB] SORT resutls // // // I am using the code bellow however this is not a proper way // to sort my data // it groups my data. Is their a similar command that i can // replace the group // with like sort? // // SELECT * FROM supportsys WHERE status=1 and know=0 GROUP BY $G); // // // // -- // PHP Database Mailing List (http://www.php.net/) // To unsubscribe, visit: http://www.php.net/unsub.php // -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] counting records
OK when i pull data oout of the database i want to count the number of records where 3 field are the same. I have 6 fileds field1=my first name filed2=my last name filed3=my email filed4=other field5=other field5=other I want to count the records that have the same field1,field2, and field3. so i know how many submissions a person has made, -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] mail function help
For some reason the mail command will not work on all systems mybe I am using it wrong can some one provide some feedback on this. here is a code snip. $msg = \tFirst Name: $custfname\n \tLast Name: $custlname\n \tEmail Address: $custemail\n \tCategory: $dservice\n \tDescription: $custpdes\n; $recipient = $custcatergory; $subject = $adminsubsupport; $mailheaders = From: $adminfrmsupport \n; $mailheaders .= Reply-To: $email\n\n; mail($recipient, $subject, $msg, $mailheaders); -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Email Validation
How would I go about doing the DNS look up part? Markus Lervik [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... On Tuesday 12 February 2002 06:19, CrossWalkCentral wrote: I am working on a form that I have in php and am looking for some advise on form validation or specifically email address validation so i can insure that some one has put in a properly formatted email address Well. something like if (!eregi(^[A-Za-z0-9\_-]+@[A-Za-z0-9\_-]+.[A-Za-z0-9\_-]+.*, $email)) { echo $email doesn't seem to be a valid e-mail address!; } would do the job. Of course, that doesn't stop people from entering a false email address. You could do a DNS-lookup to see if the domain-part of the address really exists, too. Cheers, Markus -- Markus Lervik Linux-administrator with a kungfoo grip Vaasa City Library - Regional Library [EMAIL PROTECTED] +358-6-325 3589 / +358-40-832 6709 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] using sendmail w/ windows
any one know how to use send mail with windows instead of linux. Will this work are their other options? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Need smoe code examples on creating tables for mysql in php
Need some code examples on creating tables for mysql in php can any one help me on this . I searched the php.net site and only found info on creating a database I just want to create a php script that will make 2 tables with lets say 5 fields each in them.
[PHP-DB] sql query
I am having a minor problem doing a simple sql query. Error performing service query : You have an error in your SQL syntax near '' at line 1 Here is a snip of the code: Please let me know what you think. if ($submit): $status=0; // REQUEST INFO FOR SERVICES $results = mysql_query( SELECT * FROM supportsyscat WHERE display=$custcatergory); if (!$results) { echo(PError performing service query : . mysql_error() . /P); exit(); } // Display the text while ( $rows = mysql_fetch_array($results) ) { $dservice=$rows[display]; $eservice=$rows[address]; } $sql = UPDATE supportsys SET . pdes='$custpdes', . sdes='$adminsdes', . status='$status' . WHERE ticket=$ticketnum; if (mysql_query($sql)) { Echo(centerPh4Ticket #$ticketnum has been updated./h4/P/center); Echo(Thank you $custfname $custlname); Echo(pProblem: $custpdes/P); if ($statusclose ==true) { $status=Closed; } else { $status =Open; }
Re: [PHP-DB] sql query
Thanks I will try that. Beau Lebens [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... try replacing WHERE display=$custcatergory); with WHERE display='$custcatergory'); and also tru echoing the value of that SQL statement (assign it to a var first) to make sure you are getting the right thing. HTH /b // -Original Message- // From: CrossWalkCentral [mailto:[EMAIL PROTECTED]] // Sent: Tuesday, 19 February 2002 9:31 AM // To: [EMAIL PROTECTED] // Subject: [PHP-DB] sql query // // // I am having a minor problem doing a simple sql query. // // Error performing service query : You have an error in your // SQL syntax near '' at line 1 // // Here is a snip of the code: Please let me know what you think. // // if ($submit): // // $status=0; // // // REQUEST INFO FOR SERVICES // $results = mysql_query( // SELECT * FROM supportsyscat WHERE display=$custcatergory); // if (!$results) { // echo(PError performing service query : . // mysql_error() . /P); // exit(); // } // // // Display the text // while ( $rows = mysql_fetch_array($results) ) { // $dservice=$rows[display]; // $eservice=$rows[address]; // } // // // $sql = UPDATE supportsys SET . //pdes='$custpdes', . //sdes='$adminsdes', . //status='$status' . //WHERE ticket=$ticketnum; // // if (mysql_query($sql)) { // Echo(centerPh4Ticket #$ticketnum has been // updated./h4/P/center); // Echo(Thank you $custfname $custlname); // Echo(pProblem: $custpdes/P); // // // if ($statusclose ==true) { // $status=Closed; // } else { // $status =Open; // } // // -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Email Validation
I am working on a form that I have in php and am looking for some advise on form validation or specifically email address validation so i can insure that some one has put in a properly formatted email address
[PHP-DB] protecting
How can I help protect people form modifying a form that submits data to php file that stores the data in a database for example I have a text box that ask for a first name and I am getting a lot of garbage back like if they modified my form and submitted a image instead. I know that their is some sort of parse out their that I can put in the php file that will help validate this
[PHP-DB] mail options
Can any one tell me what the value of using this statement. mail($email, $subject, $message, From: $from\nX-Mailer: PHP/ . phpversion()); vs this statement mail($recipient, $subject, $msg, $mailheaders); considering all variables are defind in the script
[PHP-DB] PHP safe mode
Question? What is php safe mode. I have heard that it will allow you to pass information to a mysql database w/o a user name and pass. Has any one heard of this. I am just curious. I would not use it but if this is something that is true I would like that could be a security problem. let me know Cross Walk Central www.crosswalkcentral.net Your Web Hosting Community!
Re: [PHP-DB] currency formating
That did it thanks allot Bill. if you need a support tickett system made in php let me know. thanks again and happy new year to you all. Billy Harvey [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... On Tue, 2002-01-01 at 00:08, Webmaster wrote: Yea i have read that but did not think it was what i needed considering it is for an automated billing system and the customer may not like it if they are charged and extra .50 cents or so every month. Their has got to me another alternative. Well, round wouldn't do that, but what you're looking for is number_format(). Billy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] MySql database data has html code in it
Hello Another question for the pros. I have a Mysql database which contains a table labled html in this table I have some short html scripts I have created a search for my scripts and when I Echo them (example code below) It only shows me the text and not the html script itself Echo ($code); Is their another function that I can use to display to contents of this variblae? I assueme that PHP is trying to process it as part of the echo statement. -- Cross Walk Central www.crosswalkcentral.net Support Center Your Web Hosting Community! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] MySql database data has html code in it
Yea I tried that before I posted I even tried editing the data in the table to but the pre before and /pre after and it still will not show it. -- Cross Walk Central www.crosswalkcentral.net Support Center Your Web Hosting Community! Ali Nayeri [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi, I'm just a newbie and don't know that much but would putting: Echo (pre$code/pre); solve the problem. That's what most people use to display HTML code on an HTML page. As I said I'm new and I never tried it. But you can try and see if it works. Ali -Original Message- From: CrossWalkCentral [mailto:[EMAIL PROTECTED]] Sent: September 1, 2001 6:46 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] MySql database data has html code in it Hello Another question for the pros. I have a Mysql database which contains a table labled html in this table I have some short html scripts I have created a search for my scripts and when I Echo them (example code below) It only shows me the text and not the html script itself Echo ($code); Is their another function that I can use to display to contents of this variblae? I assueme that PHP is trying to process it as part of the echo statement. -- Cross Walk Central www.crosswalkcentral.net Support Center Your Web Hosting Community! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] MySql database data has html code in it
That did it thanks for the help. -- Cross Walk Central www.crosswalkcentral.net Support Center Your Web Hosting Community! Paul Burney [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... on 9/1/01 7:12 PM, CrossWalkCentral at [EMAIL PROTECTED] wrote: Yea I tried that before I posted I even tried editing the data in the table to but the pre before and /pre after and it still will not show it. You need to encode the and characters. You can do so via the htmlspecialchars() function. http://php.net/manual/en/function.htmlspecialchars.php Sincerely, Paul Burney ++ Paul Burney Webmaster Open Source Developer UCLA - GSEIS - ETU (310) 825-8365 [EMAIL PROTECTED] http://www.gseis.ucla.edu/ ++ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Include
Thank you I got it working good deal -- Cross Walk Central www.crosswalkcentral.net Support Center Your Web Hosting Community! Tom Carter [EMAIL PROTECTED] wrote in message 001201c12888$bb8a9790$0a00a8c0@bjorn">news:001201c12888$bb8a9790$0a00a8c0@bjorn... Yes that is correct. On a security point of view therer is something extra you can do.. when using require you can require files that are outside the web tree...by this I mean are not accessible thru the internet. So if you site was in /home/web then you could setup a directory, say /home/web_vars and in this put these kind of files. In the require statement you just then simple put in the full path, eg require(/home/web_vars/vars.php); The advantage of doing this is security When the file with such sensitive information is included in the web tree then there are (admittedly limited) possible scenarios in which this could be compramised. It is generally accepted that it is sensible to avoid putting such information in the web tree. Hope I've been clear, let me know if you need any more advice. so in var.php i will put something like this $db=mydatabse; $username=myusername; $password=mypassword; and so on? -- Cross Walk Central www.crosswalkcentral.net Support Center Your Web Hosting Community! Seb Frost [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... chuck all the common variables in var.php then just put ?php require(var.php); ? - seb -Original Message- From: CrossWalkCentral [mailto:[EMAIL PROTECTED]] Sent: 19 August 2001 03:18 To: [EMAIL PROTECTED] Subject: [PHP-DB] Include OK here is one for you folks that know what you are doing. I am making a script and I have about 5 php files in it. That have alot of the same system variables can I create one file with these settings in it and if so any one want to give me some hints on this thanks again. -- Cross Walk Central www.crosswalkcentral.net Support Center Your Web Hosting Community! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Inseting info into MySQL and retrieving all in one SQL command
Question how do you use this function? mysql_insert_id(); I have tried it and it gives me and error every time any one have any sample conde on this -- Cross Walk Central www.crosswalkcentral.net Support Center Your Web Hosting Community! Beau Lebens [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... not so much in one step, but once you have inserted it you can call the function mysql_insert_id(); and it will return the auto_increment value of the last insert operation. see the manual for more. HTH Beau // -Original Message- // From: Scott Mebberson [mailto:[EMAIL PROTECTED]] // Sent: Thursday, 9 August 2001 8:49 AM // To: [EMAIL PROTECTED] // Subject: [PHP-DB] Inseting info into MySQL and retrieving // all in one SQL // command // // // Hi guys, // // I am adding some information to my MySQL database. It is // user's information. // So it has things like email address, password, username, all // that sort of // stuff. // // What I need to do is once I have added it found out the id - // a primary key // which auto increments itself. At the moment I am doing two // different MySQL // queries an INSERT and a SELECT to first of all add the // information and then // find out the primary key. // // Is there anyway I can do this in one step? // // Thanks in advance // // Scott Mebberson // [EMAIL PROTECTED] // // // // -- // PHP Database Mailing List (http://www.php.net/) // To unsubscribe, e-mail: [EMAIL PROTECTED] // For additional commands, e-mail: [EMAIL PROTECTED] // To contact the list administrators, e-mail: // [EMAIL PROTECTED] // -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] saving to two tables at the same time
I got it it appears that i had forgotten my } at the end of my secound insert -- Cross Walk Central www.crosswalkcentral.net Support Center Your Web Hosting Community! Jason Wong [EMAIL PROTECTED] wrote in message 004c01c127a1$7efe56a0$[EMAIL PROTECTED]">news:004c01c127a1$7efe56a0$[EMAIL PROTECTED]... Do you have any code snippets for us to peruse? -- Jason Wong Gremlins Associates www.gremlins.com.hk - Original Message - From: CrossWalkCentral [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, August 18, 2001 10:58 AM Subject: Re: [PHP-DB] saving to two tables at the same time I have tried this but it has continued to fail the only way I have gotten it to work is via 2 diffrent php scrips -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Include
OK here is one for you folks that know what you are doing. I am making a script and I have about 5 php files in it. That have alot of the same system variables can I create one file with these settings in it and if so any one want to give me some hints on this thanks again. -- Cross Walk Central www.crosswalkcentral.net Support Center Your Web Hosting Community! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Include
so in var.php i will put something like this $db=mydatabse; $username=myusername; $password=mypassword; and so on? -- Cross Walk Central www.crosswalkcentral.net Support Center Your Web Hosting Community! Seb Frost [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... chuck all the common variables in var.php then just put ?php require(var.php); ? - seb -Original Message- From: CrossWalkCentral [mailto:[EMAIL PROTECTED]] Sent: 19 August 2001 03:18 To: [EMAIL PROTECTED] Subject: [PHP-DB] Include OK here is one for you folks that know what you are doing. I am making a script and I have about 5 php files in it. That have alot of the same system variables can I create one file with these settings in it and if so any one want to give me some hints on this thanks again. -- Cross Walk Central www.crosswalkcentral.net Support Center Your Web Hosting Community! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] saving to two tables at the same time
Question: I have a form of 1/2 customer data and the other 1/2 service info. that the custoemr fills out and when they submit it my php scrips adds the customer infor to the customer table but it will not add the service info to the service table? Any one have any ideas -- Cross Walk Central www.crosswalkcentral.net Support Center Your Web Hosting Community! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] saving to two tables at the same time
I have tried this but it has continued to fail the only way I have gotten it to work is via 2 diffrent php scrips -- Cross Walk Central www.crosswalkcentral.net Support Center Your Web Hosting Community! Leo G. Divinagracia III [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... CrossWalkCentral wrote: Question: I have a form of 1/2 customer data and the other 1/2 service info. that the custoemr fills out and when they submit it my php scrips adds the customer infor to the customer table but it will not add the service info to the service table? Any one have any ideas hmmm... lemme guess... previous M$ ACCESS user? where the forms did all the work for you? ;-))) simple enough... just do two insert statements. one for the cust table and one for the service table... ;-) i know, i know... access makes it easy... but trains the wrong stuff... ;-) -- Leo G. Divinagracia III [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]