Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 260
  • Last Modified:

what is the function to count all the fields in a table?

lets say i have a table named t1
and it have in this table
id -  place
1 -   india
2 -  florida
3 -  la
4 -  new dom

so when i use the function it will return the nmber 4 for me

so what is this function?
0
mgtm3
Asked:
mgtm3
  • 3
  • 3
1 Solution
 
hernst42Commented:
the SQL is
"SELECT count(*) FROM t1";
to count all rows in that table
mysql_connect("localhost", "mysql_user", "mysql_password") or
    die("Could not connect: " . mysql_error());
mysql_select_db("mydb");
$result = mysql_query("SELECT count(*) FROM t1");
$row = mysql_fetch_array($result, MYSQL_NUM);
echo $row[0];  
mysql_free_result($result);

Open in new window

0
 
mgtm3Author Commented:
i am trying to to what u told me
1-i am using mysqli to connect to the sever
2-
                     --this what it did and didnt work ---
$result = mysqli_query("SELECT count(*) FROM pollnames");
$row = mysqli_fetch_array($result, $link);
echo $row[0];  
-----------------------------------------------------------

i got this error


Warning: mysqli_query() expects at least 2 parameters, 1 given in C:\wamp\www\poll\222.php on line 29

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\wamp\www\poll\222.php on line
0
 
hernst42Commented:
then its:

$result = mysqli_query($link, "SELECT count(*) FROM pollnames");
$row = mysqli_fetch_array($result, $link);
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
mgtm3Author Commented:
now i got this error
Warning: mysqli_fetch_array() expects parameter 2 to be long, object given in C:\wamp\www\poll\222.php on line 30
this is what i wrote
 
$result = mysqli_query($link, "SELECT count(*) FROM pollnames");
$row = mysqli_fetch_array($result, $link);
echo $row[0]; 

Open in new window

0
 
hernst42Commented:
That was what I copied from your code. Not realy famliliar with mysqli usage. This way should now work:
$result = mysqli_query($link, "SELECT count(*) FROM pollnames");
$row = mysqli_fetch_array($result, MYSQLI_NUM);
echo $row[0]; 

Open in new window

0
 
mgtm3Author Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now