Simple mySQL not working

[BRUm]

$webpage = "http://www.google.com";

$links = spiderAll($webpage, 5);
$links_num = count($links);
if ($links_num > 0) {
	echo "<dl>\n";
	for ($i = 0; $i < $links_num; ++$i) {
		echo "<dt>" . $links[$i][0] . "</dt>\n"
			. "<dd>" . $links[$i][1] . "</dd>\n";
	}
	echo "</dl>\n";

$firstlast = $links[$i++][0];
$middle = $links[$i++][1];

$query = "INSERT INTO nero VALUES ('$firstlast','$middle','$firstlast')";
mysql_query($query);

The 'INSERT' query just inserts black fields in my database. Anyone know why? :glare:

[rincewind456]

Try echoing out the variables before inserting to the db they're probably empty.

[harmor]

Shouldn't this
for ($i = 0; $i < $links_num; ++$i)

Be
for ($i = 0; $i < $links_num; $i++)

(the two plus signs moved)

[rincewind456]

harmor wrote:

Shouldn't this
for ($i = 0; $i < $links_num; ++$i)

Be
for ($i = 0; $i < $links_num; $i++)

(the two plus signs moved)

Makes no difference they both work the same.