|
<form action=reportvdo.php><font size=0> <select name=roption size=4> <option value=1 selected>1. Detail of borrow and borrowd (no input value) <option value=2>2. Group by vid and count (no input value) <option value=3>3. Link 3 table with order by (no input value) <option value=4>4. User report 3 (bdate - input value to select) </select> <input name=voption value="2001-12-21"><input type=submit value=Report_VDO> </form> <? require("connect.php"); if (!$roption) { exit; } switch ($roption) { case "1": $sql="select * from borrow,borrowd where borrow.bid = borrowd.bid"; $result = mysql_db_query($db,$sql); echo "$sql<br>"; while ($object = mysql_fetch_object($result)) { echo $object->bid."-".$object->vid."-".$object->bdate."-".$object->sdate."<br>"; } break; case "2": $sql="select vid,count(vid) from borrow,borrowd where borrow.bid = borrowd.bid "; $sql=$sql."group by borrowd.vid"; $result = mysql_db_query($db,$sql); echo "$sql<br>"; while ($data = mysql_fetch_row($result)) { echo "$data[0] - $data[1]<br>"; } break; case "3": $sql="select bdate,sdate,vid,vname,bflag from borrow,borrowd,story "; $sql=$sql."where borrow.bid = borrowd.bid and left(borrowd.vid,8) = story.vid8 "; $sql=$sql."order by borrow.bdate desc"; $result = mysql_db_query($db,$sql); echo "$sql<br>"; while ($data = mysql_fetch_row($result)) { echo "$data[0] | $data[1] | $data[2] | $data[3] | $data[4]<br>"; } break; case "4": $sql="select bdate,sdate,vid,vname,bflag from borrow,borrowd,story "; $sql=$sql."where borrow.bid = borrowd.bid and left(borrowd.vid,8) = story.vid8 "; $sql=$sql."and borrow.bdate = '$voption' and borrowd.bflag = 'S'"; $result = mysql_db_query($db,$sql); echo "$sql<br>"; while ($data = mysql_fetch_row($result)) { echo "$data[0] | $data[1] | $data[2] | $data[3] | $data[4]<br>"; } break; } mysql_close($connect); ?> |