[sort array by group]

try to change

         $a = implode('', $a);
         $b = implode('', $b);

to

         $a = implode('', $a).'a';
         $b = implode('', $b).'a';

not tested

[count grouped results]

SELECT *, COOUNT(*)  AS num FROM (SELECT * FROM `hits`GROUP BY ip) a GROUP BY cullumn_name_with_numbers_784_and_so_on

[problem with arrays in URL query]

yes if start is number

[Is this foreach() correct/possible?]

<?php
$titles_list = array(1,2,3);
$prices_list = array(11,22,33);
$services_list = array(111,222,333);
reset($titles_list);
reset($prices_list);
reset($services_list);
$title = current($titles_list);
$price = current($prices_list);
$service_id = current($services_list);
while ($title and $price and $service_id){
    mysql_query("INSERT INTO product_invoices (name, invoice_id, price, quantity, date_time, service_id) VALUES('$title', '$invoice_id', '$price', '$today_slashes', '$service_id')") or die(mysql_error());
    
    $title = next($titles_list);
    $price = next($prices_list);
    $service_id = next($services_list);
}
?>

[problem with arrays in URL query]

 $page_name = $_SERVER["REQUEST_URI"];
$page_name = preg_replace('/&?limit=\d+/','',$page_name);

[recursively search a multidimensional array and return all parents]

try

<?php
$hierarchy=array();
$hierarchy[]=array('id' => 1, 'parent_id'  => 0, 'name' => 'root1');
$hierarchy[] = array('id' => 2, 'parent_id' => 0, 'name' => 'root2');
$hierarchy[] = array('id' => 3, 'parent_id' => 1, 'name' => 'root1-1');
$hierarchy[] = array('id' => 4, 'parent_id' => 1, 'name' => 'root1-2');
$hierarchy[] = array('id' => 5, 'parent_id' => 3, 'name' => 'root1-1-1');
$hierarchy[] = array('id' => 6, 'parent_id' => 2, 'name' => 'root2-1');
function find_pat($a, $n, $key='name' ){
    $out = array();
    foreach ($a as $r){
        if ($r[$key] == $n){
            $out = find_pat($a, $r['parent_id'],'id');
            $out[]=$r;
        }
    }
    return $out;
}
$a = find_pat($hierarchy, 'root1-1-1');]
print_r($a);
?> 

[A complex [for me] if / else statement]

SELECT 
group_concat(if((select count(b.id) from table b where b.id <= a.id and a.grup = b.grup)=1, a.name, '') separator '') name_1,
group_concat(if((select count(b.id) from table b where b.id <= a.id and a.grup = b.grup)=2, a.name, '') separator '') name_2,
group_concat(if((select count(b.id) from table b where b.id <= a.id and a.grup = b.grup)=3, a.name, '') separator '') name_3,
group_concat(if((select count(b.id) from table b where b.id <= a.id and a.grup = b.grup)=4, a.name, '') separator '') name_4,
group_concat(if((select count(b.id) from table b where b.id <= a.id and a.grup = b.grup)=5, a.name, '') separator '') name_5

FROM table a 

group by a.grup

ORDER BY a.id

[A complex [for me] if / else statement]

you can use GROUP and GROUP_CONCAT in your query

[array trouble]

$result = mysql_query("select * from staff'");
$i=0:

echo "<table border='0' cellpadding='10' cellspacing='0'>";
//echo "<tr>";
while($row = mysql_fetch_array($result))
{
if($i == 0) echo '<tr>';
$i++;
echo "<td><img src=../upload/".$row['Pic']." border='0' width='140' height='105' /></td>";
echo "<td>".$row['Name']."</br><b>".$row['Role']."</b></td>";
if($i==2){echo '</tr>'; $i=0;}
}
if($i>0)echo "<td> </td></tr>";
echo "</table>";

[Compare two tables and output multiple rows that match]

add names of fields that you want to select after SELECT command

[redirect]

you look for $_SERVER[REQUEST_URI]

[Compare two tables and output multiple rows that match]

use different variables for your results

[Function as a variable]

change your function to

function somefunction($vaiable) {
$gers = mysql_query(sprintf("SELECT emp_id, lastname FROM info WHERE active='1' AND oid='$oid' AND pidnumber='4'")) or die(mysql_error());
$out ='';
while ($gerow = mysql_fetch_array($gers)) { 
$out .= "ci.attorney='$lastnamey' OR ";

}
return $out;
}[>/code]

[How to get the last characters of a URL?]

try

