vb.org Archive - Major MySQL problems

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Member Archives (https://vborg.vbsupport.ru/forumdisplay.php?f=202)

- - Major MySQL problems (https://vborg.vbsupport.ru/showthread.php?t=42712)

Ninth Dimension

08-24-2002 10:39 PM

Major MySQL problems

1 Attachment(s)

Hi, what am I doing wrong in the query below?

Quote:

SELECT vbs_chapters.id,vbs_chapters.chapterid,vbs_chapter s.storyid,vbs_chapters.title,vbs_chapters.body,vbs _chapters.path1,vbs_chapters.path2,vbs_chapters.us erid,vbs_chapters.dateline,vbs_chapters.display,us er.username FROM vbs_chapters,user $showallvalue AND vbs_chapters.storyid = $storyid AND vbs_chapters.userid=user.userid ORDER BY vbs_chapters.chapterid

I've attached the sql for the tables so you can see them if you want to.

Ninth Dimension

08-24-2002 10:55 PM

I've just realised that the query above is not going to help you much as it's missing a lot of the data.

here is a sample query after the script has done it's calculations.

Quote:

SELECT vbs_chapters.chapterid,vbs_chapters.storyid,vbs_ch apters.title,vbs_chapters.body,vbs_chapters.path1, vbs_chapters.path2,vbs_chapters.userid,vbs_chapter s.dateline,vbs_chapters.display,user.username FROM vbs_chapters,user WHERE (vbs_chapters.chapterid = 4) OR (vbs_chapters.chapterid = 2) OR (vbs_chapters.chapterid = 1) AND vbs_chapters.storyid = 5 AND vbs_chapters.userid=user.userid

Issvar

08-27-2002 12:08 AM

The first query misses the WHERE keyword.
The second query might not do what you intend to do, you probably want an extra set of parentheses around the three WHERE clauses joined by OR.

Last hint, when you have a problem tell what is wrong.

Ninth Dimension

08-27-2002 12:14 AM

Hi, sorry I should have updated this thread, I solved the problems (or rather found someone else that knew the answer).

but thank you for your help anyway. :D

All times are GMT. The time now is 07:00 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01076 seconds Memory Usage 1,713KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (4)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: