PHP和MYSQL显示多个名称的1条记录 [英] PHP and MYSQL displaying 1 record of multiple Name
问题描述
我正在设计一个具有不同事件的模型网站。我已将图像存储在数据库表名称图像中。现在我的问题是,如何显示一个事件的记录多个记录?例如:用户将上传多个事件图像在相同的图像,但具有相同的事件名称。现在我必须为每个事件显示单个图片。
i am designing one model website which have different events. I have store the image in a database table name image. Now my question is how do i display one record for one event out of many records? For example : the user will upload multiple events image in same image but with same event name. Now i have to display single image per event.
表的名称是像imageID,imageName,imageType,eventName,imagePath
The name of table is images it got filed like imageID, imageName, imageType, eventName, imagePath
如何创建一个sql语句,其中打印不同的事件名称和图像
how do i create an sql statement where it print different event name and image
推荐答案
问题不清楚。
希望此查询可能有帮助。
Your question is not clear. Hope this query may help.
select * from images
where eventName='name'
group by eventName
这篇关于PHP和MYSQL显示多个名称的1条记录的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!