Weird?

[40esp]

I have this code:

<?php

mysql_select_db($database_sw, $sw);
$query_group_filter = sprintf("SELECT * FROM practice_groups WHERE group_id = %s", GetSQLValueString($colname_group_filter, "int"));
$group_filter = mysql_query($query_group_filter, $sw) or die(mysql_error());
$row_group_filter = mysql_fetch_assoc($group_filter);
$totalRows_group_filter = mysql_num_rows($group_filter); ?>
<?php do { ?>
<?php
			$practice_id_var = $_GET['practice_group_id'];
			 if ($row_group_filter['group_id'] == $practice_id_var) { echo ">"; } ?><a href="link"/>Link</a><br />

<?php } while ($row_practice_groups = mysql_fetch_assoc($practice_groups)); ?>

 

What im doing is looping through all records, and I want it to check if the group_filter = the GET variable. Im doing this so I can put a marker in my navigation so the user knows what link they are at. The problem is, Every link has a marker in front of it. The marker is the ">".

 

What am i doing wrong?

[monkeypaw201]

where is it getting the `group_id` from? i see $colname_group_filter, but not where it is defined..

[40esp]

group_id is a column in my table. Its retrieving the group_id column field value from mysql.

[40esp]

it might also help to mention im filtering the data with the same GET variable.

[monkeypaw201]

WHERE group_id = %s", GetSQLValueString($colname_group_filter, "int"));

 

right there... where is $colname_group_filter being defined?

[40esp]

$colname_group_filter = "-1";
if (isset($_GET['practice_group_id'])) {
  $colname_group_filter = $_GET['practice_group_id'];
}

 

here

[The Little Guy]

if ($row_group_filter['group_id'] == $practice_id_var) { echo ">"; } ?><a href="link"/>Link</a><br />

 

to

 

if ($row_group_filter['group_id'] == $practice_id_var) { echo ">"; } ?><a href="link"/>Link</a><br />

[40esp]

didnt work

[The Little Guy]

$query_group_filter = sprintf("SELECT * FROM practice_groups WHERE group_id = %s", mysql_real_escape_string($colname_group_filter));

[40esp]

that didnt work neither.

[The Little Guy]

are you getting bad output, or what is happening?

 

basically what are you expecting to get and what are you currently getting?

[40esp]

The if statement isn't working, its applying the ">" to everything being displayed in the loop.

[The Little Guy]

First off, I don't think you should use a do-while

Second, you need to set $colname_group_filter

 

Give this a try:

mysql_select_db($database_sw, $sw);
$colname_group_filter = 'some value';
$query_group_filter = sprintf("SELECT * FROM practice_groups WHERE group_id = %s", mysql_real_escape_string($colname_group_filter));
$group_filter = mysql_query($query_group_filter, $sw) or die(mysql_error());
$row_group_filter = mysql_fetch_assoc($group_filter);
$totalRows_group_filter = mysql_num_rows($group_filter);
while($row_practice_groups = mysql_fetch_array($practice_groups)){
$practice_id_var = $_GET['practice_group_id'];
if ($row_group_filter['group_id'] == $practice_id_var) { 
	echo ">"; 
}
echo '<a href="link"/>Link</a><br />';
}