MySQL Query????

[zenag]

if not..... i wl try fix it ....

[tuxbuddy]

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

[tuxbuddy]

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

[zenag]

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..

[tuxbuddy]

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??

[zenag]

yeah i ve installed it..i wl check that..

[zenag]

in which file...i mean file name..& also...i cant run after registration/index.php..  ????

[zenag]

yeah...ive  installed in my system ...and got it running......