1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

How to count rows from differrent database?

Discussion in 'PHP' started by geekos, Dec 12, 2010.

0
  1. #1
    Hi

    I have 5 database and I need to count a row from a table each database.

    Hope someone can help me.

    Thanks.
     
    geekos, Dec 12, 2010 IP
  2. shofstetter

    shofstetter Well-Known Member

    Messages:
    178
    Likes Received:
    7
    Best Answers:
    1
    Trophy Points:
    120
    #2
    you can use mysql_select_db to switch between databases and run a query on each one to get your count. if you need a combined count you can add your results after executing both queries.

    ex:
    
mysql_select_db("database1",$con);
$rs1 = mysql_query("SELECT COUNT(filed) FROM table1 where x=0",$con);
mysql_select_db("database2",$con);
$rs1 = mysql_query("SELECT COUNT(filed) FROM table2 where x=0",$con);

/* code here to extract and add values from result sources  */
    Code (markup):
     
    shofstetter, Dec 12, 2010 IP