PHP - Adding A 'where' To Array_rand

Hi  can someone please show me how I should include a Code: [Select]
<div id="css"></div> in this line
Code: [Select]
echo $AB_LANGS['CalendarInstructions'];
I have tried several attempts with no joy.

Many thanks

I am trying to add foo onto bar inside a loop so I can then echo bar outside the loop and see the sum.
The PHP manual doesn't have anything on addition in the way I need it (adding onto), so I was wondering if anyone can help me?

LOL embrace yourself!

$query = "select * from products where id='{$content['id']}'"; $result = mysql_query($query); $row = mysql_fetch_array($result);
mysql_query ($query);
mysql_close($link);
echo "
<B>Product ID:</B> {$content['id']}
<BR>
<B>Price:</B> $row[price] AUD
<BR>
<BR>
";
+$row[price] -> $total;
}
echo $total;

what is the propper way to write

Code: [Select]
$payrollweek="10";
date('Y-m-d', strtotime("+($payrollweek - 2) week $payrollend") ), "<br />";
its the ("+($payrollweek - 2)  that isnt working i think

hello.  im trying to get the following to work.  any ideas for me?

Code: [Select]
Text[12]=["Job Description","$description it "]
it is in a .js file.

I created the code below and it outputs the following number output:
1111111773526604115551144611337112281111221111345 6789101121111100352004110051100611007110081100221 1003456789101141111100352004110051100611007110081 1002211003456789101151111100352004110051100611007 1100811002211003456789101123111110035200411005110 06110071100811002211003456789101134
Anyways if you look at the code, I need to be able to add the values on a single colony, idcol, with the same type and subtype, btid/stid, generated as the $prod variable. buildings with the same subtype generate the same resource, in this case, several iron mines and a single copper mine are present, but there are also 9 other types of resource buildings. How do I collect on the prods which go together?
Code: [Select]
<?php
$dbhost = 'localhost:3306';
$dbuser = 'lordofth_aos';
$dbpass = 'flarge';
$dbname = 'lordofth_aos';
$conn = mysql_connect($dbhost,$dbuser,$dbpass)
or die ('Error connecting to mysql');
mysql_select_db($dbname);
$query="SELECT id FROM users";
$result=mysql_query($query);
$num=mysql_num_rows($result);
$i=0;
$idn=1;
while($i<$num){
$queryii="SELECT idcol FROM colony WHERE id=$idn";
$resultii=mysql_query($queryii);
$numt=mysql_num_rows($resultii);
$id=mysql_result($result, $i);
echo $id;
$ii=0;
$ibt=1;
while($ii<$numt){
$querypty="SELECT btid FROM ptypes WHERE btid=$ibt";
$resultpty=mysql_query($querypty);
$numpty=mysql_num_rows($resultpty);
$idcol=mysql_result($resultii, $ii);
echo $idcol;
$bt=0;
$btid=mysql_result($resultpty, $bt);
echo $btid;
$bte=1;
while($bt<$numpty){
$querystid="SELECT stid FROM ptypes WHERE stid=$bte";
$resultstid=mysql_query($querystid);
$numstid=mysql_num_rows($resultstid);
$st=0;
$stid=mysql_result($resultstid, $st);
echo $stid;
$ste=1;
while($st<$numstid){
$bidum=0;
$querybpid="SELECT bpid FROM blueprints WHERE btid=$btid AND stid=$stid";
$resultbpid=mysql_query($querybpid);
$numbpid=mysql_num_rows($resultbpid);
while($bidum<$numbpid){
$bidumb=0;
$bidumbg=mysql_result($resultbpid, $bidum, 'bpid');
echo $bidumbg;
$querybid="SELECT COUNT(bid) AS count, workers, efficiency 
FROM buildings
INNER JOIN blueprints ON buildings.bpid=blueprints.bpid
WHERE blueprints.btid=$btid AND blueprints.stid=$stid AND buildings.bpid=$bidumbg AND buildings.idcol=$idcol";
$resultbid=mysql_query($querybid);
$staff=mysql_result($resultbid, $bidumb, 'workers');
$effic=mysql_result($resultbid, $bidumb, 'efficiency');
$count=mysql_result($resultbid, $bidumb, 'count');
echo $staff;
echo $effic;
echo $count;
$prod=$staff*$effic*$count;
echo $prod;
$bidumb++;
$bidum++;
}
$st++;
$ste++;
}
$bt++;
$bte++;
}
$ii++;
}
$i++;
$idn++;
}
?>

I had this working before, but my coding structure has changed a bit and need help with syntax.

My function I have down ok.


function cssfrommvp($mvp) {
 $class = array('MVP' => 'MVP');
 return $class[$mvp];
}


this is how I would add the class to a <td> with $row.

Code: [Select]
echo "<td class=\"".cssfrommvp($row['mvp'])."\">".$row['mvp']."</td>\n";

now using $array


<td> . $MVP .</td>\n</tr>


how would I do the same thing as done before with $row?

When I try to add 30 days:
Code: [Select]
$date = date("Y-m-d");
$date = strtotime(date("Y-m-d", strtotime($date)) . " +30 days");
echo $date;
and I echo date I get 1330664400

How do I get it to echo out 3/1/2012?

I know the answer lies in the strtotime but I can't figure it out.  I know it's a simple problem for most of you...

hello, i have created a table that desplays perticulars, price per person and number of people. the fees is then calculated by multiplying price per person with number of people. till now everything is good. but the problem is when i try to calculate the total fees.
here is an example to explain you better:
Perticulars Price Per Person Number of people Amount something 10 100 1000 something else 20 100 2000 Total 3000

Code: [Select]
$pert_query = mysql_query ("SELECT * FROM `perticulars` WHERE `invoice` =$invoice") or die(mysql_error());
$i = 1;
$sum = 0 + $_SESSION['sum'];
while($perticulars = mysql_fetch_array($pert_query, MYSQL_ASSOC)) {
?>
<tr>
      <td style="border-collapse: collapse"><div align="center"><?php echo $i;
  $i++; 
   ?></div></td>
      <td style="border-collapse: collapse"><div align="center"><?php echo $perticulars['perticulars']; ?></div></td>
      <td style="border-collapse: collapse"><div align="center"><?php echo $perticulars['ppc']; ?></div></td>
      <td style="border-collapse: collapse"><div align="center"><?php echo $perticulars['nop']; ?></div></td>
      <td style="border-collapse: collapse"><div align="center">
        <?php $amount = $perticulars['ppc'] * $perticulars['nop']; echo $amount; $_SESSION['sum'] = $sum+$amount;?>
      </div></td>
    </tr><?php 
} ?>
    <tr>
      <td colspan="4" style="border-collapse: collapse"><div align="center">Total</div></td>
      <td style="border-collapse: collapse"><div align="center"><?php echo $sum; ?></div></td>
    </tr>
  </table>
From the above code you can see that i am getting the amount form $amount = $perticulars['ppc'] * $perticulars['nop'];
by this each row has its own amount which i got by multiplying the data from mysql.
the problem is how do i find out the Total. i know i am suppose to add up $amount but how?
i even tired using sessions to store the amount and add the new amount to get total but the problem in using sessions is it messes up my next page, no using session is a very bad idea.

I have seen somewhere that you can add to a string like so

$var = "text";


or


$string ="var";
&$var = "text";

it is the latter that I am wanting to know more about.

nevermind.

How can i keep adding value to a session???

I need to somehow keep storing more values into an array.
session_start();

// store session data
$_SESSION['tune_name']=$_GET['tune_name'];
$_SESSION['tune']=$_GET['tune'];

print_r($_SESSION);

So this is what i get from the print_r();
Array ( [attach] => Array ( ) [backups-2] => true [dnb] => true [house] => true [tech-house] => true [uk-garage] => true [uk-grime] => true [uk-hip-hop] => true [uncategorized] => true [warehouse] => true [views] => Music/dnb/Gold Dust (Vocal VIP Mix)_DJ Fresh_192.mp3 [tune_name] => Music/dnb/Dj Ss - We Came To Entertain (Sub Zero Remix).mp3 [tune] => Array ( ) )

ok what i need to do is everytime i click it saves that value above but just appends another value to the array so the session can keep getting larger and larger???

Any help please.

Howdy All i currently have Code: [Select]
<? echo $guild ['name'];?> and i want to put <> around what is shown from the $guild ['name'] , but where ever i try the <> it cancels out and just doesnt show the name any more - currently its making us do the following <-<? echo $guild ['name'];?>-> as even if we try an echo with jsut the < and > it cancels it out

Any specific way in which i can do this

thanks

i dont get whats wrong i does not add to the db

Code: [Select]
<?php

if($_POST['submitbtn']){

require "scripts/connect.php";

$title = mysql_real_escape_string($_POST['title']);
$by = mysql_real_escape_string($_POST['by']);
$body = mysql_real_escape_string($_POST['body']);

if ($title && $by && $body){

$query = mysql_query("INSERT INTO news (title, by, body)VALUES('$title', '$by', '$body')");

echo "ADD SUCCESFULLY!";

}else
   $msg = "<font color=red>YOU DID NOT FILL ALL OF THEM IN!</font>";
}

?>

Hi

I currently pass a URL to our website as follows: http://website.com/?nid=10 but want to extend this to include a keyword from google as well. For example http://website.com/?nid=10&kw={keyword}. However it may not always have a keyword so if it does not it needs to just use the nid array.

This is the current script, how do I go about changing it so that if it just contains a nid and no keyword it will do one search of the array and return the result, and if it does have a nid&keywordod it returns something different.

For example if it had nid=1 it would return 0844 000 0300 and if it had nid=1&kw=help it would return 0844 000 0350

Thats what I am looking to achieve. Is this possible and how do I change the array. I have had a little attempt but not sure what I am doing and just got coding errors.


<?php 
$GLOBALS['ct_get_parameter_name'] = 'nid'; 
$GLOBALS['ct_default_number_id'] = 0; 

// source_id => phone number 
$GLOBALS['numbers'] = array( 
    0 => '0844 000 3000', 
    1 => '0844 000 0300', 
    2 => '0844 000 0301', 
    3 => '0844 000 0302', 
); 
session_start(); 

if (array_key_exists($GLOBALS['ct_get_parameter_name'], $_REQUEST)) 
{ 
    $_SESSION['ct_source'] = $_REQUEST[$GLOBALS['ct_get_parameter_name']]; 
} 

function get_phone_number() 
{ 
    $numbers =& $GLOBALS['numbers']; 
    $default_number_id = $GLOBALS['ct_default_number_id']; 
     
    if (isset($_SESSION['ct_source'])) 
    { 
        if (array_key_exists($_SESSION['ct_source'], $numbers)) 
        { 
            return $numbers[$_SESSION['ct_source']]; 
        } 
        else 
        { 
            // otherwise return first number 
            return $numbers[$default_number_id]; 
        } 
    } 
    else 
    { 
        // return first number 
        return $numbers[$default_number_id]; 
    } 
} 
?> 




Many thanks in advance.

Roy

Hi.

I have a list of prices in my database - I.E:

NAME ------------  PRICE
-----------------------------
APPLE ------------- 1.00
PEAR --------------- 1.00
BANANA ----------- 1.92
-----------------------------

in php i want to add the tables data together to show a total price for that columns data.

I.E:

Total cost: 3.92

How on earth do I do this? :S!

Many Thanks