blueman378

August 30, 2010

Not bad for a first attempt.

Thought #1

add some more colour.

even if it is just a solid black background that spans 100% wide and contains this info(in white text):

DAVID'S PHOTOGRAPHY

Sydney Australia

***@***.com

Thought #2

The font is fine for your contact info, and maybe even the footer.

But i would not suggest using it for your menu.

Thought #3

Shrink the size of the text on your footer.

a footer is meant to be noticeable, but not dominant

August 30, 2010

Thankyou for your vote ProjectFear.

The map was actually just a test of floats in the right column,

It will not be in the final design.

August 29, 2010

Hi there.

Please vote on the design you like the most:

1: http://haloarchives.webspirited.com

2: http://webspirited.com/ha2/

Please use the following syntax

[Vote]: 1

[Reason]: Shiny Stuff!

Posted February 4, 2010 · February 4, 2010

cheers, both answers are very close to what i need, except,

the previous reply will do an estimate of the days as it simply divides the number of days between two dates by 7 and rounds it to 0 decimal places, so if the date given starts on a tuesday it will consider a monday exists. i need the literal count.

Posted February 2, 2010 · February 2, 2010

Hi there,

Is it possible to count the number of times a monday appears in a date range,

so eg you pass in 2009-01-01 and 2010-12-31

it should spit out a number which is the number of times monday appears in that range.

also,

is it possible to have the return value of one column be accessible via a simple variable,

i ask because i have something like:

SELECT
SUM(
IF(e.eatin_monday_status,1,
IF(p.pickup_monday_status,1,
IF(d.delivery_monday_status,1,0)))+

IF(e.eatin_tuesday_status,1,
IF(p.pickup_tuesday_status,1,
IF(d.delivery_tuesday_status,1,0)))+

IF(e.eatin_wednesday_status,1,
IF(p.pickup_wednesday_status,1,
IF(d.delivery_wednesday_status,1,0)))+

IF(e.eatin_thursday_status,1,
IF(p.pickup_thursday_status,1,
IF(d.delivery_thursday_status,1,0)))+

IF(e.eatin_friday_status,1,
IF(p.pickup_friday_status,1,
IF(d.delivery_friday_status,1,0)))+

IF(e.eatin_saturday_status,1,
IF(p.pickup_saturday_status,1,
IF(d.delivery_saturday_status,1,0)))+

IF(e.eatin_sunday_status,1,
IF(p.pickup_sunday_status,1,
IF(d.delivery_sunday_status,1,0)))) as openweekly

FROM
location_hours_eatin e
LEFT JOIN
location_hours_pickup p
ON e.eatin_locationid = p.pickup_locationid
LEFT JOIN
location_hours_delivery d
ON e.eatin_locationid = d.delivery_locationid
WHERE e.eatin_locationid = 6;

and dont want to have to repeat that every time i want to use the value, i want to be able to go eg

SELECT
SET @days_open = SUM(
IF(e.eatin_monday_status,1,
IF(p.pickup_monday_status,1,
IF(d.delivery_monday_status,1,0)))+

IF(e.eatin_tuesday_status,1,
IF(p.pickup_tuesday_status,1,
IF(d.delivery_tuesday_status,1,0)))+

IF(e.eatin_wednesday_status,1,
IF(p.pickup_wednesday_status,1,
IF(d.delivery_wednesday_status,1,0)))+

IF(e.eatin_thursday_status,1,
IF(p.pickup_thursday_status,1,
IF(d.delivery_thursday_status,1,0)))+

IF(e.eatin_friday_status,1,
IF(p.pickup_friday_status,1,
IF(d.delivery_friday_status,1,0)))+

IF(e.eatin_saturday_status,1,
IF(p.pickup_saturday_status,1,
IF(d.delivery_saturday_status,1,0)))+

IF(e.eatin_sunday_status,1,
IF(p.pickup_sunday_status,1,
IF(d.delivery_sunday_status,1,0)))) as openweekly,
e.eatin_thursday_total/@days_open as thursday_total

FROM
location_hours_eatin e
LEFT JOIN
location_hours_pickup p
ON e.eatin_locationid = p.pickup_locationid
LEFT JOIN
location_hours_delivery d
ON e.eatin_locationid = d.delivery_locationid
WHERE e.eatin_locationid = 6;

