[need help with an active user script.]

SELECT name, MAX(number) FROM table_name GROUP BY name

[Wanting to echo only the most recent of a product....]

$sql = "SELECT * FROM " .$year_arr[$i]. "data WHERE ENGFAM = '$efn' AND EO IN (SELECT max(EO) FROM " .$year_arr[$i]. "data WHERE 1 GROUP BY LEFT(EO,6)) ORDER BY Verified DESC";

[Wanting to echo only the most recent of a product....]

try

SELECT max(EO) FROM `xxx` WHERE 1 GROUP BY LEFT(EO,6)

[Pushing data into a multi-dimensional array from mysql results]

try

while($r=mysql_fetch_assoc($res)) array_push($chart['chart_data'][0], $r['wght']);

[count number of hacks?]

sorry

mysql_query($sql) or die(mysql_error()); 

must be

$query = mysql_query($sql) or die(mysql_error()); 

[count number of hacks?]

try

mysql_select_db($database) 
or die ("Could not select database because ".mysql_error()); 
$sql="SELECT type.link, type.name, count(hack.id) AS co FROM type LEFT JOIN hack ON hack.typeid=type.typeid GROUP BY type.name ORDER BY type.name ASC";
mysql_query($sql) or die(mysql_error()); 
while ($row = mysql_fetch_object($query)) 
  { 
    echo "<a href=\"$row->link\" alt=\"$row->name\">$row->name $row->co</a><br />"; 
    } 

[Date function problems.]

date('20d-m-y');

[[SOLVED] last row in array or record...]

try

$last_admit_date = mysql_result($resultselectadmissionquery,mysql_num_rows($resultselectadmissionquery)-1,'admit_date');

[Removing bbcode uid (user id)]

try

<?php
$result ='
[img:868416aced]http://claninfectionist.com/tutorials/photoshop/FireText/untitled18.png[/img:868416aced]';
echo $result1 = preg_replace("[[/]*img:[^\]]+]", "img", $result);
echo "\nor";
echo $result2 = preg_replace("[img:[^\]]+]", "img", $result);
?>

[[SOLVED] Best way to wrap a template around a PHP file]

rename your page to buy.php (you use same php in it)

and

include('index1.php');

[[SOLVED] store syntax in mysql database]

try

<?php

$host="localhost"; // Host name
$username="1234"; // Mysql username
$password="1234"; // Mysql password
$db_name="test"; // Database name
$tbl_name="testing2"; // Table name


// Connect to server and select databse.
$connection=@mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");


$db = @mysql_select_db($db_name, $connection) or die(mysql_error());

$sql="SELECT * FROM $tbl_name ORDER BY id";

$result = mysql_query($sql,$connection) or die(mysql_error());

$y =  0;
while ($row=mysql_fetch_array($result))
{
$id = $row['id'];
$parameter = $row['parameter'];
$operator = $row['operator'];
$value = $row['value'];
if (isset($$parameter)){
	$out = "\$test = \$$parameter $operator $value;";
	eval($out);
	echo "Test $id ";
	if ($test) echo "true<br />\n"; else echo "false<br />\n";
} else echo "Variable \$$parameter not exist <br />\n";
}

/*
$parameter == $y;

eval('?>'.$y.$operator.$value.'<?php ');
*/
echo "hi";


?>

[How to put an array of objects into alphabetical order???]

try

public function set_contacts($member_id)
{	
	$sql = '
		SELECT 
			* 
		FROM 
			network
		WHERE 
			member_id = ' . (int)$member_id .' 
		AND 
			contact="Yes"';
                $sql = $sql.' OEDER BY name';

	if ($rows = $this->Db->get_rows($sql))
	{
		$Member = new Member();
		foreach($rows as $row)
		{
			$this->contact_list[] = new Member($row['network_member_id']);
		}
	}
}

[Need to display results in multiple columns.. not working]

sorry

i jusr copy your code and i don't see line 5

