[SOLVED] MySQL row count (prepared statement)

[malikah]

Hi, I'm having trouble returning a full row count from my database. The following code returns "1" column instead of "24" columns.

 

$conn = new mysqli(DB_SERVER, DB_USER, DB_PASSWORD, DB_NAME)

$query = "SELECT * FROM table";	

	if($stmt = $this->conn->prepare($query))
	{
		$stmt->execute();

		if($stmt->fetch())
		{
			if ($stmt->field_count) {
				$result = $stmt->store_result();
			}
			$stmt->close();
			return $result;
		}
	}

[perrij3]

You may want to use mysql_num_rows() to count your rows with.

 

http://us.php.net/manual/en/function.mysql-num-rows.php

[malikah]

You may want to use mysql_num_rows() to count your rows with.

 

http://us.php.net/manual/en/function.mysql-num-rows.php

 

I tried that, but unfortunately get the error: "Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource".

[alexdemers]

You need to store results so you can count them PHP: mysqli::store_result.

 

Edit: actually look at this if you are using prepared statements: PHP: mysqli_stmt::num_rows - Manual

 

Read the Typer85 at gmail dot com's comment at the bottom of the page.

[perrij3]

Did you add the results from the sql query in between the () you are trying to count?

 

	$sql = "Select * FROM usertable'";
	$result = mysql_query($sql) or die(mysql_error());
	$NumberOfRows = mysql_num_rows($result);

[alexdemers]

To add to my previous response, you need to do num_rows method and not field_count method.

[malikah]

To add to my previous response, you need to do num_rows method and not field_count method.

 

I'm actually trying to count columns, not rows - but thanks

[malikah]

So far this works for ROWS but I need something for COLUMNS:

 

$query = "SELECT * FROM table";	

	if($stmt = $this->conn->prepare($query))
	{
		$stmt->execute();
		$stmt->store_result();
		echo $stmt->num_rows();
		$stmt->close();
      }

[perrij3]

Try mysql_num_fields instead of mysql_num_rows.

 

http://us2.php.net/mysql-num-fields

 

or you may want to try fbsql_num_fields

 

http://www.php.net/manual/en/function.fbsql-num-fields.php

[malikah]

OK, I used "DESCRIBE table" to get it working:

 

$query = "DESCRIBE table";   
      
      if($stmt = $this->conn->prepare($query))
      {
         $stmt->execute();
         $stmt->store_result();
         echo $stmt->num_rows();
         $stmt->close();
      }

 

NOW.. All I need is to return the names of each field...