Search DaniWeb - depends

'AI Is Expected to Transform the Role of Controllers & Analysts ' 2 Weeks Ago by Johannes C. …? ## Whether AI will have a net positive impact on society **depends on how its development and deployment is managed**. If governed… Re: Which programming language is best Ludo game development? 3 Weeks Ago by kishanrg … developing a Ludo game, the choice of programming language largely depends on your familiarity with the language and the platforms you…, the "best" programming language for Ludo game development depends on your specific requirements, target platforms, and your proficiency with… Re: 'AI Is Expected to Transform the Role of Controllers & Analysts ' 2 Weeks Ago by Dani Which of the two actually answered the questions? Re: 'AI Is Expected to Transform the Role of Controllers & Analysts ' 1 Week Ago by Dani I think it’s much more authentic and useful to have direct quotes. Paraphrasing loses a lot in translation IMHO. Re: Do you think Google is doing a good job as a search engine? 2 Months Ago by mathanm I believe that each search engine has its strengths and weaknesses. Google, for example, is known for its vast dataset and sophisticated algorithms, while DuckDuckGo focuses on privacy and unbiased results. Ultimately, the "best" search engine depends on your individual needs and preferences. Re: What is most effective social media platform for paid campaign? 2 Months Ago by Naseem_3 I am a digital marketing strategist The "best" platform for using paid ads depends on various factors such as your target audience, your marketing objectives, and your budget. for me, it will be Facebook, Instagram, Twitter and LinkedIn. these are the platforms that make high traffic. Re: What is most effective social media platform for paid campaign? 2 Months Ago by Deftsoft … comes to paid social media campaigns, the most effective platform depends on your target audience, goals, and industry. However, currently, Facebook… Re: How many users return to your site? 2 Months Ago by Dani It really depends on the specific niche of the website. However, from my … Re: Which is the best SEO tool used to track exact ranking? 1 Month Ago by KomalBhatt … in the market ranging from unpaid to paid services. It depends upon your business needs and your budget. Here I've… Re: How can I upload a tar.bz2 file to openstack swift object storage container 1 Month Ago by Salem ….tar.bz2', contents=file, content_type='application/octet-stream' ) It kinda depends on what `swift_conn.put_object` does with `content_type`. Re: What is most effective social media platform for paid campaign? 1 Month Ago by AndyBeohar The best platform for paid campaigns depends on your target audience, industry, and campaign goals. However, Facebook and Google Ads are preferred by many marketers due to their extensive audience targeting capabilities and proven effectiveness for various businesses. Re: Improve HAVING BY performance 1 Month Ago by Dani … is faster for a use case. Even then, it totally depends on the data in the database itself. The same query… change cell color with depends on variable 10 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 17 Years Ago by JANINE depends on who makes your motherboard though. Dell especially are quite … Re: change cell color with depends on variable 10 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 10 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 10 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 10 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 10 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 10 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 10 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 10 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 10 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 10 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 10 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 10 Years Ago by diafol OK, give me 10 minutes while I try to replicate... Re: change cell color with depends on variable 10 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 10 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 10 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 10 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` …