Search DaniWeb - depends

Re: How Does Flutter Handle State Management Internally? 3 Weeks Ago by Temporal … complex logic but has a steeper learning curve. It really depends on the project and team, but understanding how Flutter rebuilds… Re: Is Microsoft Solutions Partner Badge Really Worth It? 1 Week Ago by Reverend Jim I have to say that I have had both terrible and outstanding results from MS support techs. It all depends on who you get. Are Cross-Platform Apps Slower Than Native? Or Is That Just a Myth in 2025? 2 Months Ago by Himadri_3 … question we still hear a lot—and honestly, the answer depends on what kind of app you're building. A few… Re: Are Cross-Platform Apps Slower Than Native? Or Is That Just a Myth in 2025? 1 Month Ago by asadalig … apps aren't inherently slower than native ones—it really depends on how they're built. Modern frameworks like Flutter, React… Re: which language do i start leaning in 2025 2 Months Ago by Dani It depends what you’d like to build. If a simple website, … Re: How to make an Iphone App? 1 Month Ago by jonathannweyer … programming language, whether it's Swift or Objective-C, really depends on your team's experience and long-term plans. Also… Re: How secure is Github? 1 Month Ago by kearawill … repository permissions. In short: GitHub can be safe, but it depends on your practices. Always assume someone could accidentally leak access… change cell color with depends on variable 11 Years Ago by trektrak … do .... I need to have changing on cell table color depends on variable.. say for example.. say for example.. if time… cmos resetting 18 Years Ago by JANINE depends on who makes your motherboard though. Dell especially are quite … Re: change cell color with depends on variable 11 Years Ago by broj1 Something like: <?php // set styles the way you want if($time < 8) { $tdStyle='background-color:green;'; } else { $tdStyle='background-color:red;'; } while($row=mysql_fetch_array($result)) { echo "</td><td style=\"$tdStyle\">"; … Re: change cell color with depends on variable 11 Years Ago by EvolutionFallen My only additional advice is to use this to set classes for your TDs instead. This way you can change the actual appearance in your stylesheet. Re: change cell color with depends on variable 11 Years Ago by trektrak Thank you guys for the feedback... it works.. Now I'm stuck with the timestamp format.. for my table, I'm using this kind of format '0000-00-00 00:00:00' .. So, how am i going to do this ? if I need to focus on the time only? Re: change cell color with depends on variable 11 Years Ago by mchourishi <?php //$time = "08:00:00"; $convert_time = strtotime($time); if($convert_time > 1383877800) { $tdStyle='background-color:green;'; } else { $tdStyle='background-color:red;'; } ?> Re: change cell color with depends on variable 11 Years Ago by diafol This is dependent on your DB date format. From what I can gather you have a timestamp or a datetime format in it. In order to get the 'time' element, you could do this in MySQL... SELECT field1,field2,TIME(datetimefield) AS timepart FROM table That way you have the `$row['timepart']` as the isolated time field. Or if the time is in timestamp… Re: change cell color with depends on variable 11 Years Ago by trektrak I am using a timestamp format within my sql... ermm.. I'm still stuck Re: change cell color with depends on variable 11 Years Ago by diafol OK, so you can use this... SELECT field1,field2,FROM_UNIXTIME(timestampfield, '%H:%i:%s') AS timepart FROM table I'll illustrate with mysql_* functions, but consider mysqli_* or PDO... $r = mysql_query("SELECT field1,field2,FROM_UNIXTIME(timestampfield, '%H:%i:%s') AS timepart FROM table"); $output = '...'; while($d… Re: change cell color with depends on variable 11 Years Ago by trektrak im so sorry .. i dont get it .. you want me to make another query out of my previous table ? Re: change cell color with depends on variable 11 Years Ago by EvolutionFallen I think diafol is suggesting you update your existing query. In your SELECT query, replace `time` with `FROM_UNIXTIME(time, '%H:%i:%s') AS time`. I'm not sure why you would need to change anything else. Re: change cell color with depends on variable 11 Years Ago by diafol The SQL was an example of what you could do - a generic example at that. It just creates a new field called timepart which contains just the time part of your timestamp - it's just a convenient vehicle for delivering that specific piece of data. Alternatively, you can use date() or the DateTime object to extract the time element of the timestamp. … Re: change cell color with depends on variable 11 Years Ago by trektrak Thanks diafol, i got a NULL... what seems to be the problem yea? Ok this is my mysql query $result = mysql_query("SELECT `members`.`full_name`,`members`.`section`,`time_in`.`time`,`time_in`.`reason` FROM members\n" . "INNER JOIN `log_time`.`time_in` ON `members`.`code` = `time_in`.`code` ORDER BY `time_in`.`time` DESC… Re: change cell color with depends on variable 11 Years Ago by diafol OK, give me 10 minutes while I try to replicate... Re: change cell color with depends on variable 11 Years Ago by diafol Here's a sample table... CREATE TABLE `timestamp2time` ( `ts_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `timest` INT(11) DEFAULT NULL, PRIMARY KEY (`ts_id`) ) ENGINE=INNODB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci Here's the data contained within... ![b996aeeed289b6bb831b1000dc474b77](/… Re: change cell color with depends on variable 11 Years Ago by trektrak for my timestamp field.. what should be the format ? should i put timestamp ? because by default.. this is the way it should be ` CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAM` Re: change cell color with depends on variable 11 Years Ago by diafol I don't know where you're going with this. The 'timestamp' **type** for a MySQL, confusingly is this format... 0000-00-00 00:00:00 But I've been using an integer (int) **type** for the MySQL field holding the unix format timestamp. So if you show the format that YOU'RE using in your current table - is it 0000-00-00 00:00:00 … Re: change cell color with depends on variable 11 Years Ago by trektrak Ok done.. Thankd diafol for the hint ..really appreaciate it.. this is what I did.. instead of using .. `TIME(FROM_UNIXTIME(timest)) AS t FROM timestamp2time` Im using `TIME(TIMESTAMP(timest)) AS t FROM timestamp2time` from there I can trim the timestamp to time only .. and I make variable out of it .. it got confuse when i used `FROM_UNIXTIME` … Re: change cell color with depends on variable 11 Years Ago by diafol Ok Solved? Re: change cell color with depends on variable 11 Years Ago by trektrak Solved tq!! Re: How Do You Promote A New Business Online? 15 Years Ago by jogkely007 Depends on your website which kind of business you are trying to promote. tactics would be different for a blog. Re: Is facebook a better platform than twitter for online promotions? 15 Years Ago by thomas1975 Depends, if you have a twitteraccount with a large number of followers you could get higher conversion rates promoting your product there. However, for advertising Facebook is a better medium than twitter (not really expensive either compared to adwords). Re: Inmates on Death Row;last meals 18 Years Ago by sk8ndestroy14 Depends on what it is.