Re: [PHP] Need help with Database and variables

You need to fetch/get information out of the database using a function, since we want just one result (count) we can easily use mysql_result() Other functions that you're probably familiar with are mysql_fetch_row and mysql_fetch_array ... they'll work too but in this case, not as efficiently.

Re: [PHP] Need help with Database and variables

Be more specific please, as you typed "SELECT count(*) FROM ... as ..." this should return one row and only one! that means you need to fetch that row and use it as a variable and not within a row... can you plz clarify your question? -elias http://www.eassoft.cjb.net ""Ryan W. Zajicek"" <[EMAI

[PHP] Need help with Database and variables

Hello, I was wondering if I do a database query like "SELECT count(*) FROM table_name AS song_count" if there is a way I can assign song_count to a variable that is accessable anywhere on the page and not just in a "WHILE" statement? Thanks is advance Ryan mailto:[EMAIL PROTECTED] -- PHP Gen