way to inserting data into a MYSQL table data in an ordered way

[komrad]

Hello all,

I'd like to know if there is a way to insert into a MYSQL table data in an ordered way?
Right now as a workaround I've literally made a table of questions with questionID as primary key, nextQuestion and prevQuestion pointing to other questionIDs. Basically I've made a two way linked list from scratch. Is there anything built into MYSQL that implements this?

Thanks in advance.

[marylane]

Anyone? I would be interested in this too, as I have a habit of making a mess

[troublescoot]

Originally Posted by komrad

Hello all,

I'd like to know if there is a way to insert into a MYSQL table data in an ordered way?
Right now as a workaround I've literally made a table of questions with questionID as primary key, nextQuestion and prevQuestion pointing to other questionIDs. Basically I've made a two way linked list from scratch. Is there anything built into MYSQL that implements this?

Thanks in advance.

It seems like you want a way to automagically point to the previous/next records for navigational purposes.

If that's what it is, you can just do a query for each-

<?php

$previous = mysql_query(sprintf("SELECT questionID FROM [table] WHERE (questionID < %d) LIMIT 1", $currentQuestionId));

$next = mysql_query(sprintf("SELECT questionID FROM [table] WHERE (questionID > %d) LIMIT 1", $currentQuestionId));

?>

That's a very rudimentary way of doing it.

Not sure if that helps, but it's all I could do given the info.

[tanja]

Thanks for your explanation! It's very useful for me

[jurwanwall]

#
INSERT INTO question_list
#
SET TEXT='The text of the question',
#
previous_id='-1',
#
next_id='-1';

#
INSERT INTO question_list
#
SET TEXT='Inside question text',
#
previous_id=LAST_INSERT_ID(),
#
next_id=-1;

#
#
UPDATE question_list

#
INSERT INTO question_list
#
SET TEXT='Inside question text',
#
previous_id=LAST_INSERT_ID(),
#
next_id=-1;

#
#
INSERT INTO question_list
#
SET TEXT='Last question text',
#
previous_id=LAST_INSERT_ID(),
#
next_id=-1;

[israpost]

Originally Posted by jurwanwall

#
INSERT INTO question_list
#
SET TEXT='The text of the question',
#
previous_id='-1',
#
next_id='-1';

#
INSERT INTO question_list
#
SET TEXT='Inside question text',
#
previous_id=LAST_INSERT_ID(),
#
next_id=-1;

#
#
UPDATE question_list

#
INSERT INTO question_list
#
SET TEXT='Inside question text',
#
previous_id=LAST_INSERT_ID(),
#
next_id=-1;

#
#
INSERT INTO question_list
#
SET TEXT='Last question text',
#
previous_id=LAST_INSERT_ID(),
#
next_id=-1;

exactly that's correct check this up i too have used..



Jewish Recipes

[tylerlongtw]

its better to insert your data with any order and use ORDER BY Clause while retrieving your data.