mysql error

[Osterling]

$journal_views = $DB_site->query("
							SELECT u.username, j.journalid, j.title, j.description, j.timestamp, j.userid, j.entries, j.views
							FROM journal j
							LEFT JOIN user u ON u.userid = j.userid
							WHERE j.enabled = 1
							ORDER BY j.views DESC
							LIMIT " . "$vboptions[journals_viewdisplaylimit]
							");

that' it... thank you so much

[Davey]

Could you try replacing it with this, and telling me what happens then?

$journal_views = $DB_site->query("
							SELECT u.username, j.journalid, j.title, j.description, j.timestamp, j.userid, j.entries, j.views
							FROM journal j
							LEFT JOIN user u ON u.userid = j.userid
							WHERE j.enabled = 1
							ORDER BY j.views DESC
							LIMIT $vboptions['journals_viewdisplaylimit']
							");

Thanks.

[Osterling]

i get this error:

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/exas77ko/public_html/forum/journal.php on line 1211

[Brad]

Try this instead:

PHP Code:

$limit_views = intval($vboptions['journals_viewdisplaylimit']);
$journal_views = $DB_site->query("SELECT u.username, j.journalid, j.title, j.description, j.timestamp, j.userid, j.entries, j.views FROM journal j LEFT JOIN user u ON u.userid = j.userid WHERE j.enabled = 1 ORDER BY j.views DESC LIMIT" . $limit_views); 


[Davey]

Ah, brad.loo to save the day.

edit. hey brad.loo, maybe you could help with my problem :devious: look about 10 threads down lol.

[Osterling]

Originally Posted by Brad.loo

Try this instead:

PHP Code:

$limit_views = intval($vboptions['journals_viewdisplaylimit']);
$journal_views = $DB_site->query("SELECT u.username, j.journalid, j.title, j.description, j.timestamp, j.userid, j.entries, j.views FROM journal j LEFT JOIN user u ON u.userid = j.userid WHERE j.enabled = 1 ORDER BY j.views DESC LIMIT" . $limit_views); 


when i did that, i got this error

Database error in vBulletin 3.0.0:

Invalid SQL: SELECT u.username, j.journalid, j.title, j.description, j.timestamp, j.userid, j.entries, j.views FROM journal j LEFT JOIN user u ON u.userid = j.userid WHERE j.enabled = 1 ORDER BY j.views DESC LIMIT0
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 'LIMIT0' at line 1

mysql error number: 1064

[Brad]

Argh...damn array, use this:

PHP Code:

$journal_views = $DB_site->query("SELECT u.username, j.journalid, j.title, j.description, j.timestamp, j.userid, j.entries, j.views FROM journal j LEFT JOIN user u ON u.userid = j.userid WHERE j.enabled = 1 ORDER BY j.views DESC LIMIT"  . $vboptions['journals_viewdisplaylimit']); 


[Osterling]

Database error in vBulletin 3.0.0:

Invalid SQL: SELECT u.username, j.journalid, j.title, j.description, j.timestamp, j.userid, j.entries, j.views FROM journal j LEFT JOIN user u ON u.userid = j.userid WHERE j.enabled = 1 ORDER BY j.views DESC LIMIT
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: Saturday 21st of August 2004 12:19:31 AM
Script: http://www.exasko.info/forum/journal.php

thats the error i get when made the other change

[Brad]

Wait, is the the journal script posted on evB? Last I heard that has alot more errors then just then one, just so you know.

You can try throwing this at it, are you sure you set up all the vBoptions for that script correctly?

PHP Code:

$journal_views = $DB_site->query("SELECT u.username, j.journalid, j.title, j.description, j.timestamp, j.userid, j.entries, j.views FROM journal j LEFT JOIN user u ON u.userid = j.userid WHERE j.enabled = 1 ORDER BY j.views DESC LIMIT".$vboptions[journals_viewdisplaylimit]); 


Altho im not sure why the single quotes in the array would throw it off any.

[Osterling]

no.. didn't fixc the problem