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:
?
$r1=SELECT * FROM
[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]
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 so far:
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
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
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 display on a site. Not every entry is supposed to show up on
the web page, but does so. I
6 matches
Mail list logo