Multiple Variables

Nixon

Hi, I have the following script:


<?php

include("connect_db.php");

$query  = "create table $table_name (";

$whileint=1;
$row_num=0;
$setnum=1;

while ($number_cols<$whileint) {

if ($auto==on and $setnum==0) { $query .= "$field0 $menu0 auto_increment,"; $query .= "primary key($field0),";}
else 

{ $query .= "$field$row_num $menu$row_num,"; }

$whileint++;
$row_num++;
$setnum++;

}

$query .= "$field$number_cols $menu$numbercols)";

echo ($query);


?>

The echo just returns 'create table 'tablename' (6)'

the six comes from the $number_cols variable. Any ideas where im going wrong?

rich_d

Hi,

I'm assuming the script isn't complete - for a number of reasons:

1) It will never actually execute because your while loop is checking if the variable $number_cols is less than $whileint - yet $number_cols is never defined anywhere to have a value, so this condition will never be met

2) In your while loop you're incrementing the whileint variable every loop, so again it'll never end because the goal post is being constantly moved.

Would love to help, but more info please 🙂

Cheers,

Rich

Nixon

Hi, have now updated code, the information is coming from a form on the previous page, thats where numbercols and stuff is coming from.

Here is the updated code:


<?php

include("connect_db.php");

$query = "create table $table_name (";

$whileint=1;
$row_num=0;
$setnum=0;

while ($whileint<$number_cols) {

$fieldrow = $menu

if ($auto==on and $setnum==0) { $query .= "$field0 $menu0 auto_increment, "; $query .= "primary key($field0),";}
else 

{ $query .= "$fieldrow $menurow, "; } // This is the part where I am having trouble. I need to make a variable that reads $menu1, and increases everytime the loop gos round.

$whileint++;
$row_num++;
$setnum++;

}

$lastbox = $number_cols-1;

$query .= "$field$lastbox $menu$lastbox)"; 

echo ($query);

?>

Any ideas now?

Nixon

Here is the code on the page before:

<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="stylesheet" rel="stylesheet" type="text/css">
</head>

<body>
<div align="center">
<table width="730" border="0">
<tr>
<td><div align="center"><img src="title.gif" width="716" height="51"></div></td>
</tr>
</table>
<br>
<table width="700" border="0">
<tr>
<td width="175"><div align="center"><a href="index.php">Home</a></div></td>
<td width="175"><div align="center"><a href="tables.php">Tables</a></div></td>
<td width="175"><div align="center"><a href="stock.php">Stock</a></div></td>
<td width="175"><div align="center"><a href="help.php">Help</a></div></td>
</tr>
</table>
<hr width="700">
<table width="700" border="0">
<tr>
<td><table width="300" border="0">
<tr>
<td>Table Name: <?php echo($table_name); ?></td>
</tr>
</table>

<br> <table width="375" border="0">
<tr>
<td width="125" bgcolor="#FFF2F9"><div align="center">Field</div>
</td>
<td width="125" bgcolor="#F4EAFF"><div align="center">Type</div>
</td>
<td width="125" bgcolor="#FFF2F9"><div align="center">Auto Increment</div>
</td>
</tr>
</table> <p>


<?php	  

$row_num=0;

while ($row_num<$number_cols) {

print	"<form action=\"make_table.php\" method=\"post\" name=\"info_insert\">";
print	"<table width=375>";
print	"<tr>";
print	"<td width=125 align=center bgcolor=#FFF2F9><input type=text size=13 name=field$row_num></td>";
print	"<td width=125 align=center bgcolor=#F4EAFF><select name=menu$row_num><option value=\"text\">Text</option><option value=\"int\">Integer</option></select></td>";

if ($row_num==0) 	{print	"<td width=125 align=center bgcolor=#FFF2F9><input type=checkbox name=auto></td>";}				

print	"</tr>";
print	"</table>";

$row_num++;

}


?>

<?php print "<input type=\"hidden\" name=\"number_cols\" value=\"$number_cols\">"; print "<input type=\"hidden\" name=\"table_name\" value=\"$table_name\">"; ?>