PHP Overload

programming
21 

<?
$l = mysql_connect("localhost", "voetsjoeba","--hidden--");
mysql_select_db("voetsjoeba");

$q = "SELECT * FROM news";
$r = mysql_query($q, $l);

$nrows = mysql_num_rows($r);

print $nrows;

mysql_close($l);

?>
22

Well, I’ve waited for it to finish now, and it sais this:

Fatal error: Maximum execution time of 30 seconds exceeded in /home/voetsjoeba/HTML/test/news.php on line 8

:-\

23

try that and tell me what number it prints out.

24

*Originally posted by Jubba *
**


<?
$l = mysql_connect("localhost", "voetsjoeba","--hidden--");
mysql_select_db("voetsjoeba");

$q = "SELECT * FROM news";
$r = mysql_query($q, $l);

$nrows = mysql_num_rows($r);

print $nrows;

mysql_close($l);

?>

**

K, lemme try that :slight_smile:

25
26

is there only one row in your news table?

27

Yeah, for now only one, I’m going to add some later.

28 



<?
$l = mysql_connect("localhost", "voetsjoeba","--hidden--");
mysql_select_db("voetsjoeba");

$q = "SELECT * FROM news";
$r = mysql_query($q, $l);

if($r){
     $nrows = mysql_num_rows($r);

     $output="";

     for ($i=0; i < $nrows; $i++){
         $row = mysql_fetch_array($qr);

         $output .= "&i=".$i;
         $output .= "&img".$i."=".$row['img'];
         $output .= "&datum".$i."=".$row['datum'];
         $output .= "&inhoud".$i."=".$row['inhoud'];
     }
     print $output;
}
else
{
     print mysql_error($l);
}



mysql_close($l);
?>

see what that gives you.

29

a million times Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/voetsjoeba/HTML/test/news.php on line 14

30

lol oops. yeah

change that line to


 $row = mysql_fetch_array($r);

forgot to change the result variable…

31

OMG! I just saw the error that was causing all these problems! look at your for loop! The middle statement! You aren’t using a variable! You are just saying i it has to be $i!!!

32

It looks like it’s starting it’s loop again … waits … Here’s what is sais:

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 9 bytes) in /home/voetsjoeba/HTML/test/news.php on line 16

33

look at my last post ^

34

*Originally posted by Jubba *
**OMG! I just saw the error that was causing all these problems! look at your for loop! The middle statement! You aren’t using a variable! You are just saying i it has to be $i!!! **

AAAAAAAAAAAAAAAAAAAARGH :stuck_out_tongue: Thanks for noticing that ! I’m gonna try my original code with that changed.

35

stupid small insignificant errors!

36

Yeah I know we’re posting all through eachother, you’re always a little bit before me :stuck_out_tongue:

37

IT WORKS !!! http://voetsjoeba.xszone.nl/test/news.php.

Jubba: thankyouthankyouthankyouthankyou…x1000…

:stuck_out_tongue:

I’m so happy ! Thanks Jubba (and ahmed :wink: )