@scottalanmiller I know you can user AVG like this

SELECT AVG(`Rating`) FROM `Reviews` WHERE `bathroom_ID` = 100

@scottalanmiller said in Help with SQL query:

You have caps in your column names? You get a hand slap for that one.

I know how to fix that I don't think that's the problem with the query

I need some help with an SQL query I want to run. I have 2 tables one has reviews and one has bathrooms.
I need the average from all rating rows that reviews.bathroom_ID = bathrooms.ID then to update bathrooms.ratings

What I have so far is...

UPDATE bathrooms
   SET bathrooms.Rating = (SELECT AVG(Reviews.Rating)
                   FROM Reviews AS Rating
                  WHERE Reviews.bathroom_ID = bathrooms.id)

But it doesn't work

Error:
#1054 - Unknown column 'Reviews.Rating' in 'field list'

Reviews table EX:

ID___Bathroom_ID_____Review____Rating_____Username
1_____100___________Smells bad____0__________User
2_____100___________Its okay_______1__________User
2_____100___________Its okay_______1__________User

Bathroom table EX:

ID__________Name________________Rating____________
100________Wal-mart______________0___________________

@Dashrender yes that is correct you can only add parties from the app

@prcssupport said in Potty Plotter:

Closest ones to me are in Rochester, and NYC. I'm just wondering how I'm gonna hold it that long. Anyone on here log those two in?

You can add them with the app

@Breffni-Potter said in Potty Plotter:

How will you combat the trolls

I am working on some backend tools to help with that.

@scottalanmiller said in Potty Plotter:

Does the app track which toilets are paid and which are free, and how expensive they are?

I can add that I was not aware that places make you pay to go potty.

@scottalanmiller said in Potty Plotter:

We need t-shits with cool slogans like...

"Get the poo, on where to poo."

You mean like this "Never need to go, without knowing where to go"

@thwr said in Potty Plotter:

Any plans to expand your potty plotter to Èurope?

It can take in data from anyone anywhere. If you have a potty that needs plotting just download and add it.

For everyone to test and for the ones that didnt want to sideload it
https://play.google.com/store/apps/details?id=com.supersimpleapps.pottyplotter.pottyplotter

Also if anyone wants to see a lot of data on the site. Enter KY with 200mi radians

@Dashrender You can put in anything from NY for new york to the zip code of your town. I am working on a SSL for the site to allow location search from GPS

@Dashrender Zoom in and out has been added to the site.

@travisdh1 You have to use the app.

@DustinB3403 Fixed it!

So about a year ago I came up with an idea for a website and app that would help you find restrooms and see reviews on them. I looked around the internet and found a few but everything seemed to ask for too much into or have too little info. Then I talked to a lot of people about what they wanted and got a lot of feedback about ideas. Then I got to work on the site and the app here is where I am on them.

Site - http://pottyplotter.com/ - Almost done.
App - https://play.google.com/store/apps/details?id=com.supersimpleapps.pottyplotter.pottyplotter

I would love to hear feedback from everyone about it as there is always room for improvement. You are welcome to add potties to the database and if you placed one in error just let me know and I can remove it.

Opera is now using the chromium core.

Good news!

I got it working. My boss changed the name of the SMTP service to HOLDSMTP then when he changed it back it broke the patch. I pulled my from my backup then reinstalled the patch and everything is working.

I am having some troubles with my qmail using SMTP routes via sendgrid. I have talked with their support and they do not see the server trying to sign in. I get this error

Text
delivery 11: failure: Connected_to_108.168.190.108_but_sender_was_rejected./Remote_host_said:_550_Unauthenticated_senders_not_allowed/
I used the qmail setup here

https://sendgrid.com/docs/Integrate/Mail_Servers/qmail.html

I have tried removing and reinstalling qmail and installing the patch listed here

http://notes.sagredo.eu/node/84

I also did the telnet test that was listed here

https://support.sendgrid.com/hc/en-us/articles/200182038-Testing-your-connectivity-to-Sendgrid-s-SMT...

and the test passed with the same username and password I am using.

I would love to get this working and if anyone can help I will be very thinkful.

Yes and if you build a game on a device they can all join.

@scottalanmiller no mods just trying to make it work.