douzhi8488 2014-01-21 15:53
浏览 24

上传2张图片并从数据库中检索第一个ID

I uploaded 2 images into the database and want to retrieve from the database by id... I dont know how to retrieve for the first ID. I can retrieve the second ID using :

$lastid = mysql_insert_id();


//declare where the image is from
$before = $row['image']; //want to retrieve first id
$after = $row['image']; //this can be get by the $lastid

///updated my codes

I declared like this :

  $lastid = mysql_insert_id();
    $pic = mysql_query("SELECT * FROM images WHERE id='$lastid'");
    $row = mysql_fetch_assoc($pic);

    //declare where the image is from
    $before = $row['image'];
    $after = $row['image'];

when I output the image, i got 2 last id

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥20 怎么用dlib库的算法识别小麦病虫害
    • ¥15 华为ensp模拟器中S5700交换机在配置过程中老是反复重启
    • ¥15 java写代码遇到问题,求帮助
    • ¥15 uniapp uview http 如何实现统一的请求异常信息提示?
    • ¥15 有了解d3和topogram.js库的吗?有偿请教
    • ¥100 任意维数的K均值聚类
    • ¥15 stamps做sbas-insar,时序沉降图怎么画
    • ¥15 买了个传感器,根据商家发的代码和步骤使用但是代码报错了不会改,有没有人可以看看
    • ¥15 关于#Java#的问题,如何解决?
    • ¥15 加热介质是液体,换热器壳侧导热系数和总的导热系数怎么算