[PHP-DB] Mail Function

Evening all, I've written a script which sends emails, there is no problem with that. I was wondering how I can check for email bounces, anyone know how to do that? Cheers, G :) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] test post

please delete this -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] INSERTing INTO Multiple Tables with MySQL & PHP

Hi there, I've been hunting thru the net trying to find some info on inserting data to multiple tables. I have two tables (LookupTable and MainTable): LookupTable( FirstID SecondID ) MainTable( ID Name Address etc etc ) Once I insert data into the MainTable I want to also insert the ID from th

[PHP-DB] mysql_fetch_assoc question

Hey all, I managed to find that if I do: $MemberID = @mysql_query("SELECT ID FROM SiteMember WHERE Username = '$valid_user'"); $array = mysql_fetch_assoc($MemberID); print_r($array); this will produce: Array ( [ID] => 3 ) All I want is the value 3 so that I can go ahead and insert that into t

[PHP-DB] Inserting checkbox data

Hi all, I'm having a problem inserting a value from a checkbox into a MySQL DB. I can print out what the variable holds, the problem is it just won't go into the DB. Weird thing is when I login to SSH there isn't a NULL value for it instead that field is just blank. Anyone got any ideas what

Re: [PHP-DB] Inserting checkbox data

al Message - From: "Mihail Bota" <[EMAIL PROTECTED]> To: "Graeme McLaren" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, October 25, 2002 7:47 PM Subject: Re: [PHP-DB] Inserting checkbox data > Graeme, > > first, extend the for loop ov

[PHP-DB] Dealing with Unchecked Checkboxes

Hey all, I'm trying to get my head around checkboxes. I can insert "checked" checkboxes into a DB no problem but I get an error when the checkboxes are unchecked. I've used the following to try and handle unchecked checkboxes but I still get the error "query was empty" can anyone point me in t

Re: [PHP-DB] Dealing with Unchecked Checkboxes

> Kinda sucks if your variable names are dynamic, I just erase the whole > > record and re-insert in that case. > > > > -Micah > > > > > > At 09:02 PM 10/26/2002 +0100, Graeme McLaren wrote: > > >Hey all, I'm trying to get my head around checkboxe

Re: [PHP-DB] Dealing with Unchecked Checkboxes

Hi all, thanks for all your replies, I got the problem with checkboxes fixed :) Cheers, Graeme :) - Original Message - From: <[EMAIL PROTECTED]> To: "Graeme McLaren" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, October 28, 2002 3:53 PM Subjec

[PHP-DB] Infinite Loop?

Greetings list members. I've written the code below as part of an automatic email script. The problem with this is it seems to run in to an infinite loop. The for loop seems to get completely ignored by emails get sent constantly. I deleted the script after receiving 2500 emails ! :'( Can any

Re: [PHP-DB] Infinite Loop?

t now. Thanks for your advice. Graeme :) On Sat, 2002-11-02 at 20:41, Jason Wong wrote: > On Sunday 03 November 2002 04:26, Graeme McLaren wrote: > > Greetings list members. I've written the code below as part of an > > automatic email script. The problem with this is it

[PHP-DB] PHP & Case Sensitivity

Hey all, I've had a bizarre experience. When I uploaded a php script it worked fine and when I was looking through my code I found that it shouldn't have worked because two variables had been used instead of one. What I'm meaning is, I used $Year and $year where I was just supposed to use $Year,

[PHP-DB] Re: mysql_fetch_array() question

Hi everyone, I think I've got the problem sorted, I'll soon let y'all know if it doesn't work ! Cheers, Graeme :) On Mon, 2002-11-04 at 21:47, Graeme McLaren wrote: > Hi, Anyone know how I can use two mysql_fetch_array() functions similar > to the code below? I

[PHP-DB] mysql_fetch_array() question

Hi, Anyone know how I can use two mysql_fetch_array() functions similar to the code below? I've tried a few different ways but I keep getting Resource ID #4. I need to do this to retrieve an email address from one table and retrieve details from another. Cheers for any tips - I'm stumped with th

Re: [PHP-DB] mysql_fetch_array() question

nal Message- > From: Jason Wong [mailto:phplist@;gremlins.com.hk] > Sent: Wednesday, November 06, 2002 5:24 AM > To: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] mysql_fetch_array() question > > On Tuesday 05 November 2002 05:47, Graeme McLaren wrote: > > Hi, Anyone know how I c

Re: [PHP-DB] basic php question

Darryl, I'm not completely clear on what you mean by "I need to walk table employee and see if emp2 has a record that matches by employee number" >From what I understand I would do something like: $query = mysql_query("select * from employee where EmployeeNo = $EmployeeNo and emp2.EmployeeNo = '$

[PHP-DB] Replacing "+" with " " question

Hi all I want the contents of a variable to be returned to the user without the + symbols, how do I do that? This is what I have so far by the string replace function doesn't replace the spaces and display bla bla bla as I want: $AddressLine1 = urlencode($AddressLine1); $AddressLine1 = str_replac

Re: [PHP-DB] Replacing "+" with " " question

Re: [PHP-DB] Replacing "+" with " " question > On Wednesday 01 October 2003 01:06, Graeme McLaren wrote: > > > This is what I have so far by the string replace function doesn't replace > > the spaces and display bla bla bla as I want: &

[PHP-DB] Query works but can't echo variable :'(

Hey everyone, the following query and code works fine but I can't understand why I can't echo the $Date variable. I guess it doesn't work fine then :( Any ideas ? G :) $TheDate = mysql_query("select DATE_FORMAT(DateOfOrder, '%d, %m, %Y') as date from Orders Where Orders.ID = '$TransID'"); whil