Hello everyone..tryin to run this qry against a mysql db, but after it runs, 
it doesn't assign anything to the variables as it should. If i return all 
rows, and spit out each record in the result in an array, i have the same 
problem, but have 24 'blank' records instead of 1. Any ideas? Thanks for any 
input. I tried doing a print mysql_error(); after the query and the result, 
but it doesn't return anything. Column names, db name, and WHERE clause are 
all spelled correctly, and the $currenttaskid is populated (as 1)...

$detailqry = "SELECT id, parentitemid, itemtypeid, itemstatusid, 
itemlevelid, shortdescription,
createdby_memberid, assignedto_memberid, completedby_memberid, createddate, 
estcompletiondate, completeddate, projectid, lastuserid, lastdate FROM item 
WHERE id=$currenttaskid";

$result = mysql_query($detailqry) or die("Failed finding task details");

       $taskid = $result["id"];
       $taskparentitemid = $result["parentitemid"];
       $taskitemtypeid = $result["itemtypeid"];
       $taskitemstatusid = $result["itemstatusid"];
       $taskitemlevelid = $result["itemlevelid"];
       $taskshortdescription = $result["shortdescription"];
       $createdbyid = $result["createdby_memberid"];
       $assignedtoid = $result["assignedto_memberid"];
       $completedbyid = $result["completedby_memberid"];
       $taskcreateddate = $result["createddate"];
       $taskassigneddate = $result["assigneddate"];
       $taskestcompletiondate = $result["estcompletiondate"];
       $taskcompleteddate = $result["completeddate"];
       $taskprojectid = $result["projectid"];
       $tasklastuserid = $result["lastuserid"];
       $tasklastdate = $result["lastdate"];



Join the world’s largest e-mail service with MSN Hotmail. 

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to