somehow, the vars are empty if you try to print or echo them to the screen, but if i echo the $result["field"] directly, the values will show up. something is amiss in the variables when they are being assigned (or not assigned as the case may be), and i am not sure what. The qry does return 1 row, which as mentioned i can echo to the screen, I just can't store the field values into variables. I have no problem doing this throughout my site anywhere else, just in this section of code, which isn't different than any of the others (from what I can tell). Anyone have any ideas, or seen anything similiar?
Thanks to all
$detailqry = "SELECT id, parentitemid, itemtypeid, itemstatusid, itemlevelid, shortdescription, createdby_memberid, assignedto_memberid, completedby_memberid, createddate, assigneddate, estcompletiondate, completeddate, projectid, lastuserid, lastdate FROM item WHERE id=$currenttaskid";
$result = mysql_query($detailqry) or die("Failed finding task details");
$parentitemid = $result["parentitemid"];
$itemtypeid = $result["itemtypeid"];
$itemstatusid = $result["itemstatusid"];
$itemlevelid = $result["itemlevelid"];
$shortdescription = $result["shortdescription"];
$createdbyid = $result["createdby_memberid"];
$assignedtoid = $result["assignedto_memberid"];
$completedbyid = $result["completedby_memberid"];
$createddate = $result["createddate"];
$assigneddate = $result["assigneddate"];
$estcompletiondate = $result["estcompletiondate"];
$completeddate = $result["completeddate"];
$projectid = $result["projectid"];
$lastuserid = $result["lastuserid"];
$lastdate = $result["lastdate"];
mysql_free_result($result);
