Sacar todo los comentarios de una publicación | Problemas en mi sentencia SQL
Resulta que estoy teniendo un poco de problemas al sacar todos los comentarios de la base de datos de las publicaciones, quiero sacar los comentarios cuando estos correspondan a cada publicación.
Actualmente estoy sacando todos los comentarios de cada publicación, pero me salen los comentarios de otras publicaciones que no corresponden a esa publicación, no se si me di a entender en esta parte.
Acá pueden ver como estoy sacando toda la información de las publicaciones, esa parte funciona a la perfección.
<?php
// Traer todos los articulos cuando sean igual a el id
$stmt = $conexion->query("SELECT *, product.description_product, product.create_at_product, product.id_producto, product.user_id, product.condicion, users.telephone, users.email, users.photo_perfil, users.create_at_user, users.surname, users.name, users.sexo, users.id_usuario FROM product INNER JOIN users ON product.id_producto = $post WHERE product.user_id = users.id_usuario LIMIT 1");
$stmt->execute(['email' => $email]);
while ($row = $stmt->fetch()) {
// Datos del usuario que lo publico
$id_usuario = $row['id_usuario'];
$userFoto = $row['photo_perfil'];
$nameP = $row['name'];
$surnameP = $row['surname'];
$telephoneP = $row['telephone'];
$mail = $row['email'];
$sexo = $row['sexo'];
$fecha_user = $row['create_at_user'];
// Datos del producto
$id = $row['id_producto'];
$user_id = $row['user_id'];
$title = $row['title'];
$price = $row['price'];
$description_product = $row['description_product'];
$condition = $row['condicion'];
$moneda = $row['moneda'];
$ubication = $row['ubication'];
$video = $row['video'];
$images = $row['images'];
$miniatura = $row['miniatura'];
$category = $row['category'];
$fecha = $row['create_at_product'];
?>Ahora les muestro como estoy sacando toda la información de los comentarios.
<?php
// Sacar todos los comentarios de la BD
$stmt = $conexion->query("SELECT *, comment.id_comment, comment.user_id, comment.product_id, comment.comments, comment.create_at_comment, users.name, users.surname, users.photo_perfil, users.sexo FROM comment INNER JOIN users ON comment.id_comment = users.id_usuario");
$stmt->execute(['email' => $email]);
while ($row = $stmt->fetch()) {
// Datos del usuario que publico el comentario
$name_comment = $row['name'];
$surname_comment = $row['surname'];
$photo_comment = $row['photo_perfil'];
$sexo_comment = $row['sexo'];
// Datos del comentario
$comment = $row['comments'];
$fecha_comment = $row['create_at_comment'];
?>En esta captura les quiero mostrar como esta hecha mi campo de comment.
Hay 7 comentarios que los he introducido con el mismo usuario, la parte de la inserción de datos esta muy bien, mis problema es sacar los comentarios correspondiente a cada publicación.
Acá en donde estoy mostrando todas las informaciones.
5 respuestas
Creo que el join lo estas haciendo por campos distintos, contra comment id y contra user id...
deberian representar lo mismo...
Remarkable article on Spanish culture, you are an especially stone in showing up, I envision the going with on the web diary.
Jaipur Escorts Service Escorts Service in Jaipur Jaipur Escort Escort in Jaipur Jaipur Escort Service
Brilliant post! This is an OK blog that I will show more events to restore this year! Thankful for the lit post. Escorts Service in Jaipur Jaipur Escort Escort in Jaipur Jaipur Escort Service Escort Service in Jaipur
Hypnotizing data getting article. This post is genuinely astounding on this fundamental subject. Jaipur Escort Escort in Jaipur Jaipur Escort Service Escort Service in Jaipur Jaipur Escorts
I think this is among the especially incomprehensible arrangement of basic data for me. A responsibility of appreciation is all together for sharing Escort in Jaipur Jaipur Escort Service Escort Service in Jaipur Jaipur Escorts Escorts in Jaipur
This is spellbinding, You are an astoundingly fit blogger. I have gotten your approach nearby and envision searching for a more indispensable level of your significant post. In like manner, I've shared your site in my incredible affiliations! Jaipur Escort Service Escort Service in Jaipur Jaipur Escorts Escorts in Jaipur Jaipur Escorts Service
This is an amazing post shared by you, I got so much information from your post. I work in Jaipur escorts and if you want to choose the hottest girl on our website we also provide in-the-door and outdoor service. Escort Service in Jaipur Mumbai Call Girl Call Girl in Jaipur Jaipur Escorts Escorts in Jaipur
Great information did you share after reading your post, I guess you are a thoughtful person, thanks for sharing this information. I do my job with a Jaipur escort there are fabulous call girls who give you full satisfaction in your sexual life. Jaipur Escorts Service Escorts Service in Mumbai Jaipur Call Girls Call Girls in Jaipur Delhi Escort
Our Jaipur escorts are very famous for call girls there are amazing reviews of the customer when a customer came to our escorts they fully satisfied with our erotic girls. So you will come and book one hot girl after then you feel very happy.Gurgaon Escort Service Lucknow Call Girl Call Girl in Kolkata Delhi Escorts Escorts in Mumbai
http://uid.me/alisha_malhotra
https://giphy.com/gifs/escorts-service-in-gurgaon-gurgoan-escort-FUQuLITCm1OJsaZVrm
https://www.flickr.com/photos/198726884@N04/53040767010/#comment72157720283040523
https://www.producthunt.com/@alisha_malhotra
https://www.quora.com/profile/Alisha-Malhotra-65
https://tapas.io/alishamalhotra1010
https://pantip.com/profile/7639184#topics
https://photozou.jp/user/top/3338654
https://buyandsellhair.com/author/alisha-malhotra/
https://www.empowher.com/users/alisha-malhotra
https://letterboxd.com/Alisha_1010/
https://en.gravatar.com/alishamalhotra1010
https://www.agricultureinformation.com/forums/members/alisha101.366931/#about
https://rosalind.info/users/Alisha_1010/
http://ikonoteka.paleo.pan.pl/xwiki/bin/XWiki/AlishaMalhotra?category=profile
https://speakerdeck.com/alisha1010
https://community.windy.com/user/alisha-malhotra
https://medium.com/@alishamalhotra1010/about
https://www.29chat.com/AlishaMalhotra
https://demo.wowonder.com/AlishaMalhotra
https://www.provenexpert.com/alisha-malhotra/?mode=preview
https://ayers-rock.adposta.com/spice-up-your-night-with-gurgaon-escorts-girls-807470
https://www.diggerslist.com/alishamalhotra/about
https://www.flickr.com/people/198726884@N04/
https://chutpatti.com/AlishaMalhotra
https://www.lawyersclubindia.com/profile.asp?member_id=967526
https://fairygodboss.com/users/profile/ojWKthz1mC/Alisha-Malhotra
https://elderassociation.mn.co/members/17712348
https://issuu.com/alishamalhotra1010/followers
https://www.ted.com/profiles/44529196/about
https://my.omsystem.com/members/alisha786
https://huzzaz.com/user/Alisha_1010321
https://myopportunity.com/profile/alisha-malhotra/nw
https://dailygram.com/profile-449189
http://www.rohitab.com/discuss/user/1706346-alisha-malhotra/
https://linktr.ee/admin
https://www.uplabs.com/alishamalhotra1010
https://coub.com/fd49718f4e44d3b15fb7
https://myworldgo.com/profile/Alisha1010
http://www.activewin.com/user.asp?Action=Read&UserIndex=4234535&redir=&redirname=Forums
http://mrmountain.createdebate.com/debate/show/Gurgaon_Escorts_Service_8
https://www.mixcloud.com/Alisha_1010/
https://www.sbnation.com/users/AlishaMalhotra
https://ebusinesspages.com/apoorva786.user
https://speakerdeck.com/apoorva786
https://developers.oxwall.com/user/apoorva786
https://disqus.com/by/apoorvagoaswami/about/
https://roggle-delivery.tribe.so/user/apoorva_goaswami
https://scioly.org/forums/memberlist.php?mode=viewprofile&u=135455
http://www.rohitab.com/discuss/user/1686485-apoorva786/
https://xiglute.com/profile/20245276
https://www.canadavideocompanies.ca/author/apoorva786/
https://trello.com/u/apoorvagoaswami
https://www.noteflight.com/profile/0938fdba8a69b13dcf0e65cfbfe53cf909e7d761
https://www.diggerslist.com/apoorva786/about
https://investsocial.com/member/1418308-apoorva786
https://www.mixcloud.com/apoorva786/
https://www.hackerrank.com/goaswamiapoorva?hr_r=1
<a href="http://uid.me/alisha_malhotra/"> Escorts in Gurgaon </a> || <a href="https://giphy.com/gifs/escorts-service-in-gurgaon-gurgoan-escort-FUQuLITCm1OJsaZVrm/"> Escorts Service in Gurgaon </a> || <a href="https://www.flickr.com/photos/198726884@N04/53040767010/#comment72157720283040523/"> Gurgaon Escorts </a> || <a href="https://www.producthunt.com/@alisha_malhotra/"> Gurgaon Escorts Service </a> || <a href="https://www.quora.com/profile/Alisha-Malhotra-65/"> Escorts in Gurgaon </a> || <a href="https://tapas.io/alishamalhotra1010/"> Escorts Service in Gurgaon </a> || <a href="https://pantip.com/profile/7639184#topics/"> Escorts Service in Gurgaon </a> || <a href="https://photozou.jp/user/top/3338654/"> Gurgaon Escorts </a> || <a href="https://buyandsellhair.com/author/alisha-malhotra/"> Gurgaon Escorts Service </a> || <a href="https://www.empowher.com/users/alisha-malhotra/"> Escorts in Gurgaon </a> || <a href="https://letterboxd.com/Alisha_1010/"> Escorts Service in Gurgaon </a> || <a href="https://en.gravatar.com/alishamalhotra1010/"> Escorts in Gurgaon </a> ||
<a href="https://www.agricultureinformation.com/forums/members/alisha101.366931/#about/"> Escorts Service in Gurgaon </a> || <a href="https://rosalind.info/users/Alisha_1010/"> Gurgaon Escorts </a> || <a href="http://ikonoteka.paleo.pan.pl/xwiki/bin/XWiki/AlishaMalhotra?category=profile/"> Gurgaon Escorts Service </a> || <a href="https://speakerdeck.com/alisha1010/"> Escorts in Gurgaon </a> || <a href="https://community.windy.com/user/alisha-malhotra/"> Escorts Service in Gurgaon </a> || <a href="https://medium.com/@alishamalhotra1010/about/"> Escorts Service in Gurgaon </a> || <a href="https://www.29chat.com/AlishaMalhotra/"> Gurgaon Escorts </a> || <a href="https://demo.wowonder.com/AlishaMalhotra/"> Gurgaon Escorts Service </a> || <a href="https://www.provenexpert.com/alisha-malhotra/?mode=preview/"> Escorts in Gurgaon </a> || <a href="https://ayers-rock.adposta.com/spice-up-your-night-with-gurgaon-escorts-girls-807470/"> Escorts Service in Gurgaon </a> || <a href="https://www.diggerslist.com/alishamalhotra/about/"> Gurgaon Escorts </a> || <a href="https://www.flickr.com/people/198726884@N04/"> Gurgaon Escorts Service </a> || <a href="https://chutpatti.com/AlishaMalhotra/"> Escorts in Gurgaon </a> || <a href="https://www.lawyersclubindia.com/profile.asp?member_id=967526/"> Escorts Service in Gurgaon </a> || <a href="https://fairygodboss.com/users/profile/ojWKthz1mC/Alisha-Malhotra/"> Gurgaon Escorts </a> || <a href="https://elderassociation.mn.co/members/17712348/"> Gurgaon Escorts Service </a> || <a href="https://issuu.com/alishamalhotra1010/followers/"> Escorts in Gurgaon </a> || <a href="https://www.ted.com/profiles/44529196/about/"> Escorts Service in Gurgaon </a> || <a href="https://my.omsystem.com/members/alisha786/"> Gurgaon Escorts </a> || <a href="https://huzzaz.com/user/Alisha_1010321/"> Gurgaon Escorts Service </a> || <a href="https://myopportunity.com/profile/alisha-malhotra/nw/"> Escorts in Gurgaon </a> || <a href="https://dailygram.com/profile-449189/"> Escorts Service in Gurgaon </a> || <a href="http://www.rohitab.com/discuss/user/1706346-alisha-malhotra/"> Gurgaon Escorts </a> || <a href="https://linktr.ee/admin/"> Gurgaon Escorts Service </a> || <a href="https://www.uplabs.com/alishamalhotra1010/"> Escorts in Gurgaon </a> || <a href="https://coub.com/fd49718f4e44d3b15fb7/"> Escorts Service in Gurgaon </a> || <a href="https://myworldgo.com/profile/Alisha1010/"> Gurgaon Escorts </a> || <a href="http://www.activewin.com/user.asp?Action=Read&UserIndex=4234535&redir=&redirname=Forums/"> Gurgaon Escorts Service </a> || <a href="http://mrmountain.createdebate.com/debate/show/Gurgaon_Escorts_Service_8/"> Escorts in Gurgaon </a> || <a href="https://www.mixcloud.com/Alisha_1010/"> Escorts Service in Gurgaon </a> || <a href="https://www.sbnation.com/users/AlishaMalhotra/"> Gurgaon Escorts </a> || <a href="https://ebusinesspages.com/apoorva786.user/"> Gurgaon Escorts Service </a> || <a href="https://speakerdeck.com/apoorva786/"> Escorts in Gurgaon </a> || <a href="https://developers.oxwall.com/user/apoorva786/"> Escorts Service in Gurgaon </a> || <a href="https://disqus.com/by/apoorvagoaswami/about/"> Gurgaon Escorts </a> || <a href="https://roggle-delivery.tribe.so/user/apoorva_goaswami/"> Gurgaon Escorts Service </a> || <a href="https://scioly.org/forums/memberlist.php?mode=viewprofile&u=135455/"> Escorts in Gurgaon </a> || <a href="http://www.rohitab.com/discuss/user/1686485-apoorva786/"> Escorts Service in Gurgaon </a> || <a href="https://xiglute.com/profile/20245276/"> Gurgaon Escorts </a> || <a href="https://www.canadavideocompanies.ca/author/apoorva786/"> Gurgaon Escorts Service </a> || <a href="https://trello.com/u/apoorvagoaswami/"> Escorts in Gurgaon </a> || <a href="https://www.noteflight.com/profile/0938fdba8a69b13dcf0e65cfbfe53cf909e7d761/"> Escorts Service in Gurgaon </a> || <a href="https://www.diggerslist.com/apoorva786/about/"> Escorts Service in Gurgaon </a> || <a href="https://investsocial.com/member/1418308-apoorva786/"> Escorts Service in Gurgaon </a> || <a href="https://www.mixcloud.com/apoorva786/"> Escorts Service in Gurgaon </a> || <a href="https://www.hackerrank.com/goaswamiapoorva?hr_r=1/"> Escorts Service in Gurgaon </a> ||
Nothing gives more joy as glad customer who returns, again and again... Much obliged to you for time and conviction. Goa Call Girls in has amazing intelligent capability which can help your character and the time you will with her will clearly be brilliant and offer you with extreme entertainment.
oirgoiergoiherg - preeti roy