grr Last Bred

[SilverDragonTears]

ooo I think i got it...

PHP Code:


if($lastbred == '') {
    $article_content .= '';
} 
else if($lastbred == '0') {
    $article_content .= '';
} else {
    $article_content .= 'Last bred: '.date('Y-m-d', $lastbred).'<br>
           '.date('Y-m-d', time()). '<br>';

} 


But the adults that have bred are still printing out two dates so remove the second date echo?

[Chibi_Chicken]

$lastbred will need to be assigned a value. this value is going to come from the DB owned_adoptables lastbred column. So I am not sure where you are putting this but one way you can do it is.

PHP Code:

//you will need to supply the $id of the adoptable
$result = runquery("SELECT * FROM ".$prefix."owned_adoptables WHERE aid = '$id'") ;
$lastbred = @mysql_result($result,0,'lastbred');
//now display the results
if($lastbred == '') {
    $article_content .= '';
} else {
    $article_content .= 'Last bred: '.date('Y-m-d', $lastbred).'<br>';
    //i took out the second one unless you wanted to show the current day.
} 


Their is a couple of problems with this. if the script is looping $result and you run this it will break the code, second this is a waste of resources if you all ready have the information you need from another $result you dont need to run another sql request. It will slow the site down.

I hope I am explaining this clearly If you want, what php page are you trying to add this in to, I can test it out latter when I am at work and see if I can make better sense of it.
ATM I am kinda of distracted with Terraria ^.^;

[SilverDragonTears]

LoL I kept posting so I think you missed mine... I think I got it =p
This:

PHP Code:


if($lastbred == '') {
    $article_content .= '';
} 
else if($lastbred == '0') {
    $article_content .= '';
} else {
    $article_content .= 'Last bred: '.date('Y-m-d', $lastbred).'<br>';

} 


Seems to be working well! Wouldn't have been able to do it without your help though =) Thank you.

This is completely unrelated to this issue...
But I added in Date Caught/Bred and the ones that were already caught or bred before this was added have no dates. Is there an easy way to insert into the database a default date for those who don't have one?

[Chibi_Chicken]

You are welcome. :)

you can run something like
UPDATE table SET Date Caught/Bred = '0' WHERE Date Caught/Bred = ''

[SilverDragonTears]

do I do that in the phpadmin panel?

[SilverDragonTears]

uh oh... i did this

UPDATE `adopts_owned_adoptables` SET `date`=2011-08-10 WHERE date=0000-00-00

and it put 1993 in there LOL

Shoot I keep double posting =( Sorry guys!!

Got it =) It was
UPDATE adopts_owned_adoptables
SET date='2011-08-10'
WHERE date='1993'

[Chibi_Chicken]

that is cool that you got it working. :)
question in your DB what type is date is it a varchar or date format, and when comparing dates in php do you have to do anything special?

[SilverDragonTears]

it's varchar... and not sure I understand the second question

[Chibi_Chicken]

well I just wonder what would happen when you compare $date with $currentdate

like $date = '2010-08-10'
$currentdate = '2011-08-11'

if $date < $currentdate
"your adopt is able to do something"

I guess what I am confused about is how comparing strings work, because php doesnt know that tho two variables are dates, or at least I dont think it knows.
I will have to look in to it.