Why can php MYSQL be so stubborn at times.

Louis Platini 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
> more
> complex and spent 4 hours on this STOOOOPID thing.
>
> AnnMarie Otoole.
>
> _______________________________________________
> Click here to unsubscribe or manage your list subscription:
> https://lists.secondlife.com/cgi-bin/mailman/listinfo/secondlifescripters
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.secondlife.com/pipermail/secondlifescripters/attachments/20091216/4c650626/attachment.htm 


More information about the secondlifescripters mailing list