masalah mysql nih...sile tgk coding ni..

[kotaku]

yg bawah ni utk nak cari jumlah ari >

$howmanydaysa = mysql_query("SELECT * FROM calendar WHERE day=$sadd && monthyear=$sammyy",$db);
$howmanydaysd = mysql_query("SELECT * FROM calendar WHERE day=$sddd && monthyear=$sdmmyy",$db);

$totalnight = $stay;
function i()
{
$stay=1;
if ($howmanydaysa!=$howmanydaysd) {
$stay++; }
else {
return $stay; }
}

$totalamount = $pernight * $totalnight;

echo("totalnight= $totalnight");

-------------------

tapi $totalnight tu tak kuar laaaa...tak logik la makne nye...so ape masalah nyer?

[awanferra]

emm... $totalnight di assign ke $stay which is takde...
and then function i() tu pun tak call... kalau call pun takde statement utk set $totalnight... so kosong laa $totalnight tu...

[Diskuzar]

pindahkan $totalnight = $stay; ke line sebelum
$totalamount = $pernight * $totalnight;


eg.

$totalnight = $stay;
$totalamount = $pernight * $totalnight;