MySQL Subquery cannot loop data

Question

I've problem in my script, the script cannot loop the data, the Results only one image

t_award

-------------------
| id | id_product |
-------------------
| 1  | 1          |
| 2  | 2          |
-------------------

t_image

------------------------------
| id | id_product | image    |
------------------------------
| 1  | 1          | img1.jpg |
| 2  | 1          | img2.jpg |
| 3  | 2          | pic1.jpg |
| 4  | 2          | pic2.jpg |
------------------------------

My Query

<?php
        require ("koneksi.php");
        $perintah="SELECT *, 
                (SELECT image FROM `t_image` as tbl_t_image WHERE tbl_t_image .id_product = t_award.id_product LIMIT 1) as image_name
                FROM t_award
                where id='".$_GET['id']."'";

        $hasil=mysql_query($perintah);
        while ($data=mysql_fetch_array($hasil)) {
        echo'


        <div class="content-img oversize">
            <img src="ipf-panel/img/images_cont_part/'.$data['image_name'].'" alt="">
        </div>
        ';
        }
        ?>

FYI i was delete the LIMIT 1 but error mysql_query(): Unable to save result.

Thanks for responded

Don't use the old and insecure mysql_*-functions. They have been completely removed in PHP 7. Use PDO or Mysqli instead. You're also wide open to SQL-injections and should use prepared statements instead of using unescaped user data directly in your query. You can use prepared statements with both PDO and Mysqli. — M. Eriksson
– M. Eriksson, Commented Sep 20, 2018 at 7:45

Death-is-the-real-truth · Accepted Answer · 2018-09-20 08:01:29Z

1

1.mysql_* is deprecated and removed library now. Quickly move towards PHP7 along with mysqli_* Or PDO library

2.Change code like below

<?php
    if(!empty($_GET['id'])){
        $id = $_GET['id'];
        require ("koneksi.php");
        $perintah="SELECT t_image.image FROM `t_award` LEFT JOIN `t_image` ON t_image.id_product = t_award.id_product WHERE id=$id";
        $hasil=mysql_query($perintah);
        while ($data=mysql_fetch_assoc($hasil)) {
            echo'<div class="content-img oversize"><img src="ipf-panel/img/images_cont_part/'.$data['image'].'" alt=""></div>';
        }
    }
?>

Note:- Query is wide open to SQL INJECTION so try to use prepared statements of mysqli_* or PDO library

edited Sep 20, 2018 at 8:01

answered Sep 20, 2018 at 7:45

Death-is-the-real-truth

72.3k10 gold badges59 silver badges106 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Novry Over a year ago

Woooowwww...Thank you so much Alive it's Work...! you're MVP :D

Death-is-the-real-truth Over a year ago

@Novry glad to help you :):)

Collectives™ on Stack Overflow

MySQL Subquery cannot loop data

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related