WEIRD! Please read

[Anon]

I have got

results1 = mysql_query("....")
results2 = mysql_query("....")
results3 = mysql_query("....")
results4 = mysql_query("....")
results5 = mysql_query("....")

Now, I have a function that checks if the results has no rows:

for ($n=1;$n<6;$n++) {

$results = $result.$n;
$rownumbers = mysql_numrows($results);

if ((!$rownumbers || $rownumbers<1) && ($n>0))
{
echo"Sorry, No Records Yet\n";
}

}

This seems very logical to me, and I tested, tested and testeed and each simple echo test shows that the results1,2,3..5 list properly..

but when I use the line: $rownumbers = mysql_numrows(), I get a warning that '1' is not a result...

AND, the first results returns nothing.. 2nd resutl returns the FRIST result...etc.

---

so to fix this, I used this function instead:

for ($n=2;$n<15;$n++) {

$results = $result.$n;
$rownumbers = mysql_numrows($results);

$m=$n-1;

if ((!$rownumbers || $rownumbers<1) && ($m>0))
{
echo"group[$m][0]=new Option('Sorry, No Records Yet')\n";
}

}

It works great now, but WHY DOESnt the first one work?

this is REALLY weird to me 🙁

[[deleted]]

$results1 = mysql_query("....")
$results2 = mysql_query("....")
$results3 = mysql_query("....")
$results4 = mysql_query("....")
$results5 = mysql_query("....")

// Now, I have a function that checks if the results has no rows:

for ($n=1;$n<6;$n++)
{

// I guess you mean to put $result1 - $result5 into $results
// $results = $result.$n;
// This just concatenates the value of $n to the value of $result
//
// Instead, use variable variables:
$results = ${'results'.$n};
// Now, $results will contain teh value of the variable that has the name 'results'.$n (results1, results2, etc)
//
$rownumbers = mysql_numrows($results);
// if ((!$rownumbers || $rownumbers<1) && ($n>0))
// Why do you use the ($n>0)? you are in a loop where $n runs from 1 to 5, so it $n is allways more than zero
//
//
if ($rownumbers == 0)
{
echo"Sorry, No Records Yet\n";
}
}

[Anon]

Hi Vincent!

THank you so much!

Variable variable..mmm.. sweet.

If I knew it a few days ago I woulnt have wasted so many hours trying to figure it out..

I still can't tell the difference between the 2.. could you give an occation when you will use $result.$n?

And to answer your question, since the values were being pushed down by 1, I added the $m=$n+1 to compensate it, hence I had to check if it's >0 since n starts 1.. I guess I forgot to delete that part for the first for loop (I copy and pasted the 2nd working for loop)..

Thnaks again!

[[deleted]]

The difference is:

$n=1;
$results='hello';
echo $results.$n

output: "hello1"

$n=1;
$results='hello';
$hello1='goodmorning';
echo ${'results'.$n};

output:"goodmorning";

[kparker]

Just about anytime you have a sequence of variable names like this, you should be using an array instead. In other words, the numeric suffixes on the names should really be array indices.

In addition, you need to be checking the values for success.

[Anon]

right, I wanted to use array for that 🙂, but had no idea how 🙁