Why can php MYSQL be so stubborn at times.
louis.platini at gmail.com
Wed Dec 16 11:17:10 PST 2009
The mysql user has read permission for the table?
On Wed, Dec 16, 2009 at 4:47 PM, <AnnMarie at slfbi.com> wrote:
> What am I doing wrong?
> $result = MYSQL_QUERY("SELECT Data FROM '$Table' WHERE List = '$List' ");
> $row = MYSQL_FETCH_ARRAY($result);
> $Data = $row['Data'];
> echo $Data;
> I've used this sequence a thousand times.
> I've triple checked all field names.
> I've re-typed it in case of invisible characters embedded.
> Other things on the table are working. I'm able to write to it and update
> the Data field but not read it back.
> So far as I can analyze, it is not getting $result in line 1.
> $Table name is "Attendance", checked that with echo.
> $List is "employees", checked that with echo.
> Is it because the table is currently so small that the $result set would
> have only 1 row with only 1 column?
> Ooo its so frustrating, I've got other parts working that are 100 times
> complex and spent 4 hours on this STOOOOPID thing.
> AnnMarie Otoole.
> Click here to unsubscribe or manage your list subscription:
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the secondlifescripters