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
Steveo31
Forum Contributor
Posts: 416 Joined: Sun Nov 23, 2003 9:05 pm
Location: San Jose CA
Post
by Steveo31 » Sat Apr 10, 2004 9:25 pm
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 » Sat Apr 10, 2004 10:00 pm
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 » Sat Apr 10, 2004 10:00 pm
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 » Sat Apr 10, 2004 10:03 pm
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 » Sat Apr 10, 2004 11:36 pm
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.
vigge89
Forum Regular
Posts: 875 Joined: Wed Jul 30, 2003 3:29 am
Location: Sweden
Post
by vigge89 » Sun Apr 11, 2004 4:51 am
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.....