zenag Posted April 17, 2008 Share Posted April 17, 2008 if not..... i wl try fix it .... Quote Link to comment Share on other sites More sharing options...
tuxbuddy Posted April 17, 2008 Author Share Posted April 17, 2008 Its seems to work now ..It is displaying : 9....That I always wanted..Thanks man..Now i think the incident.contact_id = 9 should work..lemme see Quote Link to comment Share on other sites More sharing options...
tuxbuddy Posted April 17, 2008 Author Share Posted April 17, 2008 Can yu tell me how gonna I write the code now: Should I try like this: $sql1 = mysql_query("SELECT id from users where loginname ='".$myusername."'",$link); $row = mysql_fetch_row($sql1); echo "$row[0]"; #while($result=mysql_fetch_row($sql1 )) #{ #echo $result; #$uid=$result["id"]; #echo "$uid"; } $result2 = mysql_query("SELECT incidents.id, incidents.description, users.firstname, users.surname, users.loginname FROM incidents,users WHERE (incidents.owner_id = users.id) OR (incidents.contact_id = '".$row[0]."')", $link); But it is not working Quote Link to comment Share on other sites More sharing options...
zenag Posted April 18, 2008 Share Posted April 18, 2008 now assign variable.... $uid=$row[0]; echo $uid; $result2 = mysql_query("SELECT incidents.id, incidents.description, users.firstname, users.surname, users.loginname FROM incidents,users WHERE (incidents.owner_id = users.id) OR (incidents.contact_id = '".$uid."')", $link); echo ("SELECT incidents.id, incidents.description, users.firstname, users.surname, users.loginname FROM incidents,users WHERE (incidents.owner_id = users.id) OR (incidents.contact_id = '".$uid."')"; echo $result2 ; if echo $result2 ; displays some resource then query is running ..if not query has some problem...in it.. Quote Link to comment Share on other sites More sharing options...
tuxbuddy Posted April 18, 2008 Author Share Posted April 18, 2008 I will check with that...But can you pliz go thru the Helpcore directory I have sent to you. There you will see a file related to timing.That tool is 24*7 but we need to modify it to 9:30 to 6:00 office timing...coz it effects SLA..... Did you installed the tool?? Quote Link to comment Share on other sites More sharing options...
zenag Posted April 18, 2008 Share Posted April 18, 2008 yeah i ve installed it..i wl check that.. Quote Link to comment Share on other sites More sharing options...
zenag Posted April 18, 2008 Share Posted April 18, 2008 in which file...i mean file name..& also...i cant run after registration/index.php.. ???? Quote Link to comment Share on other sites More sharing options...
zenag Posted April 18, 2008 Share Posted April 18, 2008 yeah...ive installed in my system ...and got it running...... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.