hey,
trying putting at where in your "SELECT * FROM $main_tbl" so it looks like
this
SELECT * FROM $main_tbl where "whatever" = "somthing"
you can also make a limit in "SELECT * FROM $main_tbl" just like this
SELECT * FROM $main_tbl LIMIT 4
From: "Jason T. Davidson" <[EMAIL PROTECTED]>
Reply-To
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]
5 matches
Mail list logo
