Mysidia Adoptables Support Forum

Mysidia Adoptables Support Forum (http://www.mysidiaadoptables.com/forum/index.php)

- Questions and Supports (http://www.mysidiaadoptables.com/forum/forumdisplay.php?f=18)

- - grr Last Bred (http://www.mysidiaadoptables.com/forum/showthread.php?t=2284)

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?

$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 :el: 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 ^.^;

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?

You are welcome. :)

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

do I do that in the phpadmin panel?

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'

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?

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

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.