no entries in database

[stew]

hey there,

what id like to do is recall and display data from a database on a page. however, if there is no data entered in for a certain variable (place), i'd like to display the following text " no data available", as opposed to just a blank space.

ive got the following so far:

$retida = mysql_db_query($db, $SQLa, $cid);
while ($row = mysql_fetch_array($retida)) {
$price = $row["price"];
$doors = $row["doors"];
$info = $row["info"];
$place = $row["place"];
$day = $row["day"];
$date = $row["date"];
$month = $row["month"];
$year = $row["year"];
if ($place = 0) { echo ("no gigs at this time"); } else {
echo("<tr><td>$place</td>
<td>$day $date $month</td>
<td>$doors</td><td>$price</td></tr>
<tr></tr>"); }

i.e if there is no entry for $place then i'd like it to read " no gigs at this time" and not a blank table entry.

any ideas?

[MungoBBQ]

Instead of:
if ($place = 0) { echo ("no gigs at this time"); }

Try this:
if (!$place) { echo ("no gigs at this time"); }

[devinemke]

*as a side note: look into the extract() function. it looks like you could replace 8 lines of your code with 1:
extract ($row);

[MungoBBQ]

Oh, and I should add that:

if ($var = 0)

is always wrong. Whenever you want to make comparisons, use:

if ($var == 0)

Note the double "=" used to compare two variables. The $var = 0 actually sets $var to 0, which is always going to work, and therefore always come out "TRUE". Good luck!