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,
assigneddate,
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"];
mysql_free_result($result);
-IrishBiotch
[EMAIL PROTECTED]
_________________________________________________________________
Join the world’s largest e-mail service with MSN Hotmail.
http://www.hotmail.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
