[SOLVED] Creating tables

[phatgreenbuds]

Any idea why this would not work? I expected it to create a table and then populate that table with 24 rows...all I get is the 24th row.

 

<?php
$sql = "CREATE TABLE $tblname
(
content_id INT( NOT NULL AUTO_INCREMENT, 
content_win_path VARCHAR(50) NOT NULL,
tbl_hour INT(3) NOT NULL,
tbl_slot INT(3) NOT NULL,
PRIMARY KEY (content_id)
)";

mysql_query($sql,$dbconn);

$count = 1;
while ($count <= 24) {
	$query="INSERT INTO $tblname (tbl_hour) VALUES ('$count')";
	$count++;
	}
	$addcon = mysql_query($query);
	confirm_query($addcon);
?>

[AndyB]

The query is executed outside the loop, so it only happens once

[teynon]

You need to run your query every time the loop is executed. You should however, look into doing it like this:

$query="INSERT INTO $tblname (tbl_hour) VALUES ";

while ($count <= 24)

  {

  $query.="('$count'),";

  count++;

  }

$query=substr($query, 0, -1);

$addcon = mysql_query($query);

confirm_query($addcom);

 

----

By the way, what does confirm_query do?

[phatgreenbuds]

Got it figured out...shortly after I posted this I noticed the problem...

 

The "confirm_query()" is just a function that checks if the query was ok...I am trying to be good and clean up the script using more functions.