PHP echo xyz if rows in loop contain no data

Question

I am trying to echo some text if my loop returns with no data but can't get it do work. I have tried a few things but no luck.

my code:

$result = mysql_send("SELECT * FROM datatable WHERE id='".
    $_SESSION['id']."'ORDER BY id ASC LIMIT 2");

while($row=mysql_fetch_array($result)) {
    $a = 1;
    extract($row);

    echo 'Trans ID: ';
    echo $row['trans_id'];
    echo '<br>';
    echo 'Amount: ';
    echo $row['amount'];
    echo '&nbsp;';
    echo $row['euros'];
    echo '<br>';
    echo '<br>';
}


if ($a = 1) {
    echo 'No History';
} else {
    echo '<a href="#">View history</a>';
};

Can Anyone help me with how to do if statements on a loop`?

Artefacto kindly reformatted your code, but in future please ensure your code is correctly indented and formatted. This makes it easier for yourself and others to read the code. — Artelius
– Artelius, Commented Jun 18, 2010 at 13:39

Artefacto · Accepted Answer · 2010-06-18 13:35:48Z

2

You have an assignment, which returns the result of the assignment (i.e. 1)

if ($a = 1) {

instead of a comparison, which is what you probably want:

if ($a == 1) {

Therefore, "No history" will always be echoed.

answered Jun 18, 2010 at 13:35

Artefacto

98.1k17 gold badges207 silver badges230 bronze badges

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

Comments

Lizard · Accepted Answer · 2010-06-18 13:36:08Z

2

use mysql_num_rows(); it will tell you if you have any results from query

$result = mysql_send("SELECT * FROM datatable WHERE id='".
$_SESSION['id']."'ORDER BY id ASC LIMIT 2");

$count = mysql_fetch_array($result);

if($count > 0) {
    while($row=mysql_fetch_array($result)) {
        # your code
    }
}

# NOTE THE == not =
if ($a == 1) {
    echo 'No History';
} else {
    echo '<a href="#">View history</a>';
};

You will also have issue with your if statement as youu are using assigment rather than comparison: $a = 1 will set $a = 1 and $a == 1 will check of it equals 1

answered Jun 18, 2010 at 13:36

Lizard

45.3k39 gold badges108 silver badges170 bronze badges

Comments

Brandon Frohbieter · Accepted Answer · 2010-06-18 13:51:45Z

1

if($a == 1) ....

edited Jun 18, 2010 at 13:51

user7675

answered Jun 18, 2010 at 13:36

Brandon Frohbieter

18.2k4 gold badges42 silver badges62 bronze badges

Comments

Artelius · Accepted Answer · 2010-06-18 13:36:18Z

0

== is a comparison, = is an assignment.

Change to

if ($a == 1) {

answered Jun 18, 2010 at 13:36

Artelius

49.3k13 gold badges94 silver badges106 bronze badges

Collectives™ on Stack Overflow

PHP echo xyz if rows in loop contain no data

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related