get total no rows

[d2ns]

hi. im new

how do i get php to count the total number of rows in my mysql table and return that value?

probably really easy to awnser but quite hard for me to find out. thanks.

chris

[ultraslacker]

The counting really doesnt need to be done through php -

-- count rows in table.
SELECT count(1) FROM tablename;

[d2ns]

well i'm building a flash interface that communicates with mysql database by php. and i'm really new to all this.

actually I DONT EVEN KNOW WHAT POSTGRESQL IS 😃

so how would I use these commands?

Flash loads the variabeles that come frome my file (getitem1.php) this php file is supposed to return all fields in the table with the id corresponding to the total number of rows in a way that flash can understand it.

for example: my table would look like:
id=1, picture=byebye.jpg
id=2, picture=hello.jpg

my code should do this.

$number=total no of rows
query that selects * from table where id = $number.

the output should be
id=2&picture=hello.jpg
because 2 is the number of total rows and this also happens to be the id that corresponds with the last inserted record.

hehe

thanks (hope it makes sense)

[ultraslacker]

Then do some research - google is your friend

This is a tutorial about flash + php + mysql
http://www.devshed.com/Client_Side/Flash/WebForms/page1.html

[d2ns]

usefull but not what i was looking for.

thanks