RE: [PHP-DB] Re: send email

Hi This is PHP code and will be parsed by the webserver before being send out to the browser. All that is displayed in the browser is the non PHP stuff. So the email address is in the source code of the php page but when you click 'view source' in your browser you won't see it. Jack

RE: [PHP-DB] send email

Hi, Here a bit of code that I use in a members list (this is the update bit) CODE SNIPPET if (isset ($_GET['update']) OR isset ($_POST['update'])) { $db = @mysql_connect(localhost, username,password); mysql_select_db(walvis,$db); if(isset($_POST['enter'])) {

RE: [PHP-DB] using code for multiple sites

Hi You could create an alias in every virtual host pointing to the same directory for all sites, or I believe apache will use anything outside the virtual host tags as being default for all sites. Jack -Original Message- From: mike [mailto:[EMAIL PROTECTED] Sent: Thursday, November

RE: [PHP-DB] Selecting two names from a table

Hi, Try something like this: SELECT U1.User_Name , U2.User_Name , B.Booking_Date FROMUSER U1 , USER U2 , BOOKING B WHERE B.Booking_Creator = U1.User_ID AND B.Booked_User = U2.User_ID' Jack -Original

RE: [PHP-DB] Need help with a OpenLink ODBC driver error again

Hi Does the query return data when executed not through a browser but directly on the database? If yes, how much time does it take to return the data. I believe default time out for apache is 30 seconds. So maybe it's a webserver setting that needs to be increased. Jack -Original

RE: [PHP-DB] UPDATE part of a column

As a separate issue, I would consider seperating the address field into it's individual parts Street,area,city etc.. All different fields -Original Message- From: Shaun [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 23, 2003 2:03 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] UPDATE

RE: [PHP-DB] Databases and PHP?

PHP can be used with many different databases (MySql support is just built in, others you have to compile in). I do not know about DB2 but ODBC is always possible Jack -Original Message- From: IN [mailto:[EMAIL PROTECTED] Sent: Monday, September 22, 2003 11:31 AM To: [EMAIL

RE: [PHP-DB] MySQL: How to properly extract fields from retrieved single record ???

Hi, I think this is what you are trying to do. You get a record back that has seveal fields and you want to reference those fields indiviually. This is what I do in this example (which shows people information) and present in HTML table

RE: [PHP-DB] Email Form

Hi, Combine the two scripts Begin script Accept the post variables Insert them into the database Mail them End script jack -Original Message- From: Philip O'Rourke [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 10:46 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Email

RE: [PHP-DB] Whios request record in database

In order to insert data into database you'll need an insert statement I only see select * from $table Jack -Original Message- From: IS [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 1:32 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Whios request record in database I want

RE: [PHP-DB] include_path problem

I have not really followed this thread so if it is mentioned already. Is the include_path directive twice in the file? -Original Message- From: Ford, Mike [LSS] [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 3:42 PM To: 'Bruce Levick' Cc: [EMAIL PROTECTED] Subject:

RE: [PHP-DB] another PHP Sql question...

One question: Do you mean that a b are from the same column but are row 1 2 from your query result.? If so, you can possibly write a loop like so Dump all your records in an array; Start loop for as long you find records in array { Take the first record from your array and dump it

RE: [PHP-DB] SELECT Part of a Field

Depending on the database you are using Substring() Substr() Functions do what you want jack -Original Message- From: Shaun [mailto:[EMAIL PROTECTED] Sent: Friday, August 29, 2003 11:58 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] SELECT Part of a Field Hi, How can I SELECT a

RE: [PHP-DB] Simple field replace...?

Try using the substring function in your sql statement Substring('String',32); Jack -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, August 28, 2003 11:35 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Simple field replace...? Hi there, I need to

RE: [PHP-DB] Database backup

How'bout backing up your data directory (ies) Otherwise you can maybe use mysql_dump in a batch?? Jack -Original Message- From: Chris Payne [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2003 11:46 PM To: php Subject: [PHP-DB] Database backup Hi there everyone, Is there a

RE: [PHP-DB] MYSQL 4.1 derived tables and PHP

Hi THX I added mysql_error() to get the error message. I got the message that the user did not have rights on table /tmp/dbla.bla I figured that I must give some more global read rights to this user (not just DB read rights). After that it worked. THX Jack -Original Message-

Re: [PHP-DB] It\'s wierd when I\'ve used forms...

You'll have to look into stripslashes function (of the top of my head) PHP automatically puts slashes around variables Jack On Fri, 2003-08-22 at 23:35, Joe Walker wrote: I've got a form (for sending mail to a user) and the user input is in an html form using the post method to pass:

Re: [PHP-DB] It\'s wierd when I\'ve used forms...

I mean in front of special characters off course :-) Jack On Fri, 2003-08-22 at 23:40, Jacob A. van Zanen wrote: You'll have to look into stripslashes function (of the top of my head) PHP automatically puts slashes around variables Jack On Fri, 2003-08-22 at 23:35, Joe Walker wrote