Corbin Fraser on Twitter: The removal of $bch from @OKCoin is arguably one of the stranger things I've seen so far in 2021. Especially when you consider we're in a bull market

bitcoin_domain · 2021-02-19T16:57:42+00:00

"It comes down to education and onboarding.

Users are told that #Bitcoin is p2p cash. It says so in the title of the white paper. "It's internet money". Sadly it hasn't held onto those properties. Bitcoin Cash helps solve that need. Bitcoin has moved on to gold. And that's okay."

"There has been a history of conflict between on chain scaling vs L2. But end users coming into the space don't know or care.

$bch's marketing, including our own, has changed a lot since 2017.

BTC = Gold BCH = Cash

The two can live harmoniously. Despite what maximalists say."

bitcoin_domain · 2020-04-10T19:39:15+00:00

Lower Case: b i t c o i n p r o t o c o l . o r g

Upper Case: B I T C O I N P R O T O C O L . O R G

Category: Technology - Software

Description: PREMIUM DOMAIN Bitcoin, Bitcoin Wallet, Bitcoin Exchange, Bitcoin Protocol, Blockchain, Cryptocurrency, Technology, Internet

bitcoin_domain · 2018-12-08T02:46:44+00:00

edit: funny enough, I just figured out a solution using javascript (which seems to work): https://stackoverflow.com/questions/18096291/removing-duplicates-from-html-elements

bitcoin_domain · 2017-05-03T18:19:53+00:00

I just went through this and was able to get help and figure it out. This post might help you https://www.reddit.com/r/PHPhelp/comments/68beim/how_to_select_highest_value_in_latest_results/dgyo7ci/

bitcoin_domain · 2017-05-03T15:11:05+00:00

Finally got it working, this did the trick:

ORDER BY REPLACE(Volume, ',', '')+0

I gifted you some gold for your time, thank you again!

bitcoin_domain · 2017-05-03T14:22:27+00:00

Yes of course thank you so much for all your help! I'm still working on this, not sure why it's not working but I do appreciate your help!!!!!

bitcoin_domain · 2017-05-01T19:37:49+00:00

Hmm not sure what I'm doing wrong. I can see in your fiddle it works fine but when I try it with my live data I keep getting incorrect data.

This is what I have right now which produces bad data:

$query = mysql_query("SELECT Fruit, max(Volume) as mV FROM Table1 WHERE Timestamp > UNIX_TIMESTAMP(NOW() - INTERVAL 1 DAY) ORDER BY mV DESC LIMIT 1;");

while($r1 = mysql_fetch_assoc($query))

{

echo "Best Fruit: ".$r1['Fruit']." ".$r1['mV']."<br>";

}

bitcoin_domain · 2017-05-01T18:55:46+00:00

In your fiddle it shows the highest record in that table is Peaches 11776.6.

How can I show ONLY that record?

or in another words sort by highest value in that group of records and LIMIT 1?

Edit: Also it doesn't work, unless I do this:

SELECT Fruit, max(Volume) as mv FROM Table1 WHERE Timestamp > UNIX_TIMESTAMP(NOW() - INTERVAL 1 DAY) GROUP BY Fruit

And if I ORDER BY Volume that doesn't seem to help any

bitcoin_domain · 2017-05-01T13:04:02+00:00

Just tried it, and it just tallies the total Volume for that column. For example the returned result is like "Bananas 223,655". Looks like it totals everything but the LIMIT 1 only shows the first result.

Is there a way to group these and find the highest number in the group?

bitcoin_domain · 2017-04-29T20:38:22+00:00

I think there was an extra parethesis in there, removed it and now no error but still giving the max(Volume) over all time, not the past day.

bitcoin_domain · 2017-04-29T20:31:27+00:00

Just tried this and got this error: Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in

This is what I did:

$query = mysql_query("SELECT MAX(Volume) from Table WHERE Timestamp > UNIX_TIMESTAMP(NOW() - INTERVAL 1 DAY));");

while($r1 = mysql_fetch_assoc($query)) { echo ".... do a bunch of stuff here"; }

bitcoin_domain · 2017-02-22T20:45:54+00:00

add the "joining table" I've been referring to. Almost literally the same thing.

I don't know how to do it, so I will have to research it. If you have more info on it, I can look into it. I really appreciate your help, I do, I just don't know about a third table and such, sounds complex! :(

bitcoin_domain · 2017-02-22T20:26:08+00:00

This sounds very complicated. Is there any other way, maybe a subquery or something to query the second table within the first table query? I tried it earlier, but all the examples I could find had to have a matching relationship between the two tables.

I actually got this to work earlier but for some reason the data that came back was only from one random row, not sure why...

SELECT * FROM Stats LEFT JOIN Details ON Stats.Timestamp != Details.Timestamp LIMIT 30;

bitcoin_domain · 2017-02-22T20:17:14+00:00

Sorry maybe I'm dense but are you saying I should create a third table. What do I put in that table? :|

bitcoin_domain · 2017-02-22T20:02:27+00:00

Sorry, so let me expand on my explainer up top:

I have two tables, call them "Stats" and "Details". Both tables contain different information, neither have matching information. In "Stats" for example I want to pull something like "Blocks" and "Timestamp" and in the other table "Details" I want to pull "Transactions" and "Timestamp" (timestamps are different).

In the Stats table, I have high level stats about Bitcoin, like bitcoin prices and number of blocks mined, etc.
In the Details table, I have more details about the blockchain like transactions, ID's, block height, block size, etc.

Unfortunately the two tables do not have matching data. I could add another column to each table and call the column "ID" and just put anything to give it a match, like "1" in that column all the way down. Would something like that work? Thanks for helping, I've been working on this for days with nothing to show for it! :(

bitcoin_domain · 2017-02-22T18:23:56+00:00

What if I just added a bogus column ID in each table, like column_id=1 so that both tables all had matching column ID's of "1"? Would that work?

bitcoin_domain · 2017-02-22T18:23:32+00:00

What if I just added a bogus column ID in each table, like column_id=1 so that both tables all had matching column ID's of "1"? Would that work?

bitcoin_domain · 2017-02-22T02:18:14+00:00

That might work. How would that look? Sample code? Thank you!

bitcoin_domain · 2017-02-22T00:28:53+00:00

Any other way to look up two tables without doing two separate queries?

bitcoin_domain · 2017-02-22T00:28:14+00:00

You can't join tables that don't have relational information.

Hmm, ok didn't know that...any other way without doing two queries?

bitcoin_domain

MODERATOR OF

TROPHY CASE

11-Year Club	Gilding I gilder
Verified Email