SELECT pm.*, pmtext.*
, icon.title AS icontitle, icon.iconpath
FROM pm AS pm
LEFT JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid)
WHERE pm.userid=1 AND pm.folderid=0
ORDER BY pmtext.dateline DESC
LIMIT 0, 50;
MySQL Error : Table 'hhgsnet_vb.pmtext' doesn't exist
Error Number : 1146
Request Date : Monday, December 29th 2008 @ 07:13:21 PM
Error Date : Monday, December 29th 2008 @ 07:13:21 PM
Script : http://www.hhgs.net/private.php
Referrer : http://www.hhgs.net/index.php
IP Address : ***********
Username : Ross
Classname : vB_Database
MySQL Version : 5.0.51a-community
When i attempt to read my PM's. How and where would i optimize the table?
12-29-2008, 05:14 PM
Threaded Mode