Query Question?

[GLawas]

Hello Reader,

I'm trying to make an update query that joins 2 fields using PHP, MySql. I can not get it to work for the life of me.

Here is what I came up with.

<?php
require("./connect.inc.php");
connect_db();
$sql = "SELECT * FROM updateproject.updater ORDER BY id";
$query = mysql_query($sql);
$rows = mysql_num_rows($query);

$i=0;

while ($i < $rows) {

$id = mysql_result($query, $i, "ID"); 
$prtnum = mysql_result($query, $i, "prtnum");
$nomen = mysql_result($query, $i, "nomen");
$fid = mysql_result($query, $id-2, "ID");
$fnomen = mysql_result($query, $id-2, "nomen");
$fprtnum = mysql_result($query, $id-2, "prtnum");
if (!$prtnum <> NULL) {

$fix = "UPDATE updater SET updater.nomen = '$fnomen $nomen'
WHERE (((updater.ID)='$fid'))";

mysql_query($fix);

echo "<p>Process Complete</p>";
}
$i++;
}


?>

And here is what the computer came up with:

Process ComplePHP Warning: mysql_result() [function.mysql-result]: Unable to jump to row 12688 on MySQL result index 3 in c:\Inetpub\wwwroot\UpdaterProject\Merdge.php on line 16 PHP Warning: mysql_result() [function.mysql-result]: Unable to jump to row 12688 on MySQL result index 3 in c:\Inetpub\wwwroot\UpdaterProject\Merdge.php on line 17 PHP Warning: mysql_result() [function.mysql-result]: Unable to jump to row 12689 on MySQL result index 3 in c:\Inetpub\wwwroot\UpdaterProject\Merdge.php on line 16 PHP Warning: mysql_result() [function.mysql-result]: Unable to jump to row 12689 on MySQL result index 3 in c:\Inetpub\wwwroot\UpdaterProject\Merdge.php on line 17 PHP Warning: mysql_result() [function.mysql-result]: Unable to jump to row 12690 on MySQL result index 3 in c:\Inetpub\wwwroot\UpdaterProject\Merdge.php on line 16 PHP Warning: mysql_result() [function.mysql-result]: Unable to jump to row 12690 on MySQL result index 3 in 

Any Ideas where I went wrong? It seemed simple enough, but it just won't come together.

Gilbert 😕

[subwayman]

Your problem has to be:

$fid = mysql_result($query, $id-2, "ID");
$fnomen = mysql_result($query, $id-2, "nomen");
$fprtnum = mysql_result($query, $id-2, "prtnum");

These three lines access a row in the result set with a rowindex of $id-2. $id is obtained from the line:

$id = mysql_result($query, $i, "ID");

Therefore, if you have a record with an ID of 12690 the lines a bove will try and access row 12688 of your recordset. Does this exist? Mysql seems to think not.

[GLawas]

I figured as much. But I don't know how to get around it. The information I'm trying to put together is a discription field that was broken off in another program.

Basically what I'm trying to get at is:

ID #1 is A, so Nomen for that ID is AN
ID #2 is B, so Nomen for that ID is AB

AB + AN = What I'm trying to get at.

Got any Ideas? (I'm fresh out.)