I HATE TIMESTAMPS!! save me...

[vent]

really don't understand. i can put the date into the form fine
it looks like this= _20030513161609 and the field is called "date" i have looked through all search results. does anyone know of a simple code that will format this? YYYY-MM-DD? that's all i need but it just goes wrong everytime. if i put my code in here could someone show me where to put what?

many thanks if you can.

<?

include("../conf.php");
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
mysql_select_db($db) or die ("Unable to select database!");

$query = "SELECT id, function, date, title, copy, link, image_ref FROM $tablename ORDER BY date DESC";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
$row = mysql_fetch_array($result);

while($row = @mysql_fetch_array($result)){
$id = $row['id'];
$function = $row['function'];
$date = $row['date'];
$title = $row['title'];
$copy = $row['copy'];
$flycopy = substr($copy, 0, 100);
$link = $row['link'];
$image_ref = $row['image_ref'];

$display_block .= "$title<br>
$flycopy<a href=\"story1.php?tablename=talent_feat&id=$id \"target=\"content\">...more</a><br>$date
<br><br>";ery
}
print "<B>$tablename</B> <a href=\"gelzine_html.php\">back</a><BR>";
echo "$display_block";
?>

dan

[bernouli]

function convert_time($mysql_timestamp){
// YYYYMMDDHHMMSS

//this should be in one line, i think...
if (ereg("^([0-9]{4})([0-9]{2})([0-9]{2})([0-9]{2})
          ([0-9]{2})([0-9]{2})",$mysql_timestamp,$res)):

$year=$res[1];
 $month=$res[2];
 $day=$res[3];
$hour=$res[4];
 $min=$res[5];
 $sec=$res[6];

return(array($year,$month,$day,$hour,$min,$sec));
 else:
    return(false);
endif;
}

[vent]

thats great, i sort of had all that already, but keep getting errors.
http://www.gelphoto.com/geluk/html/
click on gel.zine.

where do i put that code? i put it into a functionstwo.php, but how would i put it into the display block?

i get problems on the else line

<?
function convert_time($mysql_timestamp){
if(ereg("^{([0-9]{4})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})",$mysql_timestamp,$res));}
$year=$res[1];
$month=$res[2];
$day=$res[3];
$hour=$res[4];
$min=$res[5];
$sec=$res[6];
return(array($year,$month,$day,$hour,$min,$sec));
else:
____return(false);
endif;

}

?>else

[bernouli]

there is nothing on the page

[vent]

link works fine here?
http://www.gelphoto.com/geluk/html/index.html

try this...

[vent]

ok. i've got it doing something, but it just come up with "Array" instead of a date. do i need to specify my $date field anywhere?

<?

function convert_time($date ){
if(ereg("^{([0-9]{4})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})",$date} ,$res));
$year=$res[1];
$month=$res[2];
$day=$res[3];
$hour=$res[4];
$min=$res[5];
$sec=$res[6];
return(array($year,$month,$day,$hour,$min,$sec));
}
?>
is this right? and what is $res?

many thanks.

[bernouli]

so what is the problem?
there is only one else, no other else outside the function.

example

<?php
function convert_time($mysql_timestamp){
// YYYYMMDDHHMMSS

//this should be in one line, i think...
if (ereg("^([0-9]{4})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})",$mysql_timestamp,$res)):

$year=$res[1];
 $month=$res[2];
 $day=$res[3];
$hour=$res[4];
 $min=$res[5];
 $sec=$res[6];

return(array($year,$month,$day,$hour,$min,$sec));
 else:
    return("false");
endif;
}

$str = "20030513161609";
$a = convert_time($str);


echo $a[0]."-".$a[1]."-".$a[2];
?>

[vent]

i keep getting=
Parse error: parse error, unexpected T_ELSE in /var/www/gelpho/htdocs/geluk/functionstwo.php on line 12

something wrong with the 'else' bit. i think its getting there though. its making a little more sense anyway.

why does print array instead of the array?

[bernouli]

what have you done?
did you copy and paste the codes i gave you?

what is in your script? you won't get any error, if you copy and paste my codes

[vent]

i did cut and paste. didn't change anything. only way i could get it stop erroring was if i removed

else:
___return("false");
endif;
}
$str="20030513161609";
$a=convert_time($str);
echo$a[0]."-".$a[1]."-".$a[2];

this doesn't print any errors, but makes the word array appear instead of the date:

<?
function convert_time($mysql_timestamp){
if(ereg("^{([0-9]{4})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})",$mysql_timestamp,$res));}
$year=$res[1];
$month=$res[2];
$day=$res[3];
$hour=$res[4];
$min=$res[5];
$sec=$res[6];
return(array($year,$month,$day,$hour,$min,$sec));
}
?>

do i not have to mention what field in the Table the timestamp($date) is kept?

thanks or your help by the way.

[bernouli]

I tried your last code, it gave me what i will

