else if ? why isn't it working

[panreach]

I can't figure out why result2 prints out with mysql_num_rows($result2) when there is no data in the first result. The

if (!jan2)
{
exit;
}

else
{ bla bla }

Must be wrong I guess.
Does anybody no why this isn't working?
Thank you in advance for helping!

// January 2002

$jan2 = "SELECT venue.name, venue.street, venue.City, venue.phone, venue.directions, event.date, event.start, event.sm, event.end, event.em, DATE_FORMAT(event.date,'%a. %m/%d/%y') AS fmt_date 
FROM venue,event 
WHERE event.venueid = venue.venueid
AND '2001-12-31' < event.date  
AND event.date < '2002-02-01'
AND (UNIX_TIMESTAMP(event.date)+31*24*60*60 > UNIX_TIMESTAMP(now())) 
ORDER BY UNIX_TIMESTAMP(event.date)"; 

$result = mysql_query($jan2);



if (!jan2)
{
 exit;
}
else

{
$jan2a = "select month, year from yearandmonth where month = 'january' and year = 2002";
$result2 = mysql_query($jan2a);

$num_results2 = mysql_num_rows($result2);

{
$row = mysql_fetch_object($result2);
  echo "<p><b>";
  echo stripslashes($row->month)."\t";
  echo stripslashes($row->year)."\t";
  echo "</b></p><ul type=circle>";
}


$num_results = mysql_num_rows($result);


for ($i=0; $i <$num_results; $i++)
{

$row = mysql_fetch_object($result);

  echo "<li>";
  echo stripslashes($row->fmt_date)."\t";
  echo stripslashes($row->start);
  echo stripslashes($row->sm)."-";
  echo stripslashes($row->end);
  echo stripslashes($row->em)."\t";
  echo stripslashes($row->name)." - ";
  echo stripslashes($row->street)."  ";
  echo stripslashes($row->City)."-";
  echo stripslashes($row->phone)."\t";
  echo stripslashes($row->directions);
  echo "</li>";
}

echo '</ul><br />';

}

[Anon]

if (!jan2)

should be: if (!(jan2))

[panreach]

For some reason it is still not working.

[Anon]

I think it must be

if (!$result) ...

rather than

if (!jan2) ...

[panreach]

I tried if (!result)

and tried
if (!$result)

and tried
if (!($result))

and tried
if (!(result))

but nothing. It must be something else.

[panreach]

I'm sorry I tried this:

if ($result)

{
echo "$result";
exit;
}

and now for some reason it is showing

Resource id #2

Now what is this I ask?

[[deleted]]

You're trying to do things with functions and returnvalues without having a clue about what the functions do and what they return. Manuals are your friends, read them.

And read this:
http://www.hvt-automation.nl/yapf/faq.php?cmd=viewitem&itemid=12

---

A forum, a FAQ, what else do you need?

Time to YAPF!: http://www.hvt-automation.nl/yapf/

[panreach]

Works like a charm oh yea thanks for your uhm help man &()&@)%)(&@%

// January 2002

$jan2 = "SELECT venue.name, venue.street, venue.City, venue.phone, venue.directions, event.date, event.start, event.sm, event.end, event.em, DATE_FORMAT(event.date,'%a. %m/%d/%y') AS fmt_date
FROM venue,event
WHERE event.venueid = venue.venueid
AND '2001-012-31' < event.date

AND event.date < '2002-02-01'
AND (UNIX_TIMESTAMP(event.date)+312460*60 > UNIX_TIMESTAMP(now()))
ORDER BY UNIX_TIMESTAMP(event.date)";

$result = mysql_query($jan2);

if (mysql_num_rows($result) < 1)

{

}
else
{

$jan2a = "select month, year from yearandmonth where month = 'january' and year = 2002";

$result2 = mysql_query($jan2a);

$num_results2 = mysql_num_rows($result2);

{
$row = mysql_fetch_object($result2);
echo "<p><b>";
echo stripslashes($row->month)."\t";
echo stripslashes($row->year)."\t";
echo "</b></p><ul type=circle>";
}
$result = mysql_query($jan2);

$num_results = mysql_num_rows($result);

for ($i=0; $i <$num_results; $i++)
{

$row = mysql_fetch_object($result);

echo "<li>";
echo stripslashes($row->fmt_date)."\t";
echo stripslashes($row->start);
echo stripslashes($row->sm)."-";
echo stripslashes($row->end);
echo stripslashes($row->em)."\t";
echo stripslashes($row->name)." - ";
echo stripslashes($row->street)."  ";
echo stripslashes($row->City)."-";
echo stripslashes($row->phone)."\t";
echo stripslashes($row->directions);
echo "</li>";

}

echo '</ul><br />';
}