Professional Web Applications Themes

newbie : trying to count records in mysql table - PHP Development

Help, I get no output on this code // Connect to database. $dbh = mysql_connect("localhost","user","password"); mysql_select_db("survey"); $query = "select count(*) from response1"; $result = mysql_query($query, $dbh); while ($rows = mysql_fetch_row($result)) { $count = $rows[0]; } print $count; any one have any Ideas ? Thanks in advance Jim...

  1. #1

    Default newbie : trying to count records in mysql table

    Help, I get no output on this code

    // Connect to database.
    $dbh = mysql_connect("localhost","user","password");
    mysql_select_db("survey");

    $query = "select count(*) from response1";
    $result = mysql_query($query, $dbh);

    while ($rows = mysql_fetch_row($result)) {
    $count = $rows[0];
    }


    print $count;







    any one have any Ideas ?

    Thanks in advance
    Jim


    jim Guest

  2. #2

    Default Re: newbie : trying to count records in mysql table

    try this....

    // Connect to database.
    > $dbh = mysql_connect("localhost","user","password");
    > mysql_select_db("survey");
    >
    > $query = "select count(*) AS rec_count from response1";
    > $result = mysql_query($query, $dbh);
    >
    > while ($rows = mysql_fetch_row($result)) {
    > $count = $rows['rec_count'];
    > }
    >
    >
    > print $count;
    Haven't tried it.....

    hope tis helps...

    point

    "jim" <luvkatztds.net> wrote in message
    news:p78sgv8rg85e9t7940qpeu86vpe95mp5oq4ax.com...
    > Help, I get no output on this code
    >
    > // Connect to database.
    > $dbh = mysql_connect("localhost","user","password");
    > mysql_select_db("survey");
    >
    > $query = "select count(*) from response1";
    > $result = mysql_query($query, $dbh);
    >
    > while ($rows = mysql_fetch_row($result)) {
    > $count = $rows[0];
    > }
    >
    >
    > print $count;
    >
    >
    >
    >
    >
    >
    >
    > any one have any Ideas ?
    >
    > Thanks in advance
    > Jim
    >
    >

    point Guest

Similar Threads

  1. How to get All Records in Table A that don't havematching ID in Table B
    By Photoshare in forum Coldfusion Database Access
    Replies: 4
    Last Post: February 23rd, 10:46 PM
  2. No records found for MySQL Table
    By wittsdd in forum Coldfusion Database Access
    Replies: 4
    Last Post: April 9th, 12:54 AM
  3. ASP Group Same Records and Give Total Count
    By gotcha in forum ASP Database
    Replies: 1
    Last Post: August 6th, 08:50 PM
  4. newbie php MySQL table question
    By Noel Ferguson in forum PHP Development
    Replies: 0
    Last Post: July 24th, 08:45 AM
  5. Delete from one table with matching records in another table
    By Dale Fye in forum Microsoft SQL / MS SQL Server
    Replies: 4
    Last Post: July 1st, 01:28 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139