;Jason T. Davidson" <[EMAIL PROTECTED]>
Reply-To: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: [PHP] Pulling Certain Data
Date: Tue, 6 Apr 2004 14:40:38 -0500
Community-
I am a first time databaser and am having trouble pulling information from
a
database to displa
Try something like this. (assuming "POSITION" is your peoples status
within the organization
$r1="SELECT * FROM $main_tbl WHERE position IN ('A', 'I', 'L') ORDER BY
position";
> I would like to only show people who are active within our roster and
> within
> the database I have identified those
Sounds like you need a where clause in your sql query:
$r1="SELECT * FROM $main_tbl where status='A'";
replace 'status' with whatever you called the status field in your table.
Keith
At 12:40 PM 4/6/2004, Jason T. Davidson wrote:
Community-
I am a first time databaser and am having trouble pul
From: "Jason T. Davidson" <[EMAIL PROTECTED]>
> I am a first time databaser and am having trouble pulling information from
a
> database to display on a site. Not every entry is supposed to show up on
> the web page, but does so. I have tried IF statements without any help.
> Here is what I have
[snip]
I am a first time databaser and am having trouble pulling information
from a
database to display on a site. Not every entry is supposed to show up
on
the web page, but does so. I have tried IF statements without any help.
Here is what I have so far:
$r1="SELECT * FROM $main_tbl";
[/snip]
Community-
I am a first time databaser and am having trouble pulling information from a
database to display on a site. Not every entry is supposed to show up on
the web page, but does so. I have tried IF statements without any help.
Here is what I have so far:
6 matches
Mail list logo
