Print specified text, if the SQL table's column's value is 0.

[username01]

while($row = mysql_fetch_row($query)) {
echo "<tr>";
echo '<td>' . $row[0] . '</td>';
echo '<td>' . $row[1] . '</td>';
echo '<td>' . $row[2] . '</td>';
echo '<td>' . $row[3] . '</td>';
echo '<td>' . $row[4] . '</td>';
echo "</tr>\n";
}

Currently I have this code. I would like to make it print certain text, let's say... 'car', if the value of table's column 'automobiles' is equal to 0. Otherwise - print the real value.

I've tried if statement and $one = $two... But that apparently didn't worked.

 

Thanks.

[Jessica]

But that apparently didn't worked.

 

It didn't work because = is assignment. == is comparison.

[username01]

while($row = mysql_fetch_row($query)) {

if $row == '0' {$row = $text_specified}

echo "<tr>";



echo '<td>' . $row[0] . '</td>';



echo '<td>' . $row[1] . '</td>';



echo '<td>' . $row[2] . '</td>';



echo '<td>' . $row[3] . '</td>';



echo '<td>' . $row[4] . '</td>';



echo "</tr>\n";
}

 

My equation syntax is correct, but code is wrong.

[Jessica]

 

 

if $row == '0' {$row = $text_specified}

 

Row won't equal 0. one of the values in row could be. row[0] might = 0, or row[1]. But row will never because of the while.

You need to check on EACH column/key

[PaulRyan]

if(mysql_num_rows($query)) {
  while($row = mysql_fetch_row($query)) {	  
    echo "<tr>";	
    echo '<td>' . $row[0] . '</td>';	
    echo '<td>' . $row[1] . '</td>';	
    echo '<td>' . $row[2] . '</td>';	
    echo '<td>' . $row[3] . '</td>';	
    echo '<td>' . $row[4] . '</td>';	
    echo "</tr>\n";
}
} else {
  echo 'No rows returned';
}

 

Use the above code, if mysql_num_rows() returns 1 or more rows it will equate to true, else it will equate to false.

 

Regards, PaulRyan.

[Jessica]

if(mysql_num_rows($query)) {
  while($row = mysql_fetch_row($query)) {	  
    echo "<tr>";	
    echo '<td>' . $row[0] . '</td>';	
    echo '<td>' . $row[1] . '</td>';	
    echo '<td>' . $row[2] . '</td>';	
    echo '<td>' . $row[3] . '</td>';	
    echo '<td>' . $row[4] . '</td>';	
    echo "</tr>\n";
}
} else {
  echo 'No rows returned';
}

 

Use the above code, if mysql_num_rows() returns 1 or more rows it will equate to true, else it will equate to false.

 

Regards, PaulRyan.

 

That doesn't sound like what the OP wants to DO though.

 

"if the value of table's column 'automobiles' is equal to 0. Otherwise - print the real value."

 

That refers to one column in the row. Not the whole row.

[PaulRyan]

Well spotted Jesirose, I totally mis-read the post, my bad!

 

Regards, PaulRyan.

[username01]

Thanks, but it didn't worked still:

while($row = mysql_fetch_row($query)) {
if $row[3] == '0' {$row[3] = $value_text}
echo "<tr>";
echo '<td>' . $row[0] . '</td>';
echo '<td>' . $row[1] . '</td>';
echo '<td>' . $row[2] . '</td>';
echo '<td>' . $row[3] . '</td>';
echo '<td>' . $row[4] . '</td>';
echo "</tr>\n";
}

[Jessica]

Before all your echo's, add print_r($row); and show us what it says

[username01]

It doesn't load the page at all. It's a blank page either way, so I can't tell you that. :/

[Jessica]

Then you have an error and you don't have error reporting turned on or set high enough.

[username01]

How can I turn that... error reporting on?

[Jessica]

|

|

|

V

[username01]

Where should I put that error_reporting() and E_ALL?

[Jessica]

Where would make sense?