Correct Way To Count And Display Value In Table?

[justlukeyou]

Hi,

 

Can anyone advise how to count and display the number of terms in a table. I have following code however it connects to the database each time I use which must be wrong.

 

 

<?php

$link = mysql_connect("localhost", "********", "**********");
mysql_select_db("*************", $link);

$event_query = mysql_query("
   SELECT
       COUNT(*) AS meeting_room
   FROM
       hostdbase
   WHERE
       category = 'meeting room'
");
$event_row = mysql_fetch_assoc($event_query);
$categorynumber = $event_row['meeting_room'];  // this is the number 

echo "$categorynumber \n";

?> 

 

This is an example where on the left handside it displays the number in the table.

 

https://www.odesk.com/o/jobs/browse/c/software-development/sc/scripts-utilities/

[Christian F.]

Gee.. I wonder why it does that!

Start reading the code, and not just copy it blindly. I know you've been told this repeatedly, by more people than me. Until you do that, and put an effort into actually learning, you're just wasting our time.

[justlukeyou]

But when I take that out and just use the connection code at the top of the page as standard it doesn't connect to the database.

 

 

[justlukeyou]

Hi,

 

Your right ive fixed it. But should I be using this format of code?

[Jessica]

How should we know?