21,881
社区成员
发帖
与我相关
我的任务
分享
<center><font color=black size=3>Input start date:</font>
<INPUT type="text" name="startdate" >
<font color=black size=3>Input end date:</font>
<INPUT type="text" name="enddate" >
<INPUT type="Submit" name="submit" value = "Submit" onclick=""></center>
mysql_connect("localhost", "meliorisuser", "ticketsql123!") or die(mysql_error());
mysql_select_db("support_xx") or die(mysql_error());
$strSql = "select tickets.ID as ID,ticket_messages.timestamp AS DateReceived,ticket_answers.timestamp as LastDate,tickets.status as status,tickets.partner as partner,tickets.phone as phone,ticket_categories.name as ProgramType,tickets.name as name,tickets.email as email,tickets.subject as subject,ticket_attachments.filename as yesno,tickets.timestamp as closeddate,ticket_reps.name as Representative from tickets LEFT OUTER join ticket_answers on tickets.ID = ticket_answers.ticket LEFT OUTER join ticket_categories on tickets.cat = ticket_categories.ID LEFT OUTER join ticket_reps on ticket_answers.rep = ticket_reps.ID LEFT OUTER join ticket_attachments on tickets.ID = ticket_attachments.ticket LEFT OUTER join ticket_messages on tickets.ID = ticket_messages.ticket where ";
//?mysql_query???user??????
$result=mysql_query($strSql);