[PHP-DB] SQL question!

[Bruno Braga]

Hey.

 

I have these tables.

 

Users ( id,name,etc )

Coments : ( id , comment )

 

 

How do I do this kind of query:

I thought in one thing like this but I cant figure it out.

Example: Select * from users order by id desc in (select count (id) from
comments)

 

 

Expected result:

 

List of users:

 

* User1

  See comments ( 32 comment in database )

 

* User2

  See coments (13 comments in database )

 

*   etc.

 

 

thanks in advanced.

Bruno

[PHP-DB] get rid of the HTML tags

[Bruno Braga]

Hi all.

 

I have this string:

 

$my_string = bhello world/ba href='teste.php'this is a test for a
link with a image img src='test.jpg'/a

 

Is there any function that retrieves only the string without the html tags?!
-- Hello world this is a test link with a image

 

 

Thx for ya help

Bruno, Portugal