fout in Paging script om rows te editen

[Verwijderd]

Ik ben bezig met een script dat het mogelijk maakt om velden van rows , row voor row te kunnen editen. Als er op modify gedrukt wordt , worden de updated velden opgeslagen en wordt er naar de volgende row gegaan. er treed echter een error op bij de 2e row. Ziet iemand een fout? Heeft u suggesties? Dank u bij voorbaat!

<?php
if($filename){ //If row is in buffer
require("sqlconnect.php");
mysql_query("UPDATE data set filename= '$filename', description = '$description', gorevalue= '$gorevalue'where filename ='$filename'");
$row = mysql_fetch_object($result);
}
else{
require("sqlconnect.php");
$result = mysql_query("Select * from data Order by filename limit $begin,$eind");
$row = mysql_fetch_object($result);
}
if(!isset($begin)){ //If $begin isn't initialised yet, give it the value 1
$begin=1;
$eind=2;
}
else{
$begin=$begin+1;
$eind=$eind+1;
}
if ($row->gorevalue==0) $array=array('Selected','','','','','');
elseif ($row->gorevalue==1) $array=(array('','Selected','','','','');
elseif ($row->gorevalue==2) $array=(array('','','Selected','','','');
elseif ($row->gorevalue==3) $array=(array('','','','Selected','','');
elseif ($row->gorevalue==4) $array=(array('','','','','Selected','');
elseif ($row->gorevalue==5) $array=(array('','','','','','Selected');
echo <form method="post" action="modify.php?begin=$begin&eind=$eind> ?>
Filename : <input type="text" name="filename" value="<?php echo $row->filename;?>"><br>
Description : <input type="text" name="description" value="<?php echo $row->description;?>"><br>
Value : <Select name="gorevalue">
<option value="0" <?php echo $array[0];?>>NONE</OPTION>
<option value="1" <?php echo $array[1];?>>*</OPTION>
<option value="2" <?php echo $array[2];?>>**</OPTION>
<option value="3" <?php echo $array[3];?>>***</OPTION>
<option value="4" <?php echo $array[4];?>>****</OPTION>
<option value="5" <?php echo $array[5];?>>*****</OPTION>
</select><br><br>
<input type="submit" value="Modify">
</form>

[kvdveer]

zonder [.php][/php] tags begin ik hier niet aan.

PHP:

<?if($filename){ //If row is in buffer   require("sqlconnect.php");   mysql_query("UPDATE data set filename= '$filename', description = '$description', gorevalue= '$gorevalue'where filename ='$filename'");   $row = mysql_fetch_object($result);}else{   require("sqlconnect.php");   $result = mysql_query("Select * from data Order by filename limit $begin,$eind");   $row = mysql_fetch_object($result);}if(!isset($begin)){ //If $begin isn't initialised yet, give it the value 1   $begin=1;   $eind=2;}else{   $begin=$begin+1;   $eind=$eind+1;}if ($row->gorevalue==0) $array=array('Selected','','','','','');elseif ($row->gorevalue==1) $array=(array('','Selected','','','','');elseif ($row->gorevalue==2) $array=(array('','','Selected','','','');elseif ($row->gorevalue==3) $array=(array('','','','Selected','','');elseif ($row->gorevalue==4) $array=(array('','','','','Selected','');elseif ($row->gorevalue==5) $array=(array('','','','','','Selected');echo <form method="post" action="modify.php?begin=$begin&amp;eind=$eind> ?>Filename : <input type="text" name="filename" value="<?php echo $row- >filename;?>"><br>Description : <input type="text" name="description" value="<?php echo $row- >description;?>"><br>Value : <Select name="gorevalue"><option value="0" <?php echo $array[0];?>>NONE</OPTION><option value="1" <?php echo $array[1];?>>*</OPTION><option value="2" <?php echo $array[2];?>>**</OPTION><option value="3" <?php echo $array[3];?>>***</OPTION><option value="4" <?php echo $array[4];?>>****</OPTION><option value="5" <?php echo $array[5];?>>*****</OPTION></select><br><br><input type="submit" value="Modify"></form>?>

[kvdveer]

Ik heb even je toch wat ranzige code vertaald naar iets maatschappelijk aanvaardbaarders...

PHP:

<?require("sqlconnect.php");if($filename){ //If row is in buffer   mysql_query("      UPDATE data       SET filename= '$filename',          description = '$description',          gorevalue= '$gorevalue'      WHERE filename ='$filename'");   $row = mysql_fetch_object($result); // <- ?????????}else{   $result = mysql_query("      Select * from data Order by filename limit $begin,$eind");   $row = mysql_fetch_object($result);}if(!isset($begin)){ //If $begin isn't initialised yet, give it the value 1   $begin=1;   $eind=2;}else{   $begin=$begin+1;   $eind=$eind+1;}echo "<form method=\"post\" action="modify.php?begin=$begin&amp;eind=$eind>";echo "Filename : <input type="text" name="filename" value="$row- >filename;"><br>";echo "Description : <input type="text" name="description" value="$row- >description;"><br>";echo "Value : <Select name="gorevalue">";echo "<option value="0\" ".($row->gorevalue==0?"SELECTED":"").">NONE</OPTION>";for($i = 1; $i<=5 ; $i++)   echo "<option value=\"$i\" ".($row->gorevalue==$i?"SELECTED":"").">".$i."</OPTION>";echo "</select><br><br>";echo "<input type=\"submit\" value=\"Modify\">";echo "</form>";?>

Leg eens uit wat je doet bij die eerste if? Je vraagt de $row op uit de variabele $result? waar vul je die variabele?

[kvdveer]

fijn trouwens dat je de foutmelding vertelt.
Je foutmelding zal zijn : ## is not a valid mysql-resource on line ##

Wijs trouwens dat je die niet noemt, want als je 'm had genoemd had ik gezegd: 'kijk eens op regel ##, daar zit de fout, de variabele ## bevat geen mysql resource'.

[Verwijderd]

LIMIT werkt niet met start en eind maar met start en aantal...

[dusty]

[topic=397053/1/50]