is this possible?

January 27, 2010

ok, im not sure if i should get this topic moved to the sql section or not now,

but im almost there,

my query is

SELECT Week(order_date), Min(order_date), Max(order_date), Sum(order_amount), count(order_amount)
FROM order_main
WHERE location_id='6'
AND order_date BETWEEN '2010-01-01' AND '2010-01-26'
GROUP BY week(order_date);

now the only thing i have left to do is,

where is has "Min(order_date), Max(order_date)"

i need to wrap them in something like

Monday(Min(order_date)), Sunday(Max(order_date))

ie, i need to get the date of the monday of the week of the date contained in Min(order_date)

and the sunday for Max(order_date)

are there functions to do this or will i have to do this php side?

January 26, 2010

Hi PFMaBiSmAd,

Thanks for your reply,

i've been looking into this but im not to quite to sure how i would go about it.

Am i

a) creating the date ranges and grabbing all the data that is between those two dates and summing those,

then running it on the next seven day period?

eg


function groupByWeek($date,$date2)
{
    $dates = Array();

    $date1 = new DateTime($date);
    
    //isBetween is defined somewhere else
    //Start date, End date, Date to check
    while(isBetween($date,$date2,$date)
    {
        $dateTemp = $date->modify('+6 days');
        $range = "$date1."-".$dateTemp";

        $query = "SELECT order_amount, SUM(order_amount) FROM order_mian order_date WHERE order_date BETWEEN '$date' AND '$date2'"; 
        $result = mysql_query($query);

        $row =  mysql_fetch_array($result);

        $dates[$range]['sum'] = $row['SUM(order_amount)'];
        $date1 = $date->modify('+7 days');
    }

    return $dates;
}

i dont even know if that will work, but am i doing that,

or can i do something like

$query = "SELECT order_amount, FROM order_main GROUP BY[ order_date WHERE order_date BETWEEN '$date' AND '$date2']";

the latter would be the best i believe.

January 26, 2010

Hi there guys,

Well,

I am givin an array in a format something like below,

my issue is i must sort it in two differnt formats,

one is monday-sunday groupings

the other is simply 7 day groupings

eg from 2009-12-01

till 2009-12-07

and end up with an array like

$sales[2009-12-01 2009-12-07][quantity] = 15

$sales[2009-12-01 2009-12-07][sales] = 2500

$sales[2009-12-01 2009-12-07][quantity] = 15

$sales[2009-12-01 2009-12-07][sales] = 2500

so for each sales that fits in each group, i must increment quantity by 1, and also add the order_amount to sales.

please set me on the right track and i will work the rest.

regards,

Matt

January 20, 2010

Cheers guys, works perfect.

January 20, 2010

Hi guys,

I'm looking to loop over a date range,

eg

$date = '15/03/1991';
$date2 = '21/07/2009';
$array = array();
while($date <= $date2)
{
    $array[$date]['value'] = 'somedata';
    $date.adddays(1);
}

obviously i know this is not going to work,

but other than nested loops and constant date checking for days in month/ leap year ect is there any way to do this?

regards,

Matt

January 8, 2010

http://www.nanoimg.com/help.html

Will my submissions ever get delete?

should be

Will my submissions ever get deleted?

January 5, 2010

cheers, works perfect.

January 4, 2010

Hi guys,

Is there a simple way to eg

if(18:30 > 07:30)

echo "correct";

obviously i know this wont work.

but is there a function to do it or will i have to explode it on : and then compare the hours, if they are equal then compare the minutes?

January 4, 2010

You could do it a slightly more persistent way, allow poeple to tag photos with only one tag, kindof like a username style thing except it doesnt require signup, nor a password

January 3, 2010

Right, well you are on the right track... sortof

Now you need to look into ajax,

as you will need to run that query every time a user wants to check if the username is avaliable.

January 2, 2010

Well,

Post your attempt at it and we will help you.

Expect us to do it for you and we will not.

January 2, 2010

Um ok...

So is this a question or a statement?

January 2, 2010

A few things i've noticed

Error Page

No [back] link. Unless a user navigates backwards they are stuck.

This is a bad idea

Some errors reference error.html which is working

however some, such as file not found reference error.php which does not exist.

Resize to

Im not sure if this is an issue, but

if i upload say a 100x100 image and tell it to resize to 640x480 as an example then no error message is displayed.

possibly a

"The resize scale you have chosen is larger than the image, no resize will occur

[continue upload] [cancel]"

message will work well?

Edit: Uh oh: After using it it seems to be broken, did i break it?

December 12, 2009

duplicate post ? I dint understand

Cheers

Santosh

you didn't spell properly either.

Duplicate post is when you post the same topic more than once.

December 12, 2009

if you want to do it the way you do,

you will need one query to get the previous value, and then another query to update it.

why do oyu want to do it this way?

December 11, 2009

Looks ok,

Need to work on some of your spelling, eg "Screen Shuts" instead of "Screen Shots"

December 10, 2009

Hi mate,

pleased use

tags,

while($row = mysql_fetch_array($result)){
   $debit = $row['debit'];
   $credit = $row['credit'];
   $acnum = $row['acnum'];
   $query1 = "SELECT cbal FROM accounts WHERE acnum = '$acnum'";
   $res = mysql_query($query1);
   $balancenum=mysql_num_rows($res);
   while($row1 = mysql_fetch_array($res)){
      $cbal = $row1['cbal'];
   }
   If (is_numeric($debit)){
      $actype = substr($acnum,0,1);
      settype($actype, "integer");
      echo $actype;
      echo "<br>";
      echo gettype($actype);
      echo "<br>";
      If ($actype == 1 || $actype == 5 || $actype == 6 || $actype == {
         $cbal = $cbal - $debit;
         $sql2="UPDATE accounts SET cbal = '$cbal' WHERE acnum = '$acnum'";
         echo "2" . $sql2;
         echo "<br>";
         mysql_query($sql2);
      } else {
         $cbal = $cbal + $debit;
         $sql2="UPDATE accounts SET cbal = '$cbal' WHERE acnum = '$acnum'";
         echo "2". $sql2;
                  echo "<br>";
         mysql_query($sql2);
      }
   }
   If (is_numeric($credit)){
      $actype = substr($acnum,0,1);
      settype($actype, "integer");
      echo $actype;
      echo "<br>";
      echo gettype($actype);
      echo "<br>";
      If ($actype == 1 || $actype == 5 || $actype == 6 || $actype == {
         $cbal = $cbal + $credit;
         $sql="UPDATE accounts SET cbal = '$cbal' WHERE acnum = '$acnum'";
         echo $sql;
         echo "<br>";
         mysql_query($sql);
      } else {
         $cbal = $cbal - $credit;
         $sql="UPDATE accounts SET cbal = '$cbal' WHERE acnum = '$acnum'";
         echo $sql;
                  echo "<br>";
         mysql_query($sql);
      }
   }
}

December 10, 2009

where are you getting your data from?

December 10, 2009

change

$querystats = mysql_query('SELECT * FROM stats ORDER BY team_id');
$statsresult = mysql_query($querystats);

to

$querystats = "SELECT * FROM stats ORDER BY team_id";
$statsresult = mysql_query($querystats);

December 10, 2009

Dont think thats what Selva is asking, i think they want other peoples last modified, and basically if its not returned, unless its on the page somewhere i dont think you can get it!

Sign In

blueman378

Posts

Joined

Last visited

Content Type

Profiles

Forums

Posts posted by blueman378

First Ever Website

this or that?

this or that?

count mondays in date range. also user defined variables

count mondays in date range. also user defined variables

sorting data by week.

sorting data by week.

sorting data by week.

looping over daterange

looping over daterange

my image hosting site

compare time in format hh:mm

compare time in format hh:mm

my image hosting site

Live Username Availability Check

Live Username Availability Check

Help with MachForm errors

my image hosting site

Data inside table php

Help? Need help on project with templates involving mysql and php.

Update : Open soruce guestbook script

Wierd if else problem

Inserting 100x and 100y coordinates in mysql table - easy way?

Error in query: Resource id #4??

Get last modified date of web page

Browse

Activity

Important Information