Get ready for BLACK FRIDAY shopping starting in

Forums

PHP

This topic is locked

Dreamweaver Recordset help...

Posted 18 Aug 2007 02:19:25
1
has voted
18 Aug 2007 02:19:25 paul hampson posted:
Hi all,

Must admit im pretty stumped. If anyone can help I would be most grateful...

I have created a session variable that is set to my members database 'username'. My recordset is set to get all records from member database WHERE the session variable = 'user_name'...

This works perfectly. There is only one name in the database (for testing purposes), thats 'mrbigdog'.

Thus, if im logged in (as mrbigdog) button 'a' should be hidden from the user (using dreamweaver 'show if recordset empty'). Strangely, the 'hide region' behavior doesn't work either way. It always shows button 'a' wether I am logged in or not!

Really dont understand what im doing wrong. This is my recordset:

SELECT *
FROM collections
WHERE ID_MEMBER = colname (colname = $_SESSION['user_name'])

Any help would be great. Thanks very much.

The meak may inherit the earth, but they better get the hell off the track!

Reply to this topic