<?php
$con = mysql_connect ("localhost", "user", "pass")
or die ('Error: ' . mysql_error());
mysql_select_db ("members");
if(isset($_GET['orderby'])){
$order = $_GET['orderby'];
$result = "SELECT * FROM persons ORDER BY ".mysql_real_escape_string($order)." DESC";
}
else{
$result = mysql_query("select * from persons");
}
$num_rows = mysql_num_rows($result);
$row_counter = 0;
echo "<table width=600 border=0 cellspacing=0>\n";
echo "<tr>\n
<th> </th>\n
<th>First Name</th>\n
<th>Last Name</th>\n
<th>Email Address</th>\n
<th>City</th>\n
<th>State</th>\n
<th><a href='index.php?orderby=submitDate'>Date</a></th>\n
</tr>";
while($row = mysql_fetch_array($result)){
if($row_counter % 2){
$row_color="bgcolor='#FFFFFF'";
}
else{
$row_color="bgcolor='#F3F6F8'";
}
echo "<tr ".$row_color.">";
echo "<td class='id'>" . $row['id'] . "</td>\n";
echo "<td>" . $row['firstName'] . "</td>\n";
echo "<td>" . $row['lastName'] . "</td>\n";
echo "<td>" . $row['email'] . "</td>\n";
echo "<td>" . $row['city'] . "</td>\n";
echo "<td>" . $row['state'] . "</td>\n";
echo "<td>" . $row['submitDate'] . "</td>\n";
echo "</tr>";
$row_counter++;
}
echo "</table>";
mysql_close($con);
?
>
I just cannot figure out why my link to sort my query is not working. any ideas? Pre-Thanks!
我只是想不通为什么我的查询排序链接不起作用。有任何想法吗?预先感谢!
1 个解决方案
#1
2
Your if else block was wrong. In one case $result is a query in another it is a result-set. Check code below.. fixed.
你的if else块错了。在一种情况下,$ result是另一个查询,它是一个结果集。检查下面的代码..修复。
<?php
$con = mysql_connect ("localhost", "user", "pass")
or die ('Error: ' . mysql_error());
mysql_select_db ("members");
if(isset($_GET['orderby'])){
$order = $_GET['orderby'];
$sql = "SELECT * FROM persons ORDER BY ".mysql_real_escape_string($order)." DESC";
}
else{
$sql = "select * from persons";
}
$result = mysql_query($sql);
$num_rows = mysql_num_rows($result);
$row_counter = 0;
echo "<table width=600 border=0 cellspacing=0>\n";
echo "<tr>\n
<th> </th>\n
<th>First Name</th>\n
<th>Last Name</th>\n
<th>Email Address</th>\n
<th>City</th>\n
<th>State</th>\n
<th><a href='index.php?orderby=submitDate'>Date</a></th>\n
</tr>";
while($row = mysql_fetch_array($result)){
if($row_counter % 2){
$row_color="bgcolor='#FFFFFF'";
}
else{
$row_color="bgcolor='#F3F6F8'";
}
echo "<tr ".$row_color.">";
echo "<td class='id'>" . $row['id'] . "</td>\n";
echo "<td>" . $row['firstName'] . "</td>\n";
echo "<td>" . $row['lastName'] . "</td>\n";
echo "<td>" . $row['email'] . "</td>\n";
echo "<td>" . $row['city'] . "</td>\n";
echo "<td>" . $row['state'] . "</td>\n";
echo "<td>" . $row['submitDate'] . "</td>\n";
echo "</tr>";
$row_counter++;
}
echo "</table>";
mysql_close($con);
?>
#1
2
Your if else block was wrong. In one case $result is a query in another it is a result-set. Check code below.. fixed.
你的if else块错了。在一种情况下,$ result是另一个查询,它是一个结果集。检查下面的代码..修复。
<?php
$con = mysql_connect ("localhost", "user", "pass")
or die ('Error: ' . mysql_error());
mysql_select_db ("members");
if(isset($_GET['orderby'])){
$order = $_GET['orderby'];
$sql = "SELECT * FROM persons ORDER BY ".mysql_real_escape_string($order)." DESC";
}
else{
$sql = "select * from persons";
}
$result = mysql_query($sql);
$num_rows = mysql_num_rows($result);
$row_counter = 0;
echo "<table width=600 border=0 cellspacing=0>\n";
echo "<tr>\n
<th> </th>\n
<th>First Name</th>\n
<th>Last Name</th>\n
<th>Email Address</th>\n
<th>City</th>\n
<th>State</th>\n
<th><a href='index.php?orderby=submitDate'>Date</a></th>\n
</tr>";
while($row = mysql_fetch_array($result)){
if($row_counter % 2){
$row_color="bgcolor='#FFFFFF'";
}
else{
$row_color="bgcolor='#F3F6F8'";
}
echo "<tr ".$row_color.">";
echo "<td class='id'>" . $row['id'] . "</td>\n";
echo "<td>" . $row['firstName'] . "</td>\n";
echo "<td>" . $row['lastName'] . "</td>\n";
echo "<td>" . $row['email'] . "</td>\n";
echo "<td>" . $row['city'] . "</td>\n";
echo "<td>" . $row['state'] . "</td>\n";
echo "<td>" . $row['submitDate'] . "</td>\n";
echo "</tr>";
$row_counter++;
}
echo "</table>";
mysql_close($con);
?>