<?php
function convert_time($mysql_timestamp){ 
if(ereg("^([0-9]{4})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})",$mysql_timestamp,$res)); 
$year=$res[1]; 
$month=$res[2]; 
$day=$res[3]; 
$hour=$res[4]; 
$min=$res[5]; 
$sec=$res[6]; 
return(array($year,$month,$day,$hour,$min,$sec)); 
} 

$str = "20030513161609"; 
$a = convert_time($str); 
echo $a[0]."-".$a[1]."-".$a[2]; 
?> 

can you give me your complete codes btw to have a see?

[vent]

function code=
<?
function convert_time($mysql_timestamp){
if(ereg("^{([0-9]{4})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})",$mysql_timestamp,$res));}
$year=$res[1];
$month=$res[2];
$day=$res[3];
$hour=$res[4];
$min=$res[5];
$sec=$res[6];
return(array($year,$month,$day,$hour,$min,$sec));
}
?>

want to display date in the display block. it all works fine, just need the date thing doin!!!
<?
include("../conf.php");
include("functionstwo.php");
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
mysql_select_db($db) or die ("Unable to select database!");

$query = "SELECT id, function, date, title, copy, link, image_ref FROM $tablename ORDER BY date DESC";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
$row = mysql_fetch_array($result);

while($row = @mysql_fetch_array($result)){
$id = $row['id'];
$function = $row['function'];
$date = convert_time($mysql_timestamp);
$title = $row['title'];
$copy = $row['copy'];
$flycopy = substr($copy, 0, 100);
$link = $row['link'];
$image_ref = $row['image_ref'];

$display_block .= "$title<br>
$flycopy<a href=\"story1.php?tablename=$tablename&id=$id \"target=\"content\">...more</a><br>$date
<br><br>";
}
print "<B>$tablename</B> <a href=\"gelzine_html.php\">back</a><BR>";
echo "$display_block";
?>

manythanks
dan.

[bernouli]

it should be

$date = convert_time($row['date']);

everywhere it should be

$display_block .= "$title<br> 
$flycopy<a href=\"story1.php?tablename=$tablename&id=$id \"target=\"content\">...more</a><br>$date[0]-$date[1]-$date[2]
<br><br>"; 

[suntra]

If it's a normal timestamp, why don't you simply use the date() function ?

$strDate = date("Y-m-d", $timestamp);
// $timestamp is the variable containing the timestamp.

[vent]

im sorry, but its still coming up with an error from functiontwo.php
it ddoesn't like =
return(array($year,$month,$day,$hour,$min,$sec));
anymore,
and its never liked any of these.
$str="20030513161609";
$a=convert_time($str);
echo$a[0]."-".$a[1]."-".$a[2];

this is the error.
Fatal error: Call to undefined function: _convert_time() in /var/www/gelpho/htdocs/geluk/archive2.php on line 17

does all of the code have to be in the function brackets?

do you hate me?

[bernouli]

did you forget to include(/path/to/functiontwo.php) in every page?

do you hate me?

: = )

[vent]

coz i'm a bad newbie. i don't know where that would go, or how to refer to it in the displayblock. This site is full of loads of help and everyone has there own way of explaining things whch can sometimes just make it more confusing.

so where would that go?

[bernouli]

ok, here we go
assuming this is your story1.php

<? 
include("../conf.php"); 
include("functionstwo.php"); 
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!"); 
mysql_select_db($db) or die ("Unable to select database!"); 

$query = "SELECT id, function, date, title, copy, link, image_ref FROM $tablename ORDER BY date DESC"; 
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error()); 
$row = mysql_fetch_array($result); 

while($row = @mysql_fetch_array($result)){ 
$id = $row['id']; 
$function = $row['function']; 
$date = convert_time($row['date']);
$title = $row['title']; 
$copy = $row['copy']; 
$flycopy = substr($copy, 0, 100); 
$link = $row['link']; 
$image_ref = $row['image_ref']; 

$display_block .= "$title<br> 
$flycopy<a href=\"story1.php?tablename=$tablename&id=$id \"target=\"content\">...more</a><br>$date[0]-$date[1]-$date[2]
<br><br>";
} 
print "<B>$tablename</B> <a href=\"gelzine_html.php\">back</a><BR>"; 
echo "$display_block"; 
?> 

you should put

<?php include("functionstwo.php"); ?>

at the top of your archive2.php, assuming that your functionstwo.php is in geluk directory

and don't forget to change all the

$date = convert_time($row['date']);

and

$flycopy<a href=\"story1.php?tablename=$tablename&id=$id \"target=\"content\">...more</a><br>$date[0]-$date[1]-$date[2]
<br><br>";

everywhere both in story1.php and archive2.php

[vent]

y. it does see it cos i have a styl sheet on it that works fine. they are definetely talling, but just a few errors. it is close.

Fatal error: Call to undefined function: _convert_time() in /var/www/gelpho/htdocs/geluk/archive2.php on line 17

which is this line=
$date=convert_time($row['date']);

[bernouli]

can you paste your archieve2.php here?
and story1.php