Displaying all the rows

tito

Hello, I am doing this query:

$query = mysql_query("SELECT *, Cat_ID, Category AS Region FROM $link_table, $cat_table WHERE $link_table.ID = '$ID' AND Cat_ID = $cat_table.ID AND Pending = ''", $db) or die(mysql_error());
$values = mysql_fetch_array($query);

and am able to display the desired info for one row.

addLocationsGroup(<? echo "$values[Cat_ID]"; ?>,"<? echo "$values[Region]"; ?>","<? echo "$values[pointer]"; ?>",15);

How can I make the same query ORDER by ID and display for all rows? So the end result will be:

addLocationsGroups(1,"my region1","mypointer1",15);
addLocationsGroups(2,"my region2","mypointer2",15);
addLocationsGroups(3,"my region3","mypointer3",15);
etc...

thank you

trooper

Simply put ORDER by ID DESC at the end of your query

HTH

nnichols

$query = "SELECT *, Cat_ID, Category AS Region 
	FROM $link_table, $cat_table 
	WHERE $link_table.ID = '$ID' 
	AND Cat_ID = $cat_table.ID 
	AND Pending = '' 
	ORDER BY Cat_ID";

$result = mysql_query($query, $db)
	or die(mysql_error());

while ($values = mysql_fetch_array($result)) {

echo "addLocationsGroups($values['Cat_ID'],$values['Region'],$values['pointer'],15);<br>";

}

Hope this helps 😉

tito

well, that did not return anything. So I assumed that since

WHERE $link_table.ID = '$ID'
AND Cat_ID = $cat_table.ID

are unique, they will never let the other data print. So I removed them. This time, instead of a blank page, I got about a hundreds of these:

addLocationsGroups(,,,15);
addLocationsGroups(,,,15);
addLocationsGroups(,,,15);
addLocationsGroups(,,,15);

Problem is they were empty and I only have 6 data in the database....

nnichols

Can you post the code as it is now and the structure of the 2 tables?

tito

ok, here is the story. I am parsing some values in a javascript in the <head> tags of header.inc. The file index.php calls for header.inc and footer.inc.

Now header.inc is the same for all files. But I need to parse different values in the java.

So here is my setup

in index.php I have

require("common.php");
$query = mysql_query("SELECT *, Cat_ID, Category AS Region FROM $link_table, $cat_table WHERE $link_table.ID = '$ID' AND Cat_ID = $cat_table.ID AND Pending = ''", $db) or die(mysql_error());
$values = mysql_fetch_array($query);

In header.inc I have

<? if ($action == "add_place") {
include("addmap.txt");
}
?>
<?

if ($action == "show"){
include("viewmap.txt");
}
?>

The first include is simple and causes no problem.

the second one is where I pull my info from the query index.php and has:

</script>

and works fine only for cat_ID 1. BECAUSE, all the addLocationsGroup must follow an ordered sequence. If the first value (for Cat_ID) is 1, then everybody is happy.

Now, if that values is 18, for example, it will not display, as it requires the 1,2,3,4 etc... to be displayed first, even if they are not needed.

I am pulling info from 2 tables. Except for Region which is the Category name from the Category table, they all come frome the link table. If I get that first line
addLocationsGroup right, then the line below it will be able to display. For example addLocation uses the same cat_id. And since in my test it is a number higher than 1 (8 actually), and since I am missing the first seven, I get a java error.

Hope I am clear. Thanks for helping me.

nnichols

Try something like this -

<?
$query = "SELECT *, Cat_ID, Category AS Region 
    FROM $link_table, $cat_table 
    WHERE $link_table.ID = '$ID' 
    AND Cat_ID = $cat_table.ID 
    AND Pending = '' 
    ORDER BY Cat_ID ASC";

$result = mysql_query($query, $db)
    or die('MySQL error: '.mysql_error().'<br>Query: '.$query);

while ($values = mysql_fetch_array($result)) {
	$output .= ' addLocationsGroups('.$values['Cat_ID'].','.$values['Region'].','.$values['pointer'].",15);\n";
	}
?>
<script language=javascript> 
function InitializeMap() 
{ 
iniMap("Normal"); 
<? echo $output; ?>
addLocation(<? echo "$values[Cat_ID]"; ?>,<? echo "$ID"; ?>,<? echo "$values[x]"; ?>,<? echo "$values[y]"; ?>,"<? echo "$values[Name]"; ?>","","<? echo "$values[Address1]"; ?> <? echo "$values[Address2]"; ?>\nPhone:<? echo "$values[Phone1]"; ?>"); 
showLocation(<? echo "$values[Cat_ID]"; ?>,<? echo "$ID"; ?> ); 
} 

</script>

I would put the query in with the js instead of having it separately in the index.php

EDIT:
It makes it much easier to read if you post PHP code between [ PHP ] and [ /PHP ] tags. And when asked to describe a table just give the relevant sections of the CREATE TABLE and the related fields for the tables.

tito

that gives me java error all over, even for the first group
it misses the group number in the 2 lines below addLocationsGroup
iniMap("Normal");
addLocationsGroups(1,Agences de Voyages,DefaultPointer,15);
addLocation(,40,,,"",""," \nPhone:");
showLocation(,40 );

same here plus it does not parse the sequence

iniMap("Normal");
addLocationsGroups(18,Taxis,DefaultPointer,15);
addLocation(,39,,,"",""," \nPhone:");
showLocation(,39 );

nnichols

Do you have an IM account (MSN or AIM) so we can communicate more fluidly??

tito

I sent you a private message with my msn info... could not find yours

nnichols

<?
$query = "SELECT *, Cat_ID, Category AS Region 
    FROM $link_table, $cat_table 
    WHERE $link_table.ID BETWEEN 1 AND $ID 
    AND Cat_ID = $cat_table.ID 
    AND Pending = '' 
    ORDER BY $link_table.ID ASC";

$result = mysql_query($query, $db)
    or die('MySQL error: '.mysql_error().'<br>Query: '.$query);

while ($values = mysql_fetch_array($result)) {
	$output .= 'addLocationsGroups('.$values['Cat_ID'].','.$values['Region'].','.$values['pointer'].",15);\n";
	if ($values[$link_table.ID]==$ID) {
		$output2 = 'addLocation('.$values['Cat_ID'].','.$ID.','.$values['x'].','.$values['y'].',"'.$values['Name'].'","","'.$values['Address1'].' '.$values['Address2'].'\nPhone:'.$values['Phone1'].'");'; 
		$output3 = 'showLocation('.$values[Cat_ID].','.$ID.' );'; 
		}
	}
?>
<script language=javascript> 
function InitializeMap() 
{ 
iniMap("Normal"); 
<? echo $output; ?>
<? echo $output2; ?>
<? echo $output3; ?>
} 

</script>