hello
hot last reviewpost and vb version
I have separate dbase and got this pb :
Quote:
Database error in vBulletin 3.5.3:
Invalid SQL:
SELECT COUNT(*) AS count FROM colleurs-de-plastiquecom4 WHERE userid = 37;
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-de-plastiquecom4 WHERE userid = 37' at line 1
Error Number : 1064
Date : Wednesday, May 24th 2006 @ 03:20:32 PM
Script : http://www.xxxxxxxxxxxxxxxxxxx/forum...ead.php?t=5430
Referrer : http://www.xxxxxxxxxxxxxxx/forums/forumdisplay.php?f=17
IP Address : xxxxxxxxxx
Username : xxxxxxxxxxxxxxxxxxx
Classname : vb_database
|
this is the code of the module
Quote:
global $db, $vbulletin;
if ($this->post['userid'])
{
$rpproductssinpostbit = $db->query_first("SELECT COUNT(*) AS count FROM colleurs-de-plastiquecom4 WHERE userid = $post[userid]");
$trackpadsrpprodpbit = vb_number_format($rpproductssinpostbit['count']);
}
|
thanks