Output date in html problem

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
luci2200
Forum Newbie
Posts: 2
Joined: Thu Mar 20, 2008 6:12 am

Output date in html problem

Post by luci2200 »

Hello, I have a problem retrieving and show data from a database. I have the following query:
$host1="localhost"; // Host name
$username1="user"; // Mysql username
$password1="********"; // Mysql password
$db_name1="dbname"; // Database name


$link1 = mysql_connect($host1, $user1, $password1) or die("I can't connect!");

$tabela = mysql_select_db($db_name1, $link1) or die("I can't select table!");


$query="SELECT ";
$query.='trafficSummaries.sitesID AS sitesID';
$query.=',';
$query.='sites.site AS site';
$query.=',';
$query.='SUM(trafficSummaries.inCache+trafficSummaries.outCache) AS bytes';
$query.=',';
$query.='TRUNCATE((SUM(trafficSummaries.inCache)/SUM(trafficSummaries.inCache+trafficSummaries.outCache))*100,0) AS cachePercent';
$query.=' FROM trafficSummaries';
$query.=' JOIN sites ON ';
$query.='trafficSummaries.sitesID=sites.id';
$query.=' AND ';
$query.='trafficSummaries.date=sites.date';
$query.=' WHERE ';
$query.="trafficSummaries.ip='".$pageVars['hostiplong']."'";
$query.=" AND";
$query.=" trafficSummaries.date='".$pageVars['date']."'";
$query.=" GROUP BY trafficSummaries.sitesID";
$query.=' ORDER BY '.$pageVars['OrderBy'].' '.$pageVars['OrderMethod'];
$resultIP = mysql_query($query, $link1);

Here I try to get the objects from the tables:

echo "<center>
<table>
<tr>
<th></th>
<th>SITE</th>
<th width=110>Traffic</th>
</tr>";

while ($row = mysql_fetch_object($$resultIP)) {

echo "<tr onMouseOver=bgColor=#C5D3E7; onMouseOut=bgColor=#DAE3F0>
<td style=text-align: center;>$row->site</td>
<td style=text-align: left;>$row->bytes[/url]</td>
<td></td>

</tr>";

}

echo "<tr>
<th>TOTALS</th>
<th style=text-align: right;></th>
<th style=text-align: right;></th>

</tr>
</table>
</center>";

This is the first time I using such query to get informations from more tables. I used the output of of the $query into mysql and I get the informations, but when I try from php I get no error. Can anyone give me an idea?
Thank you!
tabatsoy
Forum Commoner
Posts: 29
Joined: Thu Mar 13, 2008 10:14 am

Re: Output date in html problem

Post by tabatsoy »

you don't get any problem?
so what's the problem if you don't have any problem?
User avatar
John Cartwright
Site Admin
Posts: 11470
Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:

Re: Output date in html problem

Post by John Cartwright »

Code: Select all

$query="SELECT ";
$query.='trafficSummaries.sitesID AS sitesID';
$query.=',';
$query.='sites.site AS site';
$query.=',';
$query.='SUM(trafficSummaries.inCache+trafficSummaries.outCache) AS bytes';
$query.=',';
$query.='TRUNCATE((SUM(trafficSummaries.inCache)/SUM(trafficSummaries.inCache+trafficSummaries.outCache))*100,0) AS cachePercent';
$query.=' FROM trafficSummaries';
$query.=' JOIN sites ON ';
$query.='trafficSummaries.sitesID=sites.id';
$query.=' AND ';
$query.='trafficSummaries.date=sites.date';
$query.=' WHERE ';
$query.="trafficSummaries.ip='".$pageVars['hostiplong']."'";
$query.=" AND";
$query.=" trafficSummaries.date='".$pageVars['date']."'";
$query.=" GROUP BY trafficSummaries.sitesID";
$query.=' ORDER BY '.$pageVars['OrderBy'].' '.$pageVars['OrderMethod'];
$resultIP = mysql_query($query, $link1)  or die('SQL: '. $query .' <br />Error: '. mysql_error());
Adding some debugging info like I have done should be the first step you take ;)
luci2200
Forum Newbie
Posts: 2
Joined: Thu Mar 20, 2008 6:12 am

Re: Output date in html problem

Post by luci2200 »

Thank you for your reply. I made a beginner mistake: while ($row = mysql_fetch_ object($$ resultIP) ) the resultIP have 2 $ in front.. And the debug is an excellent idea. Thank you!
Post Reply