Posted by Vince Morgan on 10/04/06 09:01

"BlackSpider" <BlackSpider@I.Dont.Exist.com> wrote in message
news:v5ednayzlo_lYr_YRVnytQ@eclipse.net.uk...
> <--PHP
> function TableData($slot)
> {
> global $row_Recordset1, $colour_FREE, $colour_TOOK;
>
> $slotuser = $row_Recordset1[$slot];
> if ($slotuser == "") {
> return ($colour_FREE.'" class="timeslot"><div
> align="center">'.$slotuser );
> }
> else {
> return ($colour_TOOK . '" class="timeslot"><div align="center">' .
> $row_Recordset1[ $slot ]);
> }
>
> }
> PHP-->
>
> The $row_Recordset1 array is set by mysql_fetch_assoc to get some table
> data, and I call this function with the table-row name (In this case
> "date"), like this: TableData('date')
>
> However, when trying to get the data of the row 'date' from the Record
using
> $slot, it returns a null string, regardless of what data is actually
there.
> If I replace $slot with 'date' in the code, it returns the correct value,
so
> the connection between php/Mysql is fine, but when trying to get the data
by
> using a String as the Key, it simply doesn' twork. Any ideas?
>
>
I think you may need to append single quotes to get it to work.

$var = "'"."table-row name "."'";


HTH
Vince Morgan

[Back to original message]