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 [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent

[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] To: Chris Sherwood [EMAIL PROTECTED] Cc: [EMAIL

[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 =

[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 day, so

Re: [PHP] Problem with MySQL Query

2003-07-23 Thread Phillip Blancher
='$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 forgiving. ---John Holmes... - Original Message - From: Phillip Blancher [EMAIL PROTECTED] To: PHP List [EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 5:08 PM

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 system

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: Wednesday, July 23, 2003 6:19 PM Subject: Re: [PHP] Problem

Re: [PHP] MySQL/PHP problem.

2003-07-22 Thread Phillip Blancher
print_r($shipping3); echo 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 Blancher ([EMAIL PROTECTED

[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

[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.

[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