trying to do a simple query

[willms_jay]

first of all, I've had no luck with the $DB_SITE command, it's given me nothing but problems for the query I want to do.

I have replaced :

PHP Code:

            $DB_site->query("INSERT INTO post (postid,threadid,title,username,userid,dateline,attachmentid,pagetext,allowsmilie,showsignature,ipaddress,iconid,visible) VALUES (NULL,'$threadid','".addslashes(htmlspecialchars($title))."','".addslashes($postusername)."','$bbuserinfo[userid]','".time()."','$attachmentid','".addslashes($message)."','$allowsmilie','$signature','$ipaddress','$iconid','$visible')"); 


in newreply.php with the following :

PHP Code:

            // inserting the post here.
            $DB_site->query("INSERT INTO post (postid,threadid,title,username,userid,dateline,attachmentid,pagetext,allowsmilie,showsignature,ipaddress,iconid,visible) VALUES (NULL,'$threadid','".addslashes(htmlspecialchars($title))."','".addslashes($postusername)."','$bbuserinfo[userid]','".time()."','$attachmentid','".addslashes($message)."','$allowsmilie','$signature','$ipaddress','$iconid','$visible')");
        
        // jordan's credits hack!
        $myuserid = $bbuserinfo['userid'];
        $myconnection = mysql_connect("localhost", "sample_samplecij", "orBux2");    
    
        if (!$myconnection) {

            echo "<p> An error occured while trying to access the database, please notify the webmaster for a quick solution.</p><br>";

            echo mysql_errno().": ".mysql_error()."<br>";

            exit();

        }

        $creditquery = "UPDATE sc_reviewaccounts SET posts=posts+1 WHERE userid='$myuserid'";

        mysql_db_query($dbname, $creditquery); 


so as to reward a user one credit each time they reply to a post.

but... check this weirdness out! this is the SQL error i get :

and i get the following error :

Database error in vBulletin 2.2.9:

Invalid SQL: SELECT title FROM thread WHERE threadid=
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 '' at line 1

mysql error number: 1064

Date: Friday 23rd of May 2003 07:26:51 PM
Script: http://www.samplecity.net/forum/forum/newreply.php
Referer: http://www.samplecity.net/forum/newr...threadid=21353

anyone have a clue what i can do to make this work?

..jordan willms

[Gary King]

Show us the bit of code around [sql]SELECT title FROM thread WHERE threadid=[/sql]

[willms_jay]

that is what is very strange. THERE IS no occurance of

PHP Code:

SELECT title FROM thread WHERE threadid= 


anywhere in newreply.php at all!

[Gary King]

Because the conditions and arguments are variables.

Anyways, I can't even find that in my newreply.php

[Dean C]

You don't need to make a connection to the db as it's already there...

- miSt

[willms_jay]

then what the heck do i do? I've tried using the DB_SITE technique, but it NEVER works, at least for what i am trying to do.

[Gary King]

Today at 06:25 PM willms_jay said this in Post #6
then what the heck do i do? I've tried using the DB_SITE technique, but it NEVER works, at least for what i am trying to do.

Show us what you tried to do using the $DB_site method (the query including $DB_site).