On Mon, 17 Feb 2003, Miguel Brás wrote:
> Hello gents,
>
> I have a table with users and passwords with over than 100 rows.
> I have 7 specific users that I wanna display on a page, as well their data.
>
> How can I display this specific users on the page?
A little more information is need:
1. What type of database are you using (postgresql, mysql)?
2. What is the database scheme (tables and columns)
Assuming you are using postgresql and have a table 'user' with columns
user, password, firstname, lastname, email
$Result = pg_exec($DBConnection, "SELECT firstname, lastname, email
FROM user
WHERE user.user = '$User1'
OR user.user = '$User2'
OR user.user = '$User3'
OR user.user = '$User4'
OR user.user = '$User5'
OR user.user = '$User6'
OR user.user = '$User7';");
for ($i = 0; $i < pg_numrows($Result); $i++) {
print pg_fetch_result($Result, $i, 0) . " " . pg_fetch_result($Result,
$i, 1) . "
" ... (for rest of results)
}
$User1 ... $User7 are variables that contain the user id of the users you
are interested in. Check the docs for pg_connect() (needed to connect to
DB), pg_exec() (query db) and pg_result() (retrieve results from a
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
