PHP - Moved: Select Count(*) Good Idea?

This topic has been moved to Application Design.

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

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?

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

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

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

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

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

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

This topic has been moved to Application Design.

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

This topic has been moved to Other Programming Languages.

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

This topic has been moved to Miscellaneous.

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

Hi
First of all, I know VERY little about PHP, The effort below is a wile guess that has gone wrong. I get this error Parse error: syntax error,

unexpected T_IF in /home/repairyo/public_html/shop/includes/content/viewOrders.inc.php on line 57

I have no idea what ive done wrong, may be I am stupid for attempting it.

Cheers
Paul

This is the original code
Code: [Select]
$view_orders->assign('VAL_STATE',$lang['glob']['orderState_'.$orders[$i]['status']]);
This is the modified code

Code: [Select]
$view_orders->assign('VAL_STATE',$state = $results[$i]['status']
                         if ($state == '1') {
"<font color='#ff9900'>".$lang['glob']['orderState_'.$results[$i]['status']]."</font>";
  } else if ($state == '2') {
"<font color='#009900'>".$lang['glob']['orderState_'.$results[$i]['status']]."</font>";
  } else if ($state == '4') {
"<font color='#cc0000'>".$lang['glob']['orderState_'.$results[$i]['status']]."</font>";
  } else if ($state == '5') {
"<font color='#cc0000'>".$lang['glob']['orderState_'.$results[$i]['status']]."</font>";
  } else if ($state == '6') {
"<font color='#cc0000'>".$lang['glob']['orderState_'.$results[$i]['status']]."</font>";
  } else if ($state == '7') {
"<font color='#ff9900'>".$lang['glob']['orderState_'.$results[$i]['status']]."</font>";
  } else {
$lang['glob']['orderState_'.$orders[$i]['status']]); }

This topic has been moved to Miscellaneous.

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