quick code help

[jowatkins]

Hi there,

I have a problem with the following code:

$num_prob = mysql_num_rows($num_result);
$row = mysql_fetch_object($num_result);
while($row = $num_prob)
{
  $lastprobno = $row->probno
  //substr -- Return part of a string
  //-5 counts five chars back from the end and gives us the number part of the variable
  $number = substr ("$lastprobno", -5);  

  $number++;
} // while

I think the problem exists on the while command. I basically want this to go straight to the last record. Any ideas.

[the_Igel]

Try to understand what your code should do. Nice excercise 🙂

Every computer program does what we code it to do; but it doesn't always do what we suppose is to do.

Did you mean smth like

$num_prob = mysql_num_rows($num_result);
for ($i = 0; $i < $num_prob; $i++)
{
$row = mysql_fetch_object($num_result);
}

? Anyway, if you really need the last record only, you evidently should rewrite your query in the way it return only the needed record.

[jowatkins]

Thanks, I finally got it working in this way:

$num_prob = mysql_num_rows($no_result);
$row = mysql_fetch_object($no_result);

$index=$num_prob; 

//seeks to requested row in db.  All counts start form 0, not 1, so need to minus 1 for accurate count
if (!mysql_data_seek ($no_result, ($index - 1) )) 
{
  echo "Cannot seek to row $i\n";
  continue;
}

$lastprobno = $row->probno;
//substr -- Return part of a string
//-5 counts five chars back from the end and gives us the number part of the variable
$number = substr ("$lastprobno", -5);  

$number++;
$prob = "$chassis-PROB-$number";

But if theres a way of retrieving the last record in the query, this could make my code much shorter and easier to read. How would I do that. I looked but couldn't find it.