PHP / MySQL coding help

[VillageIdiot906]

Is there any way to have PHP return the number of cols (entries) in a row?

Here's what I'm trying to do...

I have a page that lists all the entries in my database by using a for loop...

for ($i = 0; $i < [whatever code goes here]; $i++) {
//um... a bit more advanced than this... but I'll just use print to show you what I'm trying to do
print [entry at column $i];
}

So hopefully $i will print by however many entries are in the database.

[Siliconjunkie]

So you want to do a count?

count from 'table' where 'field' like "phrase";

[VillageIdiot906]

Aha. Thanks, but I figured out an easy way to do it. I just used an if statement asking if the column at $i was existant or not. If so, execute the code; if not, break the for loop.

But here's another question... how do you delete columns from a table?

[Siliconjunkie]

ALTER

http://dev.mysql.com/doc/mysql/en/alter-table.html

ALTER [IGNORE] TABLE tbl_name DROP [COLUMN] col_name