if(isset($_GET['lang'])) {
   switch($_GET['lang']) {
      case 'zh-hans':
         	include (TEMPLATEPATH . '/branches-cn.php');  //branches pages contains the translated images
         break;

      case 'zh-hant':
        	include (TEMPLATEPATH . '/branches-tcn.php'); 
         break;

      default:
         include (TEMPLATEPATH . '/branches.php'); //This is my english page 
         break;
   }
} else  include (TEMPLATEPATH . '/branches.php');

[Help Parsing text file]

or

<?php
$test ='"STEAM_0:0:18130940"	
{
"admin"	"(Console)"
"unban"	"1274151724"
"time"	"1273546924"
"name"	"-=SAS=- Death Master511"
"reason"	"Gcombat on spawn/Server Crash Attempts 1 week appeal at halania.com"
}
"STEAM_0:1:6428933"	
{
"time"	1273619777
"unban"	1273706177
"admin"	"TornadoChas3r(STEAM_0:0:19768725)"
"name"	".:T.¥:. TRÅÑŒ (CRYSTAL)"
"reason"	"RDM/ 1 day Ban \"You had Enough Warnings\" / :"
}
';
$test = preg_replace('/"(STEAM_[^"]+)"/', '[$1]', $test);
$test = preg_replace('/\{|}/', '', $test);
$test = preg_replace('/"([^"]+)"\t+([^ ])/S', '$1=$2', $test);

$test = parse_ini_string($test, 1);
print_r($test);
?> 

[Memory Usage: Arrays initialized differently]

try

<?php
$string_parts = 4;
$max = 10000;
$arr = array();
$i = 0;
$start = memory_get_usage();
$ar =  array_pad(array(), 4, "A");
for(;$i<$max;$i++){
//$arr[] = array_pad(array(), 4, "A");
$arr[] = $ar;
}
$end = memory_get_usage();
printf("%d iterations, %d bytes in array\n", $max, $end-$start);


$arr2 = array();
$i = 0;
$ar = array("A", "A", "A", "A");
$start2 = memory_get_usage();
for(;$i<$max;$i++){
$arr2[] = $ar;
//$arr2[] = array('A', 'A', 'A', 'A');
//$arr2[] = array_fill(0,4,'A');
}
$end2 = memory_get_usage();
printf("%d iterations, %d bytes in array (%.2f%%)\n", $max, $end2-$start2, ($end2-$start2)/($end-$start)*100);
?> f/code]

[activating script five times a day (time math help request)]

try

<?php
$time = 200;
$each_block = 60;
$total_time = 86400;
$no_blocks = $total_time / $each_block;
$curr_bl = ceil($time / $each_block);
$to_end_of_block = $curr_bl * $each_block - $time;
$left = $no_blocks - $curr_bl;
echo "You are on block num $curr_bl, to the end of this block left $to_end_of_block sec and to the end of the day left $left blocks."
?>

[Problems with Loops / For's / Cycles]

try

for($i = 0; $i < $num_course; $i++) // num_course is the number of arrays (course0,course1) that are recieved
		{
                  
                 $test = "course".$i;
     
                 for($x = 0; $x < sizeof($$test); $x++) //ad one more $
                   {

                   echo($$test[$x]); //same here
                   }

                        }

[counting all values in column without creating a new columnHi, I have downloads]

try

<?php
$downloadscount = mysql_query("SELECT SUM(timesdownloaded) FROM sheets WHERE timesdownloaded>='0'");
//$totaldownloads = mysql_num_rows($downloadscount);
$totaldownloads = mysql_result($downloadscount, 0, 0);
?>

[SUBSTR Question and truncating a variable]

<?php
$test = '000000001718989';
$test = ltrim($test, '0');
echo $test;
?>

[Nested While Loop not working]

use mysql_data_seek($result, 0); before inside loop to move index to start of $result

[extract part of a string]

try

<?php
$test = '[quote="AdRock"]just testing the error[/quote] Another test';
$test = html_entity_decode($test, ENT_QUOTES);
preg_match_all('/\[\s*QUOTE="([^"]*)"/s', $test, $out);
print_r($out[1]);
?>

[adding seperator if values are NOT empty]

try

<?php
$food = "";
$drink = "beer";
$price = "five dollars";
$test = array($food, $drink, $price);
foreach ($test as $key => $v )    if (!$v)        unset ($test[$key]);
$test = implode(', ', $test);
echo $test;
?>

[Complex query call in php]

WHERE CFBP.Game_ID = CFBG.ID AND ((CFBP.Pick =1 AND CFBP.Pick = CFBG.Away) OR (CFBP.Pick =2 AND CFBP.Pick = CFBG.Home)) AND CFBP.User_ID = $user; 

[Multiple queries]

try to change $row['promo.title'] to $row['title']