ok, this is something really wierd happening... i have a basic code that does an sql query to retrieve information from my member's table in my database. The information is put into text fields into a form. The most i can retieve is 40 lines, anything after that returns blank on the page, but shows in the View Source. if i do a mysql_num_rows() on it, it returns the correct amount of lines that are supposed to be there.
Here is my code :
<script language="JavaScript">
function addone() {
document.songform.action = "actions.php?pmode=addone";
document.songform.submit();
}
function inorder() {
document.songform.action = "step2a.php";
document.songform.submit();
}
function create() {
document.songform.action = "step2.php";
document.songform.submit();
}
</script>
<form method="POST" name="songform">
<?
$i=0;
$sql = mysql_query("SELECT * FROM images WHERE mid = '$mid'");
while($file = mysql_fetch_object($sql)){
$i++;
?>
<font color="white"><center>
<b>URL <? echo $i; ?> :<input type="text" name="fileurl[]" style="width: 410" value="<? echo $file->filename; ?>"><br>
<b>Song Name : <input type="text" name="songname[]" width="20" value="<? echo $file->songname; ?>"> <b>Band Name : <input type="text" name="bandname[]" width="20" value="<? echo $file->bandname; ?>">
<br><br>
<? } ?>
<font color="white"><center>
<b>URL <? echo $i + 1; ?> : <input type="text" name="fileurl[]" style="width: 410" value=""><br>
<b>Song Name : <input type="text" name="songname[]" width="20" value="">
<b>Band Name : <input type="text" name="bandname[]" width="20" value="">
<br><br>
<input type="button" onClick="addone()" value="Add another song">
<input type="button" onClick="inorder()" value="Put Playlist In Order">
<input type="button" onClick="create()" value="Create Playlist">
</form>
all works well up to the 40'th row. After that, it will still show the input box, but it will be blank. If i push one letter while in that text field, it will show what is supposed to be there. This happens in IE or FireFox.
if there are 42 rows, it will only show 42 input areas, and will not give me the extra one to add one more to the database.
any ideas?