dscqrkvr9562034621 2014-01-01 16:35
浏览 34

相当于foreach循环只有一行[关闭]

I have a PHP function that runs a SELECT Query in SQL:

if(!function_exists("SelectQuery")) {
    function SelectQuery ($sql) {
        global $conn;
        $SelectQuery = mysql_query($sql,$conn);
        return $NumRows=mysql_num_rows($SelectQuery);
        $SelectQuery_Results=array();
        while($SelectQuery_Row = mysql_fetch_array($SelectQuery)) {
            $SelectQuery_Results[] = $SelectQuery_Row;
        }
        return $SelectQuery_Results;
    }
}

then i am calling it here:

$sql="SELECT * from tickets where ticketnumber = '".$_GET["seq"]."' ";
$ticket = SelectQuery($sql);
foreach($ticket as $ticket2) {

}

rather than using a foreach loop what else could i use as my query will only be returning one row and i dont want to put my whole page within a loop

i tried just removing the foreach loop but that didnt work

  • 写回答

3条回答 默认 最新

  • douyu0725 2014-01-01 16:39
    关注

    Just access your value as $ticket[0].

    评论

报告相同问题?

悬赏问题

  • ¥15 求解O-S方程的特征值问题给出边界层布拉休斯平行流的中性曲线
  • ¥15 谁有desed数据集呀
  • ¥20 手写数字识别运行c仿真时,程序报错错误代码sim211-100
  • ¥15 关于#hadoop#的问题
  • ¥15 (标签-Python|关键词-socket)
  • ¥15 keil里为什么main.c定义的函数在it.c调用不了
  • ¥50 切换TabTip键盘的输入法
  • ¥15 可否在不同线程中调用封装数据库操作的类
  • ¥15 微带串馈天线阵列每个阵元宽度计算
  • ¥15 keil的map文件中Image component sizes各项意思