rebuild pm with pmtext?

[Scooby Snacks]

Had a problem with my pm table is there anyway to rebuild my pm table from the pmtext table?

thanks in advanced

[Marco van Herwaarden]

Would help if you posted the exact error you're getting.

[Scooby Snacks]

no error I just have a few members that lost all there PMs anyway to get them back from the pmtext table since they are still there?

I can pull the data with the following sql that I would need.

$sql = 'SELECT `pmtextid` , `fromusername` , `title` , `message` , `touserarray` , `dateline` ';
$sql .= 'FROM `pmtext` ';
$sql .= 'WHERE 1 AND `touserarray` ';
$sql .= 'LIKE \'USERINFOHERE\' LIMIT 0, 30';

What I need help with is how to put it into a php form so that I can give the 2 members access to the php file so they can view their old PMs and save them