Condensation help!

[influx]

Hi there all,

at the top of all my PHP pages, I have to initialize all my variables. This is what it looks like:

<?php
$ress=mysql_query("Select * from help1 where c1_username='".$_SESSION['username']."'");
$row=mysql_fetch_array($ress);
$c1_helpname=$row["c1_helpname"];

$ress=mysql_query("Select * from help2 where c2_username='".$_SESSION['username']."'");
$row=mysql_fetch_array($ress);
$c2_helpname=$row["c2_helpname"];

$ress=mysql_query("Select * from help3 where c3_username='".$_SESSION['username']."'");
$row=mysql_fetch_array($ress);
$c3_helpname=$row["c3_helpname"];

$ress=mysql_query("Select * from help4 where c4_username='".$_SESSION['username']."'");
$row=mysql_fetch_array($ress);
$c4_helpname=$row["c4_helpname"];
?>

I have tried many times to condense this into one for loop, from 1-4
[for(x==1;x<=4;x++)].

Can anybody perhaps help me figure out a way to do this?

Thanks in advance!
-influx

[onion2k]

for ($i=1;$i<=4;$i++) {
   $ress=mysql_query("Select * from help".$i." where c".$i."_username='".$_SESSION['username']."'");
   $row=mysql_fetch_array($ress);
   ${"c".$i."_helpname"}=$row["c".$i."_helpname"]; 
}

[influx]

Thanks a lot onion2k,

However, when I use that I get the following warning:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/schoolrack.com/new/members/stats/stats.php on line 35

for($i==1;$i<=4;$i++)
{
$ress=mysql_query("Select * from help".$i." where c".$i."_username='".$_SESSION['username']."'");
$row=mysql_fetch_array($ress);
${"c".$i."_helpname"}=$row["c".$i."_helpname"];
}

What could possibly be causing this?

[influx]

When I asked for a more detailed error, it gave me the following:

" 1146 Table 'mysql.help' doesn't exist"

That's odd, because it fetches all the information without a problem.

[bubblenut]

Try this to give yourself a bit more debugging output

for($i==1;$i<=4;$i++)
{
$sql="Select * from help".$i." where c".$i."_username='".$_SESSION['username']."'";
$ress=mysql_query($sql) or die($sql."<br />\n".mysql_error());
$row=mysql_fetch_array($ress);
${"c".$i."_helpname"}=$row["c".$i."_helpname"];
}