drq231358 2015-07-06 11:09
浏览 15

使用MySQL中的下拉变量进行排序

I'm new to PHP, and I have a simple table from a MySQL database. What I want to do is sort the table using the selected value from the drop down box, with the data from that row in the database.

enter image description here

Here is my code (selected is what I need for the drop down box):

$orderby = $_GET['orderby'];

if ($orderby == 'selected') { 
    $orderby_query = "WHERE timeStamp LIKE 'selected'";}
else { 
    $orderby_query = "";
}

$con = mysql_connect("xxxx","xxxx","xxxx");
$db = mysql_select_db("xxxx",$con);
$get = mysql_query("SELECT DISTINCT(timeStamp) FROM deliverys ORDER BY timeStamp DESC");
$timeStamp = '';

while($row = mysql_fetch_assoc($get))
{
    $timeStamp .= '<option value   ="'.$row['timeStamp'].'">'.$row['timeStamp'].'</option>';
}

<table width="100%" border="1">
<tr style="font-weight:bold;" valign="top" height="30px" bgcolor="#999999">
<td><form name="sorter0" action="index.php" method="get">
<label title="date">Date</label><br />
<select name="orderby" OnChange="document.sorter0.submit();"><br /><br />
<option>Sort by Date</option>
<option value=''>--?--</option><?php echo $timeStamp; ?></option>
</select>
</form></td>

I don't know if I'm adding the data to the drop down box correctly because, if I click, the site reloads and I can see it say:

/index.php?orderby=05-09-2015

If I use a "fixed" value like yes or no it works.

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥20 软件测试决策法疑问求解答
    • ¥15 win11 23H2删除推荐的项目,支持注册表等
    • ¥15 matlab 用yalmip搭建模型,cplex求解,线性化处理的方法
    • ¥15 qt6.6.3 基于百度云的语音识别 不会改
    • ¥15 关于#目标检测#的问题:大概就是类似后台自动检测某下架商品的库存,在他监测到该商品上架并且可以购买的瞬间点击立即购买下单
    • ¥15 神经网络怎么把隐含层变量融合到损失函数中?
    • ¥15 lingo18勾选global solver求解使用的算法
    • ¥15 全部备份安卓app数据包括密码,可以复制到另一手机上运行
    • ¥20 测距传感器数据手册i2c
    • ¥15 RPA正常跑,cmd输入cookies跑不出来