loop logic

weazy

i have a series of columns that are like:

s1q1 | s1q2 | .... | s1q8 | s2q1 | s2q2 | .... | s2q7 | s3q1 | s3q2| .... | s3q5 |

i have a query that is dependent on the values in the column, so like:

select * from tablename where s1q1 = 4

i want to loop through all, so essentially:

select * from tablename where . $somevar . = 4

how do i loop somevar? I know how to write a loop in general, but am having a hard time figuring out what a workable loop structure would look like in this case.

thanks

YappyDog

A few questions for you:

if your columns are in the format sXqY,

how large does X get

is the top end for Y the same everytime, or is it like in your example where it goes up to 8, then 7, then 5..........

weazy

x goes to 6

y is variable, sometimes it goes to 8 sometimes 9 etc ....

i spse it would be possible to recode it so that its a single digit,

like s1, s2, and so on, though i would really prefer to leave that as a last ditch effort if at all possible.

YappyDog

Well, the looping part is pretty simple. The tricky part is that sometimes we go up to 8, sometimes to 9. I've coded this to go up to 9 all the time. You'll need to somehow figure out once you have your column name built if it is legitimate or not (for the ones that end in 9.

for ($x=1;$x<=6;$x++) {
for ($y=1;$y<=9;$y++) {
$column_name = "s" . $x . "q" . $y;
if ($y == 9) {
// do some sort of validation
}
}
}

tekky

you could do something like this...

$q = '';
$s = '';
$table = 'tablename';
$fields = mysql_list_fields($dbn, $table);
$columns = mysql_num_fields($fields);
for ($i = 0; $i < $columns; $i++)
{
	$name = mysql_field_name($fields, $i);
	$s .= "$name, ";
	$q .= "$name=4 ";
}
$query = "SELECT $s FROM $table WHERE $q";
$results = mysql_query($results);
....

If I'm not mistaken, this should return a SINGLE row where those fields are all equal to 4, if thats not what you are looking for, remove the "WHERE $q" and then loop through the ROW for $key/$val sets that equal 4 using something like

while(list($key, $val) = mysql_fetch_array($results, MYSQL_ASSOC))
{
	if ($val == 4) { do this with $key; }
}

Hopefully this isnt too messy of a solution?

fyi, the code up top is from a SQL management type page I wrote that works with any fields/tables in a database, still growing, but working so great for what it does for now 🙂