# Not a valid MySQL result?

**URL:** <https://forum.kirupa.com/t/not-a-valid-mysql-result/187068>\
**Category:** Uncategorized\
**Created:** [April 26, 2006, 2:47pm UTC](https://forum.kirupa.com/t/not-a-valid-mysql-result/187068 "2006-04-26T14:47:16Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Exos\_Sho](https://avatars.discourse-cdn.com/v4/letter/e/ed655f/32.png) [@Exos\_Sho](https://forum.kirupa.com/u/Exos_Sho)\
**Post date:** [April 26, 2006, 2:47pm UTC](https://forum.kirupa.com/t/not-a-valid-mysql-result/187068/1 "2006-04-26T14:47:16Z")

</div>

i dont know what this lines want to tell me:

> **Warning** : mysql\_num\_rows(): supplied argument is not a valid MySQL result resource in **C:\apachefriends\xampp\htdocs\personen.php** on line **15**  
> Datensätze gefunden

**Warning** : mysql\_fetch\_assoc(): supplied argument is not a valid MySQL result resource in **C:\apachefriends\xampp\htdocs\personen.php** on line **20**  
i simply made a db called “firma” with table “personen” looks like this(without the brackets):

> 

name(lastname)  
vorname(firstname)  
personalnummer(number of staff)  
gehalt(salery)  
geburtstag(birthday)

here is the php:

> 

\<html\>  
\<body\>

\<?php  
mysql\_connect();

mysql\_select\_db(“firma”);

$res=mysql\_query(“select \* from personen”);

[COLOR=Red] $num=mysql\_num\_rows[/COLOR](mysql\_query(“select \* from personen”));  
echo “$num Datensätze gefunden\<br\>”;

while ([COLOR=Red]$dsatz=mysql\_fetch\_assoc/COLOR)  
{  
echo $dsatz[“name”] . ", "  
. $dsatz[“vorname”] . ", "  
. $dsatz[“personalnummer”] . ", "  
. $dsatz[“gehalt”] . ", "  
. $dsatz[“geburtstag”] . “\<br\>”;  
}  
?\>

\</body\>  
\</html\>

ive no idea what to do now