Loop and if Statement in php

Question

I have the following code.

<?php if ( $showdata['venue'] == "Brean Sands" ) {echo "<div class=\"gigpress-related-park\">"; echo $showdata['date_long']; echo $showdata['venue']; echo "</div>"; } ?>
<?php if ( $showdata['venue'] == "Camber Sands" ) {echo "<div class=\"gigpress-related-park\">"; echo $showdata['date_long']; echo $showdata['venue']; echo "</div>"; } ?>
<?php if ( $showdata['venue'] == "Pakefield" ) {echo "<div class=\"gigpress-related-park\">"; echo $showdata['date_long']; echo $showdata['venue']; echo "</div>"; } ?>
<?php if ( $showdata['venue'] == "Prestatyn Sands" ) {echo "<div class=\"gigpress-related-park\">"; echo $showdata['date_long']; echo $showdata['venue']; echo "</div>"; } ?>
<?php if ( $showdata['venue'] == "Southport" ) {echo "<div class=\"gigpress-related-park\">"; echo $showdata['date_long']; echo $showdata['venue']; echo "</div>"; } ?>

This pulls the information from my db just fine, but I need it to loop, or repeat so that multiple dates appear for each venue. There are multiple dates for each venue in the db, but as the code is, it only returns the value for the first date. I need the others to appear as well.

How do I get this code to loop while looking at only one venue and pull all dates, then end?

how do you fetch the value from db? show us the code.

Ibrahim Azhar Armar
– Ibrahim Azhar Armar

2012-06-28 12:08:51 +00:00
Commented Jun 28, 2012 at 12:08 — Ibrahim Azhar Armar
– Ibrahim Azhar Armar, Commented Jun 28, 2012 at 12:08
The Values are fetched here pastebin.com/bfy1Cmug

Pontins Webteam
– Pontins Webteam

2012-06-28 12:17:56 +00:00
Commented Jun 28, 2012 at 12:17 — Pontins Webteam
– Pontins Webteam, Commented Jun 28, 2012 at 12:17

marc_s · Accepted Answer · 2016-02-09 07:11:28Z

2

$query = mysql_query("the query");
while($showdata = mysql_fetch_assoc($query)) {
  put your code here
}

So you run the query to get all database records you want, then you loop through assigning the row to $showdata. This will then process everything inside the loop for every row it returns from the database query

edited Feb 9, 2016 at 7:11

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Jun 28, 2012 at 12:10

Lee

10.6k4 gold badges39 silver badges45 bronze badges

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

7 Comments

Leri Over a year ago

Just use PDO or mysqli_* instead of mysql_*

Pontins Webteam Over a year ago

I understand all of this, except the query. What do you mean? pastebin.com/bfy1Cmug I believe that is my query, it then include_once related, which contains the above code.

Lee Over a year ago

@PLB: thats an alternative, but not a direct solution. A loop would still be required whether you use PDO or mysqli, they are just alternative ways of interfacing with the data store.

Leri Over a year ago

@Lee I've suggested using pdo or mysqli_* only for security purposes.

Lee Over a year ago

@PLB: each to their own i guess. I have my own way and you have yours. However a little bit of knowledge can hurt sometimes. If mysqli is used incorrectly it can be insanely less secure and compromise a system far worse. i.e. the single biggest issue with mysqli (which is also its strength if you do things properly) is that it allows multiple sql statements. But as i say, we all have our own approach to a problem

|

Ibrahim Azhar Armar · Accepted Answer · 2012-06-28 12:11:52Z

0

assuming you use mysql_ function to fetch values from db. here is what you should do.

$query = mysql_query('SELECT QUERY');
while($showdata = mysql_fetch_assoc($query)) {
    echo "<div class=\"gigpress-related-park\">" . $showdata['venue'] . $showdata['venue'] . "</div>";
}

however it would be better of using PDO or MySQLi instead of using mysql_.

answered Jun 28, 2012 at 12:11

Ibrahim Azhar Armar

25.8k36 gold badges136 silver badges213 bronze badges

1 Comment

Pontins Webteam Over a year ago

I believe my values are fetched by the following pastebin.com/bfy1Cmug which then loads the above script through "related"

Collectives™ on Stack Overflow

Loop and if Statement in php

2 Answers 2

7 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related