PHP - Moved: Using Select Queries Within A Count()

This topic has been moved to MySQL Help.

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

This topic has been moved to MySQL Help.

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

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++;
?>

Hi fellas, having a bit of trouble getting a count from the database where the field is not empty?

$count= "SELECT COUNT(unid) FROM table";
$result2 = mysql_query($count) or die("Select Failed!");
$counter = mysql_fetch_array($result2);

echo $counter[0];

From what i have read, this should get all the not null results from the field, but it gets all of them.
Some are empty, the ones i want have various id numbers in them. Is there a way to get just the numbers where there is an id number present?

I'm trying to figure out how to implement SELECT COUNT into a php generated list.
My script lists all the users in one table $data = mysql_query("SELECT * FROM YBK_Login") or die(mysql_error()); 
while($info = mysql_fetch_array( $data )) { 
Print "<tr>"; 
Print "<td>".$info['UID'] . " </td>";
Print "<td>"."#"."</td>";
Print "<td>".$info['ID'] . "</td> "; 
Print "<td>".$info['Allowed'] . "</td> ";
Print "<td>".$info['pass'] . " </td>";
Print "<td>".$info['HR'] . " </td>"; } 

?>

And I want to use the count to count the number of entries each user has in a diffrent table.
Like pull the $info['ID'] and check against posts in YBK_Ads with the column name UID

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 />';}
}
?>

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

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>");
}

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`";

 $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

So here's what I'm trying to do, and I haven't found any clear tutorials on how to properly navigate a DOMDocument object, at least not in the strict sense of PHP.

I'm building a web scraper, I've had it working for some time now using more traditional methods (a combination of string manipulation and clever regex). I've been told xpath can be much faster and more reliable for what I need. Sold.

Let's say I'm parsing a forum. This forum separates each reply in a post with a set of <li></li> with a class of "message"

Code: [Select]
<li class="message">
    // Stuff here
</li>

<li class="message">
    // Stuff here
</li>

So far so good. These list items contain all the formatting for each post, including user info and the message text. Each sitting in it's own div.


Code: [Select]
<li class="message">
<div class="user info">
User info here
</div>

<div class="message text">
Message text here
</div>
</li>

<li class="message">
<div class="user info">
User info here
</div>

<div class="message text">
Message text here
</div>
</li>
Still with me? Good.

With this bit of code I can select each message list item block and iterate over all the sub nodes inside.

Code: [Select]
$items = $xpath->query("//li[starts-with(@class, 'message')]");

for ($i = 0; $i < $items->length; $i++) {
   echo $items->item($i)->nodeValue . "\n";
}

This produces a basic text dump of the entire forum. Close, but not what I need.

What I'm trying to do is as follows

Select all the class="message" list items [done] Once those have been selected, run another $xpath->query to select the child nodes which contain the user info and message text
Step one is done, step two is what is confusing me. How can I run a new query based on the output from the first query?

Thanks guys

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 Miscellaneous.

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

This topic has been moved to MySQL Help.

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