Re: [PHP-DB] multi-table insert

2006-04-30 Thread Chris
Eustace wrote: Hello everybody! I am very much a newbie in PHP, but enjoying the learning process. Here and there I get tangled in the logic of certain problems. Anyway, I have a database about interns and this database has multi-tables told data of interns, for example personal information, educ

[PHP-DB] Eliminating character sets from DB entry

2006-04-30 Thread Chris Payne
Hi there everyone, Is there a way to allow Only English character sets in database entry with MySQL and PHP? I'm getting an awful lot of SPAM which is in Chinese/Japanese and i'd love to be able to block these charactersets from being inserted into my databases. Chris

Re: [PHP-DB] Newly inserted record ID

2006-04-30 Thread Stut
Skip Evans wrote: I am very new to the list, but I get the impression that Jonathan below is rather new to programming in PHP/MySQL and lists like these are great resources for people without the many years of experience some of us have. And while mysql_insert_id() is old hat to most of us, to

Re: [PHP-DB] Newly inserted record ID

2006-04-30 Thread Skip Evans
I am very new to the list, but I get the impression that Jonathan below is rather new to programming in PHP/MySQL and lists like these are great resources for people without the many years of experience some of us have. And while mysql_insert_id() is old hat to most of us, to people with les

Re: [PHP-DB] Newly inserted record ID

2006-04-30 Thread Stut
JONATHAN GRAVOIS wrote: Thanks to the help of this list, I am making great progress. Now this -- I have a multi-part submission form for a support application for us, the manufacturer - the reseller's information is submitted, the customer's information is submitted, then the warranty support in

[PHP-DB] Newly inserted record ID

2006-04-30 Thread JONATHAN GRAVOIS
Thanks to the help of this list, I am making great progress. Now this -- I have a multi-part submission form for a support application for us, the manufacturer - the reseller's information is submitted, the customer's information is submitted, then the warranty support information needs to be subm

Re: [PHP-DB] Dynamic DataBinding in Form

2006-04-30 Thread Micah Stevens
Not quite sure what you're asking, but I think you mean, you want to automatically fill customer with the concat'd values of FName and LName.. You can do this with PHP, but only once the form is submitted (remember, PHP is server side) if you want to do it in the browser in front of the user,

[PHP-DB] Re: Example of mail()

2006-04-30 Thread JeRRy
Hi, Why not use cookies to check if the user has pressed F5 or refreshed the page? There is a number of ways to do this, all should work effectively depending on your how many people hit the page etc. a) Store the message in a cookie, and run PHP code to check before executing t

[PHP-DB] Dynamic DataBinding in Form

2006-04-30 Thread JONATHAN GRAVOIS
I have an INSERT form with several fields two of which are FName and LName. There is also a field named CUSTOMER which is the concatenation of those two fields separated by a space. Is there a way to fill in customer as the user types in the other two fields. I used to do this in Coldfusion; can I

RE: [PHP-DB] Unicode

2006-04-30 Thread Liber
Make a query "SET NAMES 'UTF8' " first. -Original Message- From: Gerry D [mailto:[EMAIL PROTECTED] Sent: Sunday, April 30, 2006 9:23 AM To: php-db@lists.php.net Subject: [PHP-DB] Unicode I am looking at building a lily register db. Lately there have been lots of introductions from Lat

Re: [PHP-DB] Session Variable from Recordset

2006-04-30 Thread Stut
JONATHAN GRAVOIS wrote: What is the syntax for pulling a field out of a query and setting it as a session variable? RTFM: http://php.net/mysqli (assuming you mean a MySQL query) and http://php.net/session Quote: "Failure is not the only punishment for laziness; there is also the success of ot

[PHP-DB] Session Variable from Recordset

2006-04-30 Thread JONATHAN GRAVOIS
What is the syntax for pulling a field out of a query and setting it as a session variable? Thanks, Jon -- Jonathan Gravois Omni Sports Technologies 800.529.6664 X125 http://www.omnisportstech.com Quote: "Failure is not the only punishment for laziness; there is also the success of others." --

Re: [PHP-DB] Re: Example of mail()

2006-04-30 Thread Julien Bonastre
Renzo Clavijo wrote: I know it's very simple but the question is: How can I erase the values held in $_REQUEST such that when I press F5 or I click "Reload" there are no messages sent again? $_REQUEST['message']); } benmoreassynt wrote: I would try something like this: if(iss