[RESOLVED] Show contents of db in form fields

iNFERiON

I am trying to fetch contents of my MySQL database and put them into form fields.
The database has the following fields and values:

id0: 1a
code0: 1001
name0: Test
type0: Test

The idea is to have more and more data being put into the database, the 2nd row of form fields is going to be id1,code1 and so on.

I currently have this code:

<?php
// Fetch tags from database
$gettags = mysql_query('SELECT * FROM `tags_' . $_GET['pid'] . '`',$db);

// Save results as vars
$row = 0;
$num = 0;
while(mysql_num_rows($gettags) <= $row) {
$code[$row] = mysql_result($gettags,$num);
if(isset($_GET['debug'])) {
	echo "\$code[\$row]: " . $code[$row] . "\n";
}
$num++;
$id[$row] = mysql_result($gettags,$num);
if(isset($_GET['debug'])) {
	echo "\$id[\$row]: " . $id[$row] . "\n";
}
$num++;
$name[$row] = mysql_result($gettags,$num);
if(isset($_GET['debug'])) {
	echo "\$name[\$row]: " . $name[$row] . "\n";
}
$num++;
$type[$row] = mysql_result($gettags,$num);
if(isset($_GET['debug'])) {
	echo "\$type[\$row]: " . $type[$row] . "\n";
}
$num++;
echo "&nbsp;&nbsp;<tr>\n";
echo "\t<td><div align=\"center\"><input name=\"id" . $row . "\" type=\"text\" size=\"4\" maxlength=\"3\" value=\"" . $id[$row] . "\"></div></td>\n";
echo "\t<td><div align=\"center\"><input name=\"code" . $row . "\" type=\"text\" size=\"5\" maxlength=\"4\" value=\"" . $code[$row] . "\"></div></td>\n";
echo "\t<td><div align=\"center\"><select name=\"type" . $row . "\"><option>" . $type[$row] . "</option></select></div></td>\n";
echo "\t<td><div align=\"center\"><input name=\"name" . $row . "\" type=\"text\" value=\"" . $name[$row] . "\"></div></td>\n";
echo "\t<td><div align=\"center\"><input name=\"add" . $row . "\" type=\"submit\" value=\"+\">&nbsp;<input name=\"del" . $row . "\" type=\"submit\" value=\"-\"></div></td>\n";
echo "&nbsp;&nbsp;</tr>\n";
$row++;
}
?>

But the whole while() doesn't seem to get executed at all, because the output under "if(isset($_GET['debug']))" is not at all shown when I add &debug to the querystring. What am I doing wrong here ?

itaym02

well
while(mysql_num_rows($gettags) <= $row) {

$row is 0 at the beggining (as you defined)
and mysql_num_rows($gettags) is probably 1 or more, so the condition in the while never happens.

iNFERiON

Found out what I was doing wrong, I was working too much with rows, while the fields were the important parts. I now have this:

// Fetch tags from database
$gettags = mysql_query('SELECT * FROM `tags_' . $_GET['pid'] . '`',$db);

// Save results as vars
$num = 0;
while($row = mysql_fetch_assoc($gettags)) {
echo "&nbsp;&nbsp;<tr>\n";
echo "\t<td><div align=\"center\"><input name=\"id" . $row . "\" type=\"text\" size=\"4\" maxlength=\"3\" value=\"" . $row['id'.$num.''] . "\"></div></td>\n";
echo "\t<td><div align=\"center\"><input name=\"code" . $row . "\" type=\"text\" size=\"5\" maxlength=\"4\" value=\"" . $row['code'.$num.''] . "\"></div></td>\n";
echo "\t<td><div align=\"center\"><select name=\"type" . $row . "\"><option>" . $row['type'.$num.''] . "</option></select></div></td>\n";
echo "\t<td><div align=\"center\"><input name=\"name" . $row . "\" type=\"text\" value=\"" . $row['name'.$num.''] . "\"></div></td>\n";
echo "\t<td><div align=\"center\"><input name=\"add" . $row . "\" type=\"submit\" value=\"+\">&nbsp;<input name=\"del" . $row . "\" type=\"submit\" value=\"-\"></div></td>\n";
echo "&nbsp;&nbsp;</tr>\n";
$num++;
}

This works perfectly for the first row, but my 2nd test row does not show. Any ideas on why that is ?

iNFERiON

All solved now. Turns out my database structure was kind of confusing. Created an auto_increment field "row" to it and now it works with this:

// Fetch tags from database
$gettags = mysql_query('SELECT id, code, type, name FROM `' . $_GET['pid'] . '`',$db);

// Save results as vars
while($row = mysql_fetch_assoc($gettags)) {
	echo "&nbsp;&nbsp;<tr>\n";
	echo "\t<td><div align=\"center\"><input name=\"id" . $row . "\" type=\"text\" size=\"4\" maxlength=\"3\" value=\"" . $row['id'] . "\"></div></td>\n";
	echo "\t<td><div align=\"center\"><input name=\"code" . $row . "\" type=\"text\" size=\"5\" maxlength=\"4\" value=\"" . $row['code'] . "\"></div></td>\n";
	echo "\t<td><div align=\"center\"><select name=\"type" . $row . "\"><option>" . $row['type'] . "</option></select></div></td>\n";
	echo "\t<td><div align=\"center\"><input name=\"name" . $row . "\" type=\"text\" value=\"" . $row['name'] . "\"></div></td>\n";
	echo "\t<td><div align=\"center\"><input name=\"edit" . $row . "\" type=\"submit\" value=\"Edit\">&nbsp;<input name=\"del" . $row . "\" type=\"submit\" value=\"Delete\"></div></td>\n";
	echo "&nbsp;&nbsp;</tr>\n";
}