QUERY ARRAY IN PHP MYSQL

marisarisa

I have problem in my task, please help me:
Array :
$myPath[$i] = {1,2,5,6,7}

database hub:

id from to Path length

a 1 2 kapten tendean 1.2
b 2 5 majapahit 5.4
c 5 6 kyai maja 1.3
d 6 7 jendr.sudirman 2,1

I want my output like :

Kapten Tendean -majapahit-kyai maja-jendr.sudirman

In my php code like that:

$value1 = current($myPath[$i]);
$value2 = next($myPath[$i]);

$query3 = mysql_query("SELECT Path from hub where
from = $value1 and to = $value2") or die (mysql_error());
{

while($row3 = mysql_fetch_row($query3))
{
$jalan[$row] = $row3[0];
$foo2 .= sprintf("(%s)\n",
$jalan[$row]);
}

return $foo2;

and the result will give me only:
Kapten Tendean

I confuse in looping array in linked list php, please give me solution..Thanks before

thepeccavi

I think with a little restructuring MySQL could do most of the leg-work for you. I would recommend storing the different places in one table (eg. hub_paths) and the from-to pairs in another (eg. hub_destinations). In that case you could use a query like this:

SELECT hub_destinations.*, hub_paths1.name as from_name, hub_paths2.name as to_name
FROM hub_destinations
JOIN hub_paths as hub_paths1 ON hub_destinations.from = hub_paths1.name
JOIN hub_paths as hub_paths2 ON hub_destinations.from = hub_paths2.name

Then you will get pairs like "Kapten Tendean/majapahit" and "majapahit/kyai maja". Then you just have to work out how to string them together! I think that if you add "ORDER BY from ASC" to that query it might make that slightly easier. It would get infinately more complex if you start going 2-7-5-6 or something like that for your path though.

I think that query is probably more likely to not work than work (I am no MySQL expert), but I hope it gives you a starting point to work on - never underestimate the power of a good SQL query (I've used one to save 50 or so lines of code!!).

Isaac