Re: [PHP] Re: Database Question

[Marek Kilimajer]

What is the problem? You need to be more clear about it, especially you 
did not tell anything about the tables, how they are related and what 
they contain

José Pereira wrote:

I Posted this and no one has helped....is this possible to get working or do
I have to do it differently??
Thanks in advance

"José Pereira" <[EMAIL PROTECTED]> escreveu na mensagem
news:[EMAIL PROTECTED]
 

Hi all,

I'm trying to grab information from two DBs one being a mamber db and the
other a report DB
I want to print a list of users(pilots for a Virtual Airline) from the
   

Pilot
 

db and then next to them the nº of reports and total hours they have so
   

far
 

from the REPORT DB.  The Pilot ID on this list must be a link so that when
clicked it will show the details of the reports.
I got this to but in a general for using a variable $login

so when the pilot/member logins it stores his ID in the $login and then I
use the SELECT * FROM table WHERE column = $login
to be more specific using this code:

<?
require("require/config.php");
require("require/authentication.php");
$auth=authenticate($login, $password);
   $link = mysql_connect("localhost", "user", "password")
       or die("Could not connect");
      mysql_select_db("databse") or die("Could not select database");
   $query = "SELECT flight_hhmm FROM pirep WHERE pilot_id='$login'";
   $result = mysql_query($query) or die("Query failed");
   while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
$hhmm=explode(':',$line['flight_hhmm']);
$totalm+=$hhmm[0]*60+$hhmm[1];
   }
   mysql_free_result($result);

?>

then to print out the number of hours I use this:

<?
echo $auth["login"]. '. You have ';
echo floor($totalm / 60).':'.($totalm % 60). ' total hours.';
?>
this show the total hours for $login which is the pilot id in the report
   

DB.
 

now I have this code to produce TOTAL reports for the site:

   $link = mysql_connect("localhost", "user", "password")
       or die("Could not connect");
      mysql_select_db("database") or die("Could not select database");
   $query = "SELECT * FROM pirep ";
   $result = mysql_query($query) or die("Query failed");
$nb1 = mysql_numrows($result);

This gets me the nº of rows for all pilots the using echo $nb1 will print
the total reports.
Now I tried alot but no luck.  I wanted to get a list like so:

MVC103  -  100 reports Filed - 130 Hours Total
MVC104  -  10 report filed  -  50 hours total
etc,
having the ID (MVCxxx) being a link so when clicked it will show the
datails.  I tried the count() statement but like I said I new to PHP.
If anyone can help PLS.. take a look at the site, mind you it is in
portuguese http://novo.cdmvirtual.com


   



 



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php