dongyongyu0789 2016-03-19 13:49
浏览 194
已采纳

如何用php从数据库中获取单个值

I am trying to get a single value from database and store it in a variable Here is the structure of my Database

mysql_connect("localhost","root","") or die(mysql_error());;
mysql_select_db("test") or die(mysql_error());
$result = mysql_query('SELECT * FROM names WHERE name = noshair');
while($row = mysql_fetch_array($result));
{
    echo $row['course'] . "<p>";    
}

When I use the above code it prints all the courses against my name from data base but I want a specific course name to be selected, like there are 5 courses against my name and i just want all of then separately to be saved in separate variable.

  • 写回答

5条回答 默认 最新

  • dongliao1948 2016-03-19 14:22
    关注

    Give this query a try:

    SELECT DISTINCT name, GROUP_CONCAT(DISTINCT course ORDER BY course) AS courses;
    FROM names
    WHERE name = noshair
    

    and change your echo statement to this:

    echo $row['courses'] . "<p>";
    

    This should output a list of your course like this -> 'java, c#, php, maths' which you could then put in a variable.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(4条)

报告相同问题?

悬赏问题

  • ¥15 maple软件,用solve求反函数出现rootof,怎么办?
  • ¥65 汇编语言除法溢出问题
  • ¥15 Visual Studio问题
  • ¥15 state显示变量是字符串形式,但是仍然红色,无法引用,并显示类型不匹配
  • ¥20 求一个html代码,有偿
  • ¥100 关于使用MATLAB中copularnd函数的问题
  • ¥20 在虚拟机的pycharm上
  • ¥15 jupyterthemes 设置完毕后没有效果
  • ¥15 matlab图像高斯低通滤波
  • ¥15 针对曲面部件的制孔路径规划,大家有什么思路吗