RE: [PHP] QUery success, but blank results/variables
| From: | David Freeman | Date: | Tue, 10 Sep 2002 04:12:35 +0000 |
| Subject: | RE: [PHP] QUery success, but blank results/variables | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-115809@lists.php.net to get a copy of this message | ||
If you've typed your code in accurately then...
> $detailqry = "SELECT id, parentitemid, itemtypeid, itemstatusid,
[etc]
> $result = mysql_query($detailqry) or die("Failed finding
> task details");
somewhere in about here you want to have something like:
$sqldata = mysql_fetch_array($result);
> $taskid = $result["id"];
[etc]
... and if you are doing a query that will return more than one row then
you should also look at some sort of looping mechanism to step through
your result set.
CYA, Dave