[SOLVED] extra span added while loop runs

[dennismonsewicz]

I have the following loop:

 

mysql_connect('localhost', '*****', ''*****');
	mysql_select_db(''*****');

	$q = mysql_query("SHOW TABLES FROM tblName");

	while($row = mysql_fetch_array($q)) {
		$col = $row;
		$count = count($col);
		for($i = 0; $i < $count; $i++) {
			echo '<span>' . $col[$i] . '</span>';
		}
	}

 

When you run the code it adds an extra span tag in there... I can't figure out why!

[SilveR316]

What's value inside the span in your output?

[dennismonsewicz]

a table name from my database

[SilveR316]

I meant in the extra span.

 

Are any of the names being duplicated?

[dennismonsewicz]

oh gotcha... no its just a blank span for some reason

[dennismonsewicz]

figured it out

 

fixed code:

 

mysql_connect('localhost', '*******', '*******');
	mysql_select_db('*******');

	$q = mysql_query("SHOW TABLES FROM *******");

	while($row = mysql_fetch_array($q)) {
		$col = $row;
		$count = count($col) - 1;
		for($i = 0; $i < $count; $i++) {
			echo '<span>' . $col[$i] . '</span>';
		}
	}

[SilveR316]

I see it now.

 

You could also have started your $i at 1 instead of 0.