Question

我正试图从我的言语数据库获得海关数据,但我知道这种数据是好的。有些人能否帮助我?

Please look at my example. enter image description here

我试图从有色利德=2的表格(>wp_ngg_pictures)中重复图像名称。

因此,我要举一个例子:

bildes-140.jpg
bildes-127.jpg
bildes-133.jpg
bildes-152.jpg
And so on....

Answer 1

假设你使用购买力平价,你会与你的数据库连接起来,然后做这样的事情。

$result = mysql_query("SELECT * FROM wp_ngg_pictures WHERE galleryid = 2")or die (mysql_error());
        while ($row = mysql_fetch_assoc($result)) {
         echo $row[ filename ];
        }

If you wanted more specific results it would be a little different. Fixed the errors.. sorry bout that, still learning myself.

Answer 2

这应当包括所有有2个id的美术,并反映id和档案名称。

$GetAlbum=2;
$sql = "SELECT * FROM YOURDATABASE.wp_ngg_pictures WHERE galleryid LIKE  %".$GetAlbum."% ";
$result=mysql_query($sql) or die ( Error! Could not get gallery Databse. );
$num=mysql_num_rows($result);
$i=0;
while ($i < $num) {
$gallery=mysql_result($result,$i,"galleryid");
$galleryImg=mysql_result($result,$i,"filename");
echo  ID  .$gallery.  File  .$galleryImg.  ;
}

Answer 3

SELECT filename from wp_ngg_pictures WHERE galleryid = 2

友情链接