# PHP Overload

**URL:** <https://forum.kirupa.com/t/php-overload/24829>\
**Category:** programming\
**Created:** [July 5, 2003, 4:32pm UTC](https://forum.kirupa.com/t/php-overload/24829 "2003-07-05T16:32:43Z")\
**Posts on this page:** 17\
**Page:** 2

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [July 5, 2003, 5:58pm UTC](https://forum.kirupa.com/t/php-overload/24829/21 "2003-07-05T17:58:21Z")

</div>

```php

<?
$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);

?>

```

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [July 5, 2003, 5:58pm UTC](https://forum.kirupa.com/t/php-overload/24829/22 "2003-07-05T17:58:34Z")

</div>

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

:-\

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [July 5, 2003, 5:58pm UTC](https://forum.kirupa.com/t/php-overload/24829/23 "2003-07-05T17:58:38Z")

</div>

try that and tell me what number it prints out.

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [July 5, 2003, 5:59pm UTC](https://forum.kirupa.com/t/php-overload/24829/24 "2003-07-05T17:59:25Z")

</div>

> \*Originally posted by Jubba \*  
> \*\*

```php

<?
$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 🙂

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [July 5, 2003, 6:01pm UTC](https://forum.kirupa.com/t/php-overload/24829/25 "2003-07-05T18:01:19Z")

</div>

1.

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [July 5, 2003, 6:02pm UTC](https://forum.kirupa.com/t/php-overload/24829/26 "2003-07-05T18:02:27Z")

</div>

is there only one row in your **news** table?

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [July 5, 2003, 6:03pm UTC](https://forum.kirupa.com/t/php-overload/24829/27 "2003-07-05T18:03:31Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [July 5, 2003, 6:06pm UTC](https://forum.kirupa.com/t/php-overload/24829/28 "2003-07-05T18:06:24Z")

</div>

```php

<?
$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.

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [July 5, 2003, 6:09pm UTC](https://forum.kirupa.com/t/php-overload/24829/29 "2003-07-05T18:09:17Z")

</div>

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**

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [July 5, 2003, 6:10pm UTC](https://forum.kirupa.com/t/php-overload/24829/30 "2003-07-05T18:10:18Z")

</div>

lol oops. yeah

change that line to

```php

 $row = mysql_fetch_array($r);

```

forgot to change the result variable…

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [July 5, 2003, 6:11pm UTC](https://forum.kirupa.com/t/php-overload/24829/31 "2003-07-05T18:11:41Z")

</div>

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**!!!

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [July 5, 2003, 6:12pm UTC](https://forum.kirupa.com/t/php-overload/24829/32 "2003-07-05T18:12:57Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [July 5, 2003, 6:13pm UTC](https://forum.kirupa.com/t/php-overload/24829/33 "2003-07-05T18:13:40Z")

</div>

look at my last post ^

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [July 5, 2003, 6:14pm UTC](https://forum.kirupa.com/t/php-overload/24829/34 "2003-07-05T18:14:09Z")

</div>

> \*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 😛 Thanks for noticing that ! I’m gonna try my original code with that changed.

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [July 5, 2003, 6:14pm UTC](https://forum.kirupa.com/t/php-overload/24829/35 "2003-07-05T18:14:30Z")

</div>

stupid small insignificant errors!

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [July 5, 2003, 6:14pm UTC](https://forum.kirupa.com/t/php-overload/24829/36 "2003-07-05T18:14:49Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [July 5, 2003, 6:19pm UTC](https://forum.kirupa.com/t/php-overload/24829/37 "2003-07-05T18:19:44Z")

</div>

IT WORKS !!! [http://voetsjoeba.xszone.nl/test/news.php](http://voetsjoeba.xszone.nl/test/news.php).

Jubba: thankyouthankyouthankyouthankyou…x1000…

😛

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

[Previous page](https://forum.kirupa.com/t/php-overload/24829.md?page=1)