PHP - Moved: Select Count

Hey, having an odd issue, looking to show players whos within 25 ranks of them lower and higher, i'm unsure as to why the following code doesn't actually do it... would anyone care to explain...

Code: [Select]
<?php
$score = $playerdata['score'];
$sql = "SELECT * FROM `players` WHERE '$score' BETWEEN 25 AND 75 ORDER BY `score` DESC";
$query = mysql_query($sql) or die(mysql_error());
$i=0;
while($players = mysql_fetch_array($query))
{
$i++;
?>

Hello there,

Having a nightmare here.  It feels like what I need to do is really easy but I just can't get it to work.  I have a table called "groups2" that holds a unique id and the name of an activity.

I already have a query that finds the users selected groups using a while loop but I also want to show how many other members are in that group by counting the number of times the activity comes up or the id comes up.  I don't know whether I need 2 while loops nested or what but I get the error

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource on line 32 which is highlighted.

Can anyone help.  I am no expert at php and still learning so some advice or example code would be great.


$result = mysql_query("SELECT * FROM groups2 WHERE L_ID = ". $_SESSION['member_ID'] .";");
$data = mysql_query("SELECT COUNT('name') AS num FROM groups2 WHERE name = " . $row['name'] . "");
$count = mysql_fetch_assoc($data);
$numbers = $count['num'];
while ( $row = mysql_fetch_assoc($result) ) {
echo("<tr>
<td><font face='Arial, Helvetica, sans-serif' size='3'><strong>" . $row["name"] . "</strong></font></td>
</tr><tr>
<td><font face='Arial, Helvetica, sans-serif' size='1' color='#0000FF'><strong>Members (" . $numbers . ")</strong></font></td>
</tr><tr>
<td><hr width=95%><br></td>
</tr>");
}

Hello there,   This is the script i use right know, and i want it to become easier because i have so much categories that i want to show and it will take days to write all those categories.

<?php
include 'extern/connect-.php';
//*****************************************************************************
// categEGORY A
//*****************************************************************************
$result = mysql_query("select 
(select count(1) FROM videos WHERE title LIKE '%Accident%') as Accident	,
(select count(1) FROM videos WHERE title LIKE '%Acrobatic%') as Acrobatic,
(select count(1) FROM videos WHERE title LIKE '%Adorable%') as Adorable	,
(select count(1) FROM videos WHERE title LIKE '%Adventure%') as Adventure,

");
                                                            
$row = mysql_fetch_assoc($result);
 
foreach($row as $title => $total)
{
  echo '
<div id="categ">
<div class="a">
<a href="search.php?search='. $title . '&submit= ">'. $title.'&nbsp;&nbsp;'. $total .'</a></div></div>';
}

?>

So what i was thinking is if it is possible to make .txt file and to select from it like this here below, or if something else could help make the categories faster to write and get the best performance to load the webpage...      some_file.txt Accident     Acrobatic Adorable     Adventure

<?php include 'extern/connect-.php';

$something ='some_file.txt';


//*****************************************************************************
// categEGORY A
//*****************************************************************************
$result = mysql_query("select 
(select count(1) FROM videos WHERE $something  ......?	,


echo 'categories';
?>

Any help is Appreciated Thanks in Advance

hi, I want to count the total number of multiple select that user has selected instead of getting the value the user has selected How should I go about doing the counting part?

Code: [Select]
<form action="1.php" method="post">
<select name="test[]" multiple="multiple">
<option value="one">one</option>
<option value="two">two</option>
<option value="three">three</option>
<option value="four">four</option>
<option value="five">five</option>
</select>
<input type="submit" value="Send" />
</form>


<?php
$test=$_POST['test'];
if ($test){
 foreach ($test as $t){echo 'You selected ',$t,'<br />';}
}
?>

 $result = mysql_query("SELECT *  FROM `friend_system` WHERE `friend_system_accepter` = '$myusername' ");
echo mysql_num_rows($result);

This displays the total rows in the table.

$result = mysql_query("SELECT COUNT(friend_system_accepter)  FROM `friend_system` WHERE `friend_system_accepter` = '$myusername' ");
echo mysql_num_rows($result);

This displays '1', which is incorrect.   I want to echo out the number of rows where 'friend_system_accepter' = $myusername   Thanks

The code below is part of some validation code that I have, it is supposed to count the number of entries in the table 'test_selections' where 'userid' equals the user that is logged in and where the 'transfer_in' date is a date within the current month. I am getting an error saying "Error running query Unknown column '10' in 'where clause' ". Does anybody know why this could be? I am hoping that it is something to do with the snippet of code below so I don't need to post the whole lot!!

Any help would be much appreciated.

Code: [Select]
$current_month = date("m");
$query = "SELECT COUNT(`userid`) as `transfers_count`
          FROM `test_selections`
          WHERE `userid` = '{$_SESSION['userid']}' AND Month(`transfer_in`) = `$current_month`
          GROUP BY `userid`";

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=320042.0

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=306062.0

This topic has been moved to PHP Applications.

http://www.phpfreaks.com/forums/index.php?topic=344992.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=326580.0

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=343070.0

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=342776.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=310377.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=330080.0

This topic has been moved to PHP Math Help.

http://www.phpfreaks.com/forums/index.php?topic=351485.0