View unanswered posts | View active topics It is currently Mon May 23, 2022 11:25 pm



Reply to topic  [ 1 post ] 
 Error getting table from database 
Author Message
Junior Member

Joined: Mon Mar 03, 2008 2:21 am
Posts: 1
Post Error getting table from database
[PHP]<?php

$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';
$dbname = 'camp';
$table = 'requests';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die('Error connecting to mysql');


mysql_select_db($dbname, $conn);
mysql_query("SET NAMES 'utf8'");
if ($_GET["order_by"] == "name") { $order_by = " order by namesurname"; }
if ($_GET["order_by"] == "country") { $order_by = " order by country"; }
if ($_GET["order_by"] == "hc") { $order_by = " order by hc"; }
if ($_GET["order_by"] == "cs") { $order_by = " order by cs"; }
if ($_GET["order_by"] == "need") { $order_by = " order by needhost"; }
if ($_GET["order_by"] == "other") { $order_by = " order by other"; }
if ($_GET["order_by"] == "accept") { $order_by = " order by canhost"; }
if ($_GET["order_by"] == "notes") { $order_by = " order by notes"; }

$result = mysql_query("SELECT namesurname as nm, email, IF(country is null, 'world', country) country, cs, hc, needhost as hst, other, canhost, notes, create_date, ipnumber, useragent, acceptlanguage FROM {$table} WHERE confirmed='Y' order by create_date" . $order_by, $conn) or die(mysql_error());
$i = 0;
$kisi = 0;
$need = 0;
$host = 0;
echo "<table style=\"font-family: tahoma; font-size: 8pt\" border=\"0\" cellpadding=\"1\" cellspacing=\"0\" border=\"0\">";
$bgcolor = "#99aabb";
echo "<tr>";
echo "<td bgcolor=\"" . $bgcolor . "\"><a href=\"?order_by=name\">Name</a></td>";
echo "<td bgcolor=\"" . $bgcolor . "\"><a href=\"?order_by=country\">Country</a></td>";
echo "<td bgcolor=\"" . $bgcolor . "\"><a href=\"?order_by=cs\">CS Name</a></td>";
echo "<td bgcolor=\"" . $bgcolor . "\"><a href=\"?order_by=hc\">HC Name</a></td>";
echo "<td bgcolor=\"" . $bgcolor . "\"><a href=\"?order_by=notes\">Notes</a></td>";
echo "</tr>\n";
if (!$result) {
die("Query to show fields from table failed");
}
if ($myrow = mysql_fetch_array($result)) {
do {
$i = $i + 1;
$kisi = $kisi + 1 + $myrow["other"];
$host = $host + $myrow["canhost"];
if ($myrow["hst"] == "Y") {
$need = $need + 1 + $myrow["other"];
}
echo "<tr>";
if ($bgcolor == "#ffffff") {
$bgcolor = "#d0d0d0";
} else {
$bgcolor = "#ffffff";
}


echo "<td style=\"border-bottom: 1px solid #f05050\">" . $myrow["nm"] . " </td>";

echo "<td style=\"border-bottom: 1px solid #f05050\"><img style=\"border: 1px solid black\" src=\"http://www.organikkimya.com/images/flags/" . trim($myrow["country"]) . ".gif\" width=\"20px\" alt=\"". trim($myrow["country"]) . "\">
" . $myrow["country"] . " </td>";

echo "<td style=\"border-bottom: 1px solid #f05050\">" . $myrow["cs"] . " </td>";
echo "<td style=\"border-bottom: 1px solid #f05050\">" . $myrow["hc"] . " </td>";
echo "<td style=\"border-bottom: 1px solid #f05050\" colspan=\"1\"><span style=\"color: red\">";
if ($myrow["hst"] == "Y") {
echo "i need host. ";
};
if (($myrow["canhost"] != "-") & ($myrow["canhost"] != "0")) {
if ($myrow["canhost"] == "1") {
echo "i can accept 1 guest. ";
} else {
echo "i can accept " . $myrow["canhost"] . " guests. ";
}
}
if (($myrow["other"] != "-") & ($myrow["other"] != "0")) {
if ($myrow["other"] == "1") {
echo "there'll be 1 other participant with me. ";
} else {
echo "there'll be " . $myrow["other"] . " other participants with me. ";
}
}


echo "</span>
" . $myrow["notes"] . " </td>";
echo "</tr>\n";
} while ($myrow = mysql_fetch_array($result));
} else {
echo "Sorry, no records were found!";
}
echo "</table>";

echo "Totally " . $i . " records, " . $kisi . " participants, " . $need . " people are looking for hosts, " . $host . " of them can be hosted.";
mysql_close($conn);
?>[/PHP]


Mon Mar 03, 2008 2:33 am
Report this post
Profile
Display posts from previous:  Sort by  
Reply to topic   [ 1 post ] 

Who is online

Users browsing this forum: No registered users and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
© Copyright 2003-2008 www.php-editors.com. The ultimate PHP Editor and PHP IDE site.