[Solved]Num Count returns 1 no matter what

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
Steveo31
Forum Contributor
Posts: 416
Joined: Sun Nov 23, 2003 9:05 pm
Location: San Jose CA

[Solved]Num Count returns 1 no matter what

Post by Steveo31 »

Got a database with table 'members' and fields 'name', 'squad' so on and so forth.

Code: Select all

$num = mysql_query("SELECT COUNT(*) FROM members WHERE squad = '".$_GET['squad']."'");
$num_rows = mysql_num_rows($num);
Each name is in a specific squad, I would like to return how many names are in that squad. It comes back with one no matter what.

Do you need more info or...? Thanks.
Last edited by Steveo31 on Sun Apr 11, 2004 12:51 pm, edited 1 time in total.
litebearer
Forum Contributor
Posts: 194
Joined: Sat Mar 27, 2004 5:54 am

Post by litebearer »

perhaps try this

Code: Select all

$squad = $_GET('squad');

$query="SELECT * FROM members WHERE squad = '$squad'";
$result=mysql_query($query);
$num_rows = mysql_num_rows($result);
Last edited by litebearer on Sat Apr 10, 2004 10:10 pm, edited 1 time in total.
Vicious
Forum Contributor
Posts: 105
Joined: Fri Jun 20, 2003 12:40 pm

Post by Vicious »

The double Quotes on $_GET['squad'] Will not work
Vicious
Forum Contributor
Posts: 105
Joined: Fri Jun 20, 2003 12:40 pm

Post by Vicious »

or try

Code: Select all

$num = mysql_query("SELECT COUNT(*) FROM members WHERE squad =($_GETї'squad'])"); 
$num_rows = mysql_num_rows($num);
Steveo31
Forum Contributor
Posts: 416
Joined: Sun Nov 23, 2003 9:05 pm
Location: San Jose CA

Post by Steveo31 »

litebearer wrote:perhaps try this

Code: Select all

$squad = $_GET('squad');

$query="SELECT * FROM members WHERE squad = '$squad'";
$result=mysql_query($query);
$num_rows = mysql_num_rows($result);
That did it. Thanks lite.
User avatar
vigge89
Forum Regular
Posts: 875
Joined: Wed Jul 30, 2003 3:29 am
Location: Sweden

Post by vigge89 »

Code: Select all

<?php

$num = mysql_query ("SELECT COUNT(*) FROM members WHERE squad = '{$_GET['squad']}'");
$num_rows = mysql_num_rows ($num); 


?>
you forgot the qoutes.....
Post Reply