Database Navigation

[sparkblaze]

Hi,

I'm wondering if I'm able to create a collection of links in a table say...

ID | link
---------
1 | /target/index.html
2 | /folder/spiffle.html

etc

then, add a customised selection to a different table's field as say... 1;3;

explode the field at ';' and then pass it back through the table echoing any matches...?

[Mrblogs]

All in one SQL sequence?

using what DBMS?

[sparkblaze]

I'm only really proficient in MySQL and only have access to a MySQL server anyway.

My assumption is that this would be possible, however, I don't really know where I should start or what functions would do it...

I imagine a for/foreach... but don't understand them so it's a little hard to get started on my own

[Izzmo]

Are you saying you do not have access to a webserver with PHP to create your own code, or are you saying you need a PHP code to display that information through you SQL DB?

Sorry if I'm confused here, just need to know exactly what you're saying!

Thanks.

[sparkblaze]

I've got PHP, got a MySQL database, got the tables set up as in the first post ( but with a `name` field also ).

I just need the code to display the records from the database which match the array...

so I query from a users record a field... and then I have

$mylinks = explode( ';', $result);

Then with each of these... I want to return ONLY the records from the navigation table which match an exploded value from $mylinks...


not very good at explaining this.

[Mrblogs]

"SELECT LinkIDList from LinkList where ListID=1"

// fetch data back using mysql

$mylinks = str_replace(";",",",$result);

SELECT * FROM Links WHERE ID IN ($mylinks)

[Izzmo]

That would work, but you will need to then print the data into your tables. I think you know how to do that though