remove line 5 ($row = mysql_fetch_array($results) or die(mysql_error())

[Need to display results in multiple columns.. not working]

try

<?php
// run query
$sql = "SELECT * FROM subcategories";
$results = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_array($results) or die(mysql_error());
$totalColumns = 2;
$i = 1;
echo "<table border='0' cellpadding='2'>";
while ($row = mysql_fetch_array($results)){
if ($i == 1) echo "<tr>";
echo "<td>";
echo "<a href='getcat.php?". $row['subcat_id'] . "'>" . $row['subcat_name'] . "</a>";
echo "</td>";
if ($i == $totalColumns)
	{
	echo "</tr>";
	$i = 0;
	}
$i++;
}
echo "</table>";
?>

[[SOLVED] Array problems.]

try to trim variable $item

[sort rows from two queries]

or try

<?php
function ms($a, $b) {
if ($a['sum'] < $b['sum']) return 1;
elseif ($a['sum'] > $b['sum']) return -1;
else return 0;
}

$values = array('ed' => array('current' => 25, 'sum' => 50, 'name' => 'ed'),
			'ted' => array('current' => 30, 'sum' => 70, 'name' => 'ted'),
			'tom' => array('current' => 28, 'sum' => 60, 'name' => 'tom')
		);

usort($values, 'ms');

print_r($values);
?>

[simple question I think...]

look function mysql_insert_id()

[Submit from a drop down menu issue]

Set value of $problem1 to true at start of script

[Figuring out functions...]

edit != Edit

[[SOLVED] Problems Unserializing a non standard serialized array]

try

<?php
function uns1($a) {
$b = explode(' AND ', $a);
$o = '';
for ($i = count($b)-1; $i >= 0; $i--) {
	$tmp = explode(' OR ', $b[$i]);
	if ($o){
		$q = $o;
		$o = array();
		foreach ($tmp as $x) $o[$x] = $q;
	} else $o = (count($tmp) == 1) ? $tmp[0] : $tmp;
}
return $o;
}

function aa ($a, $b) {
foreach ($a as $k => $v) {
	if (is_array($v)) { 
		//unset($a[$k]);
		$a[$k]=aa($v, $b);
	} else { 
		//unset($a[$v]);
		unset($a[$k]);
		if (is_array($b) && count($b) == 1) $b=$b[0];
		$a[$v] = $b;

	}
} 
return $a;
}

function uns2($a) {
$j=-1;
$i = strpos($a,'(');
if ($i === false) return uns1($a);
else { 
	$count=1;
	$j = $i;
	while ($count > 0) {
		$i++;
		if ($a[$i] == '(') $count++;
		if ($a[$i] == ')') $count--;
	} 
	if ($j == 0) {
		$a1 = trim(substr($a, 1, $i-1));
		$o1 = trim(substr($a, $i+1, 4));
		$a2 = trim(substr($a, $i+5));
		$a1 = uns2($a1);
		if (!is_array($a1)) $a1=array($a1);
		if ($a2) $a2 = uns2($a2); //else $a2 =array();
		if (!is_array($a2)) $a2=array($a2);
		if ($o1 == 'AND') $out = aa($a1,$a2);
		else {
			if ($o1=='OR') $out = array_merge($a1,$a2);
			else $out = $a1;
		}
	} elseif ($j>0) {
		$a1 = trim(substr($a, 0, $j-4));
		$o1 = trim(substr($a, $j-4,4));
		$a2 = trim(substr($a,$j));
		$a1 = uns2($a1);
		if (!is_array($a1)) $a1=array($a1);
		$a2 = uns2($a2);
		if (!is_array($a2)) $a1=array($a2);
		if ($o1 == 'AND') $out = aa($a1,$a2);
		else {
			if ($o1=='OR') $out = array_merge($a1,$a2);
			else $out = $a1;
		}
	}
}
return $out;
}

$d = '(as OR df)';
$b='value1 AND value2 OR (value3 AND value4)';
$a = '(value1 AND value3) OR value4 AND (value5 OR value6) AND value7';
$c = 'value1 AND (value3 OR value4 AND (value5 OR value6) AND value7)';

$x = uns2($a);
print_r($x);

echo "\n\n";
$x = uns2($c);
print_r($x);
?>

[[SOLVED] Variable Variable name]

try

<?php
$a1 = 'sasa';
$a2 ='bls';
$a3 = 'asdf';
for ($i=1; $i<4; $i++) echo ${'a'.$i},"<br />\n";
?>

[[SOLVED] Problems Unserializing a non standard serialized array]

try

<?php
$a = 'value1 AND value2 AND (value3 OR value4 AND (value5 OR value6) AND value7)';
$a = str_replace(array('(',')'), '', $a);
$b = explode(' AND ', $a);
$o = '';
for ($i = count($b)-1; $i >= 0; $i--) {
$tmp = explode(' OR ', $b[$i]);
if ($o){
	$q = $o;
	$o = array();
	foreach ($tmp as $x) $o[$x] = $q;

} else $o = $tmp;
}
print_r($o);
?>

[$_POST help]

try

$check = $_POST[$value_of_parent['qName']][$key_of_child]

[syntax error with mysql_query("CREATE TABLE...]

you forget ) in the end

must be

...

whyjoin VARCHAR(250))")

[Coding problem,please help]

try

<?php session_start(); ?>
<form method="POST">
<input type="text" name="id">
<input type="submit" value="add" name="action">
<input type="submit" value="clear cart" name="action">
</form>

<?php
if ($_POST['action'] == 'clear cart') unset($_SESSION['cart']);
if (isset($_POST['action']) and $_POST['action'] == 'add') {
$id = $_POST['id'];
if ($_SESSION['cart'] and $id) {
	if (!in_array($id, $_SESSION['cart'])) $_SESSION['cart'][]=$id; 
	else echo 'you already order the book!<br />'; 
} elseif ($id) $_SESSION['cart']= array($id); else echo 'no book <br />';
}
echo 'In your card is: <br />';
if ($_SESSION['cart']) foreach ($_SESSION['cart'] as $a) echo $a,'<br />';
?>