[RESOLVED] Mysql request

[steveDD]

Hi,

For my example I have my database called DB1 and my table called table1,
I have my admin area and I would like to show how many entries are in the table. just as a figure. (I would use the ID bit but obviously as some are deleted it auto increments).

I know this is simple but just can't figure it out.

Steve

[m_tt]

SELECT COUNT(`ID`) AS `num_rows` FROM `table1`

[steveDD]

 <?php

mysql_connect("localhost","User","password") or die(mysql_error());
mysql_select_db("table1") or die(mysql_error());
?>

<br>
<table width="84%" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td colspan="4" bgcolor="#bedaff"><div align="center" class="style5">
      <div align="center">Useful statistics</div>
    </div></td>
  </tr>
  <tr>
    <td width="25%" bgcolor="#bedaff"><div align="center"><span class="style1">Number of subscriptions</span></div></td>
    <td width="25%" bgcolor="#bedaff"><div align="center"><span class="style1">Number of Querys</span></div></td>
    <td width="25%" bgcolor="#bedaff"><div align="center"></div></td>
    <td width="25%" bgcolor="#bedaff"><div align="center"></div></td>
  </tr>
  <tr>
    <td bgcolor="#E5EEFF<?php SELECT_COUNT("ID") AS "num_rows" FROM "catA" 
?>
</td>
    <td bgcolor="#E5EEFF">&nbsp;</td>
    <td bgcolor="#E5EEFF">&nbsp;</td>
    <td bgcolor="#E5EEFF">&nbsp;</td>
  </tr>
</table>

I have put my php login for my Mysql above the table as I want to request figures from different parts of the DB not all from catA,

I want some of the blank table spaces to have information from catB or catC3 for example.

I just get errors at the minute. Obviously I have mashed the table up etc... Any ideas? on how I can select info from various parts of the DB, or do I need to connect individually each time I want something new? having said that I can't even get the one query above to work...

An example of above would be great

Steve

[m_tt]

I think you need to read up on basic php/mysql functionality. :o

Start here:

http://us.php.net/mysql_query

[steveDD]

probab;y do lol, it was just a quick feature i wanted to install 🙁

[steveDD]

yep all done, see what u were saying.

Thank you