Re: [PHP] dev style guide

2003-08-14 Thread Phillip Blancher
Actually the word is Suffix not postfix... Prefix and Suffix. -- Best Regards, Phil Phillip Blancher Web Developer & Lead Graphic Designer < http://www.ontarioweb.ca > 1-866-209-0349 < [EMAIL PROTECTED] > - Original Message - From: "Miles Thompson" <[

[PHP] Hitler and Recent Threads

2003-08-07 Thread Phillip Blancher
OK Everyone... Isn't this a PHP list... -- Best Regards, Phil Phillip Blancher Web Developer & Lead Graphic Designer < http://www.ontarioweb.ca > 1-866-209-0349 < [EMAIL PROTECTED] > - Original Message - From: "Robert Cummings" <[EMAIL PROTECTED]> T

Re: [PHP] Problem with MySQL Query

2003-07-23 Thread Phillip Blancher
Tried NOT LIKE and that didnt exclude it either. I am trying to exclude only 'Meal Plans' Phil - Original Message - From: "David Nicholson" <[EMAIL PROTECTED]> To: "Phillip Blancher" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: We

Re: [PHP] Problem with MySQL Query

2003-07-23 Thread Phillip Blancher
> > $dbqueryshipping1 = "select * from tempuserpurchase where > (usersessionid=\"$User_Shopping_Id\") and day=\"1\" and > type<>'Meal Plans' > Tryed both methods and it is still not excluding anything matching Meal Plans --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus

Re: [PHP] Problem with MySQL Query

2003-07-23 Thread Phillip Blancher
no > escaping...) > > $dbqueryshipping1 = "select * from tempuserpurchase where > usersessionid='$User_Shopping_Id' and day='1' and type!='Meal Plans'"; > > You don't need quotes around '1' since it's an integer, but MySQL is &

[PHP] Problem with MySQL Query

2003-07-23 Thread Phillip Blancher
Problem with mySQL Query This is the query I have: $dbqueryshipping1 = "select * from tempuserpurchase where (usersessionid=\"$User_Shopping_Id\") and day=\"1\" and type!=\"Meal+Plans\" "; What I want to do is to select everything from tempuserpurchase that matchs the user session and the da

[PHP] newbY prob

2003-07-23 Thread Phillip Blancher
Problem with Count. ! am trying to count the number of items in this table. The table has one field in it. The code I am using is: $dbquerymeal = "select COUNT(*) from mealtype"; $resultmeal = mysql_db_query($dbname,$dbqueryshipping1); if(mysql_error()!=""){echo mysql_error();} $mealcount =

Re: [PHP] MySQL/PHP problem.

2003-07-22 Thread Phillip Blancher
ot;amount from DB query"; echo $shipping; ?> - Original Message - From: "Curt Zirzow" <[EMAIL PROTECTED]> To: "PHP List" <[EMAIL PROTECTED]> Sent: Tuesday, July 22, 2003 5:23 PM Subject: Re: [PHP] MySQL/PHP problem. > * Thus wrote Phillip Blan

[PHP] MySQL/PHP problem.

2003-07-22 Thread Phillip Blancher
I am trying to count in mySQL the number of entries in the field "day" where day=2 or 3. Then I want to check just to see if that returned a value greater than 0 or not. I am using the code below, but having a problem, I keep getting 0 as the total What am i doing wrong. $dbqueryshippi

[PHP] Adding one time charges in field.

2003-07-22 Thread Phillip Blancher
I am working on a site which does deliveries for items based on the days associated with the items. Each Item has been assigned a number (1 for Sunday, 2 for Monday... etc). All items that are ordered for Monday or Tuesday are Delivered on Sunday (2 & 3) All items ordered for Wednesday and Thurs

[PHP] Problem with Adding info into an array

2003-07-21 Thread Phillip Blancher
In making an array: I have 7 checkboxes, which make up the array information. I currently use implode to make the array, however that array only consists of the information that it checked. What I need to do now is make it so the array will always be 7 items, but if there isnt a checkbox for the