[Resolved] count(*) results in a simple table

jonki

Hi - I am trying to acheive something very simple and that is to put the results from this statement

select publicidad, count(*) from db group by publicidad

Into a readable format.

Bascially to show me the sort of thing I get when I do it directly with MySQL.

I don't need anything fancy - just a sinple table but as I don't know what sort of output the "Count(*)" gives me I don't know how to put this in a table.

What I would like is something like this:

Newspaper 5
TV 10
Fairs 2

And then maybe if I can work out how to get the count(*) as a variable then I could maybe do this grafically. Which would be easy if only I could get the count bit as a concrete number.

Thanks a lot

Jon

LordShryku

You need to alias it.

$sql  = "SELECT publicidad, 
                count(*) AS cnt
           FROM db 
       GROUP BY publicidad";
$res  = mysql_query($sql);
while($row = mysql_fetch_array($res)) {
   echo $row['publicidad'].": ".$row['cnt']."<br />";
}

jonki

Exactly what I needed.

Thanks

jonki

Hi, I know I marked the thread as resolved but this question is a bit of a follow on from my previous one.

I am using the count to display different quantities in my database and I am doing this grafically by setting the width of a gif file to the variable cnt that was suggested to me earlier.

My problem is that I have a lot of blanks in my data base and the maximum of these count values is always the empty one which is of no interest and it messes up my results as it is way off the screen. (www.tenercoche.com/z1.php - if you want to see what I mean)

This is what I have been trying to do: Give me the count(*) for the data base but where $make is not empty.

I tried to do this with if statements, while statements in the php and then I thought I could do it in the mysql statement ie "...where !empty(make) ..." but I have had no luck.

Any suggestions how to do this.

Thanks

LordShryku

Well are they null or are they blank? I'd just add a clause to the sql to say WHERE field IS NOT NULL and field != ''

jonki

Once again - many thanks

I was confusing my php with my mysql and put in the mysql statement "where !empty(field)" - ofcourse it didn't work.

Cheers.

Jon