zero-perfoliate
zero-perfoliate

Author Topic: PHP help showing more than one row from mysql  (Read 202 times)

Offline gundum584

  • New PHP Members
  • Posts: 1
  • Karma: +0/-0
PHP help showing more than one row from mysql
« on: November 06, 2010, 08:14:25 PM »
i have this code
Code: [Select]
$ge = mysql_query("SELECT * FROM `slots` ") or die(      mysql_error());
$e = mysql_fetch_array($ge);
$d =mysql_num_rows($e['days']);
echo $d;

im trying to show all the info from row days in my mysql database but it gives me this error

Warning: mysql_num_rows(): supplied argument is not a valid

can someoen tell me what im doing wrong?

Offline cwarcarblue11

  • PHP Problem Solvers
  • *****
  • Posts: 112
  • Karma: +1/-0
    • C2C Technology
Re: PHP help showing more than one row from mysql
« Reply #1 on: November 07, 2010, 03:29:35 PM »
Yes. mysql_num_rows only works with the mysql query resource. So you need to do this:
$d =mysql_num_rows($ge);

 

zero-perfoliate