Okay here is the full code. Now I got this code off a friend! In this first
section to display the data that is grabbed from the db.
----
<?php
$db = mysql_connect("localhost", "user", "pass");
mysql_select_db("db_select",$db);
$result = mysql_query("SELECT `nickname` FROM tipping
WHERE 1
ORDER BY `score`
DESC LIMIT 0, 30",$db);
while ($myrow = mysql_fetch_row($result)) {
printf("
<br><input type=text name=username[$a] value=%s> <br>",
$myrow[0]);
}
?>
<input type="submit" value="submit">
</form>
</p>
----
It displays the data fine. Please note in the above there is more code and I
doubt the issue is in there as the data fetching shows fine, I believe the
error lies somewhere below.
Than the form submit is pushed to another page with this code:
---
<?
include('../conf.inc.php');
if ($REQUEST_METHOD == "POST") {
$usr = "user";
$pwd = "pass";
$db = "db_select";
$host = "localhost";
$cid = mysql_connect($host,$usr,$pwd);
mysql_select_db($db);
// NOTE that form fields automatically become variables
$query = "insert into round3 SET username='$username[$a]'";
mysql_query("$query");
echo(" ");
}
else {echo("Ooops, something bad happened! Please try again shortly.");}
?>
<a href="admin.php">BACK</a>
---
But when I check the db only ONE entry is added and it's blank. But on the
the page that displays the data shows 12 records. So it's not updating for
some reason? Any help?
J
