| Jul 4, 2009 |
Just setting that text string as a variable won't do anything. Put this code after the $sql variable:
CODE mysql_query($sql); If you want to count the number of rows then use the mysql_num_rows() function. If its fields you're after then use the mysql_num_fields() function. Hope this helps you. QUOTE(rvalkass @ Oct 4 2005, 01:49 PM) Just setting that text string as a variable won't do anything. Put this code after the $sql variable: CODE mysql_query($sql); If you want to count the number of rows then use the mysql_num_rows() function. If its fields you're after then use the mysql_num_fields() function. Hope this helps you.  of course i query first the $sql variable with mysql_query($sql).. anyway just a follow up question.. what function parameters shoudl i pass to mysql_num_rows() to be able to get the row count of let say for example WHERE sex = 'male'.. something like that.. what i realy need is not all the row count of a single table but certain rows that contains certain data...
for the meantime i am using ths code to be able to know the number of rows which has a certain data... CODE while($row = mysql_fetch_array($result)) $count++; but this kind of approach will take a lot of processing and space in the server.. becuase if the table contains a thousand rows then it will load to memory all those information which is not necesary.. i still need an alternative to this problem.. if there is any.. thnks..
Your problem is your SELECT statement. To SELECT the rows, you need to remove the COUNT() parameter like this.
CODE $sql = "SELECT * FROM messages WHERE _parent={$row['_id']}"; Then to return the actual rows and the count of the rows you need statements something like this, assuming you have 3 fields in each row. CODE <table><?php $result = mysql_query($sql); $numrows = mysql_num_rows($result); while($row = mysql_fetch_array($result)) {echo "<tr><td>$row[field1]</td><td>$row[field2]</td><td>$row[field3]</td></tr>";} ?></table> The variable '$numrows' will return the count of rows returned by your SELECT statement. Hope that helps. 
The mysql_num_rows() function returns the number of rows returned from the last query executed, as has been mentioned. Any easy approach would simply be:
CODE mysql_num_rows(mysql_query('SELECT blah FROM blah WHERE sex = "male"')); When modifying data in a table, the mysql_affected_rows() function returns the number of rows affected by that query (eg. mysql_query('DELETE FROM blah LIMIT 2'); mysql_affected_rows() = 2).
I agree with Spectre allthough he made 1 mistake...
mysql_num_rows() returns the result of the "specified" result (no not query) .. so once you executes your query you can use $numerofrows = mysql_num_rows($result); yo make the variable $numerofrows contain an Integer with the rowcount...
Use this:
$sql = "SELECT COUNT(*) FROM messages WHERE _parent={$row['_id']}"; $query=mysql_query($sql); $amount=mysql_fetch_row($query); then $amount[0] is the result you want.
hi, saga
overall I have read whole thread, and have this summary if you wish to 1.) only wanted the no. of records(rows) with a sub-set of all records. you can do this as following, let's say we have a table (table1) with 3 fields: id, role, groups, then: CODE k:\mysql\bin>mysql<enter> mysql> show tables; +--------------------+ | Tables_in_test_db2 | +--------------------+ | table1 | +--------------------+ 1 row in set (0.00 sec) mysql> select * from table1; +----+------+--------+ | id | role | groups | +----+------+--------+ | 1 | 0 | 0 | | 2 | 1 | 0 | | 3 | 5 | 0 | +----+------+--------+ 3 rows in set (0.00 sec) mysql> select count(*) from table1 where role=0; +----------+ | count(*) | +----------+ | 1 | +----------+ 1 row in set (0.00 sec) mysql> select count(*) from table1 where groups=0; +----------+ | count(*) | +----------+ | 3 | +----------+ 1 row in set (0.00 sec) as you can see the result that return a value(1, 3 above) with a field named (count(*)). then, you can use : a.) $row = mysql_fetch_array($result) b.) $numrow = $row[0]; in fact, you can use $row = mysql_fetch_row($result) also, but that required you modify the sql statement, you can have a reference to mysql mannual 2.) as other forum members stated, you use: $roleid = 0; $sql = "SELECT * FROM messages WHERE role=$roleid"; $result = mysql_query($sql); $rownum = mysql_num_rows($result); $row = mysql_fetch_row($result) ==> for get row - hope this help - Eric
Similar Topics
Keywords : Php Mysql
Has anyone tried using the excel import function that comes with phpmyadmin hey....i have heard a lot about PHP and MySql, there are a lot of articles about it and every bit of Hi guys. I want t know if it is posible to have so many entries for one object in a field in MySQL. Hi, I am creating a website in php and using a mysql database to store the data. I want to store I hope I am on topic here (It does have to do with web design, after all). I have noticed that in a If I wanted to use an ID field which automatically increments when data are addad, but displays the In my MySQL table I would like to use one text field which can contain lots of text. What I want to If you have set a root password, but forgot what it was, you can set a new password with the Hii i need help margning script. i have coppermine gallery, AzDGDating Site, Noah's How do you combine multiple mysql databases into one database? I was thinking thta soem servers Hi if someone could get back to me as fast as they can that would be great! i got a couple of I just finished reading a php book, and figured out some interesting things, and wanted to share helo! hou do you? i need somebody post the data for acces my mysql database from my client. thanks a I'm not a professional web developer but I've learned a lot since I used Macromedia Can MS Access interface with mySQL? Does anyone know how to set it up? Is it even a good idea to?... What are the best Open Source MySql developer tools?... hello... what are the infos for the mysql databases ? Like the host, is it localhost ? and the the best way to start php is probably not adjusting a script IMO - that misses out a stage. - the Hello....I am crap at making websites and I don't even know how to use MySql. I don't even Looking for php, mysql, problem
|
 Php And Mysql Problem - Need a little help |
Affordable Web Hosting, Low cost Web Hosting - ComputingHost.com
