Simple UPDATE while confusion

[ben_johnson1991]

Hey guys,

ive simply have a table printed with all the page details on.

the fields are shown on the 2nd part of the php script bellow.

 

The print works fine, all $i increase each row....

 

the problem is when its posted,

for some reason the posts aren't coming through correctly or nothing..

the count only counts 1,

and update doesnt do anything, but it apparently runs correctly as it print UPDATED..

 

I'm pretty sure its a minor mess up, but i'm using trial and error and getting no where.

 

any guidance would be much appreciated!!

Cheers,

Ben.

 

include_once "connect_to_mysql.php";

//////////SPupdate

if(isset($_POST['updateSP'])){

$size = count($_POST['id']);

print 'Count: '.$size.'';

$i = 0;

 

while ($i < $size) {

 

// define each variable

$pmainp_id= $_POST['pmainp_id'][$i];

$porder_no = $_POST['porder_no'][$i];

$pname = $_POST['pname'][$i];

$plink = $_POST['plink'][$i];

$ppage = $_POST['ppage'][$i];

$id = $_POST['id'][$i];

 

 

$query = mysql_query("UPDATE pages SET mainp_id = '$pmainp_id', order_no='$porder_no', name = '$pname', link='$plink', page = '$ppage' WHERE subp_id = '$id' LIMIT 1");

print"".$pname." UPDATE<br/>";

++$i;

 

}

if($query){

print "UPDATED";

}

else{

print "UPDATE FAIL";

}

}

 

////////////////////////////////////////////////////////////////////////////

/////////  SUB PAGES

////////////////////////////////////////////////////////////////////////////

$subopageget = mysql_query("SELECT * FROM pages ORDER BY mainp_id, order_no ASC");

$i = 1;

while ($srow = mysql_fetch_array($subopageget)){

$subp_id = $srow['subp_id'];

$mainp_id = $srow['mainp_id'];

$link = $srow['link'];

$name = $srow['name'];

$order_no = $srow['order_no'];

$page = $srow['page'];

$subpagerow .= '

<input type="hidden" name="id[$i]" id="id[$i]" value"'.$subp_id.'" />

<tr>

    <td><input name="pmainp_id[$i]" type="text" value="'.$i.' - '.$mainp_id.'"/></td>

    <td><input name="porder_no[$i]" type="text" value="'.$order_no.'"/></td>

    <td><input name="pname[$i]" type="text" value="'.$name.'"/></td>

    <td><input name="plink[$i]" type="text" value="'.$link.'"/></td>

    <td><input name="ppage[$i]" type="text" value="'.$page.'"/></td>

  </tr>

';

++$i;

}

 

[mcjwb]

Is it down to the outputted html in the variable "$subpagerow"?

 

The $i doesn't look like it'll get parsed in some places, e.g. id="id[$i]" should be id="id['.$i.']"

 

Does that help?

[ben_johnson1991]

Cheers for the reply.

I've changed the $i as suggested

 

$subpagerow .= '

<input type="hidden" name="id['.$i.']" id="id['.$i.']" value"'.$subp_id.'" />

<tr>

    <td><input name="pmainp_id['.$i.']" type="text" value="'.$mainp_id.'"/></td>

    <td><input name="porder_no['.$i.']" type="text" value="'.$order_no.'"/></td>

    <td><input name="pname['.$i.']" type="text" value="'.$name.'"/></td>

    <td><input name="plink['.$i.']" type="text" value="'.$link.'"/></td>

    <td><input name="ppage['.$i.']" type="text" value="'.$page.'"/></td>

  </tr>

';

 

 

which now produces the correct $size variable, but still the update isnt actually updating.

 

[PFMaBiSmAd]

There is no equal sign = in the value = "..." attribute -

<input type="hidden" name="id['.$i.']" id="id['.$i.']" value"'.$subp_id.'" />

[ben_johnson1991]

Fuck me man lol, how long i've wasted for just that!

Cheers for that dude!