[PHP-DB] Selection problem

2003-09-26 Thread Stéphane RIVEZ
Hello, I'm novice in php and mysql utilization so... Here is my problem: I have a form with some fields (for example, 2: field1 and field2) My mysql database contains for example 1 table (named for example SQLTABLE) with 3 fields: ID (auto_increment), AA, BB. On my form, field1 is represented

RE: [PHP-DB] Selection problem

2003-09-26 Thread Hutchins, Richard
[mailto:[EMAIL PROTECTED] Sent: Friday, September 26, 2003 2:12 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP-DB] Selection problem Hello, I'm novice in php and mysql utilization so... Here is my problem: I have a form with some fields (for example, 2: field1 and field2

RE: [PHP-DB] Selection problem

2003-09-08 Thread Gary . Every
Pay It Forward mailto:[EMAIL PROTECTED] http://accessingram.com -Original Message- From: Chris Payne [mailto:[EMAIL PROTECTED] Sent: Sunday, September 07, 2003 5:43 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Selection problem Hi there everyone, I'm having a strange problem, I

[PHP-DB] Selection problem

2003-09-07 Thread Chris Payne
Hi there everyone, I'm having a strange problem, I have a form with 2 fields, 1 is for points (Weightwatcher points) and one is for recipe names. If you select points (IE: 1-3, 3-6,6-9,9 and above) it works perfectly, displays the recipes and allows you to select a new points range from the

Re: [PHP-DB] Selection problem

2003-09-07 Thread Micah Stevens
Since you didn't include the form, I'm going to have to make a couple of assumptions: $nameb is the recipe field. $pointsb is the points field. You want to use SQL statement 1 if they select points, 2 if they select recipies, but those aren't the only possibilities with the form. It sounds to