Why is my array only returning the last value in a loop?

Question

I have the following code which is meant to cycle through names submitted on a form:

$row_count = count($_POST['name']);
if ($row_count > 0) {

  mysql_select_db($database, $connection);
  $name = array();
  $workshop = array();

  for($i = 0; $i < $row_count; $i++) {
    // variable sanitation...
    $name[i] = mysql_real_escape_string(ucwords($_POST['name'][$i]));
    $workshop[i] = mysql_real_escape_string($_POST['workshop'][$i]);
    }
  $names = "('".implode("','",$name)."')";
.....etc

For some reason $names is only returning the last name submitted on the form, rather than all of the names. Could someone help me get this working correctly?

Thanks,

Nick

Peter · Accepted Answer · 2011-10-25 17:06:58Z

6

problem is here

$name[i] = 
$workshop[i] =

solution:

$name[$i] = 
$workshop[$i] =

now your code is working in this way:

$name["i"] = 
$workshop["i"] =

so you have only one element in $name, $workshop arrays. (last from loop)

answered Oct 25, 2011 at 17:06

Peter

17k9 gold badges55 silver badges77 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Why is my array only returning the last value in a loop?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related