drew22299 — Mon, 30 Jul 2007 10:53:26 +0000

I think I know why it doesn't work! It's refering to a table called message in the asp, and the actual table name is messages

drew22299 — Mon, 30 Jul 2007 10:31:42 +0000

the messageId 478473 is just an example because it is an int, I think the SQL query is something like

SELECT * FROM messages WHERE userto =

<?php
username
?>

MessageId:

<?php
=rs("messageId")
?>

To:

<?php
=rs("userto")
?>

From:

<?php
=rs("userfrom")
?>

Message:

<?php
=rs("message")

<%username
?>

is a cookie that contains the current logged in user, which is used to get the data from the messages database for userto, since the logged in user wants to get messages that have been sent to them. Would this work because it is not refering to the primary key which is the MessageId?

Busy — Mon, 30 Jul 2007 10:20:21 +0000

Is Message 11293 one field or you just missed out a comma?

The error is saying the message field doesn't exist, can you give us the query your using, should be something like:

Select message from databasetable where UserTo='user';