mysql insert problem

[dabith]

hey all

i am having trouble inserting data into a table. can anyone please let me know what i am doing wrong.

thanks in a advance.
//function to generate six random numbers
function generator() {
$randgen = array();
global $minNumber;
global $maxNumber;
global $number;

while (count($randgen)<$number) {
    @$num = rand($minNumber, $maxNumber);
    if (!in_array($num, $randgen)) {
        $randgen[]=$num;		
    }
}

return $randgen;
}

//save the random numbers to the mysql file
$connection = mysql_pconnect("localhost", "","")
or die("Couldn't make connection");

$db = mysql_select_db("Random",$connection)
or die("Couldn't select database");

for($i=1; $i<=$draws; $i++){
$randgen = generator();
foreach($randgen As $index => $value){
echo "value: ".$value."\n";
$query = "INSERT INTO draws VALUES('".$value."')";
$result = mysql_query($query);
if($result)
echo mysql_affected_rows()." draw inserted into database.";
}
echo"<br>";
}

Table draws format is:

field 1 -> drawid
field 2 -> one
field 3 -> two
etc
field 7 -> six

[[deleted]]

If you want to insert all 6 numbers into one row, you will need to build a query as such. As you are doing it now, the query is invalid...try something like this:

$query = "INSERT INTO draws VALUES(''"; 
for($i=1; $i<=$draws; $i++){
  $randgen = generator();
  foreach($randgen As $index => $value){
    echo "value: ".$value."\n";
    $query .= ",$value";
  }
  echo"<br>";
}
$query .= ")";
$result = mysql_query($query);

The above hasn't been tested, but should give you an idea anyway...