Welcome to the Question2Answer Q&A. There's also a
demo
if you just want to try it out.
Login
Login
Register
All Activity
Questions
Hot!
Unanswered
Tags
Users
Ask a Question
About
Wiki
Welcome to the Q&A for
Question2Answer
.
If you have questions about the platform,
click here to ask
and please use English.
If you just want to try Q2A, please use the
demo
, which also grants admin access.
Apr 29:
Q2A 1.5.2
Related questions
How to find next question id under a category or tag?
How to run multiple Q2a from single database for different websites ?
How to load a single question overview
Want to build a todays question feature, how to access a single question by its number in advanced theme ?
Theming question: How to refer to the single question site only ?
MySql VIEW table for single sign-on no update
How to tell (from theme) that we're editing the question?
How can i get random question from database ?
how can i change the 8000 character value from hardcoded into the database:
How to show all questions with answers and comments under one tag?
All categories
Q2A Core
(3,261)
Plugins
(358)
How to retrieve a single question from the database.
+2
votes
Hi There
I'm not very good with databse queries :(< sad face.
What would be the fastest way to pull information for a single question from the database, the same information you would find in the list of questions on Q2A front page that links the questions ?
Would really preciate it if someone could show me the code for that :).
database
question
single
asked
Aug 29, 2011
in
Q2A Core
by
Eschelon
There is a similar question here:
http://www.question2answer.org/qa/8595/how-can-i-get-random-question-from-database
Please
log in
or
register
to add a comment.
Please
log in
or
register
to answer this question.
1 Answer
0
votes
Best answer
require_once QA_INCLUDE_DIR.'qa-db-selects.php';
$post=qa_db_single_select(qa_db_full_post_selectspec(null,$postid));
answered
Aug 30, 2011
by
NoahY
:O Thankyou so much Noah,
I haven't tested it yet, I managed to load the content on to a flash movie for each slug.
I'm certain this is a very usefull bit of sql for many users thou.
sorry about before!, Peace bortha XD.
no problem, we are all in it together :)
Please
log in
or
register
to add a comment.