MySQL Forums
Forum List  »  Newbie

Re: sql select with a simple join does not works ...
Posted by: steph march
Date: November 04, 2018 08:27AM

Hi Peter!

thanks for the reply.
right, forgot the group by...
since your last message I corrected
my sql statement.

again... 0 result.

But I knew there was something wrong with
the web data manipulation (insert into the database)
and I finally found yesterday there was a \n\r in the
provider field submitted to the DB.

forgot to php trim my submitted field.

rules 1.:
always clean the garbage before submitting
to the database...

Now as Nov. 4 everything is working and I can continue
my project.

The probe for notification is a C libmysql under Linux
with help from a Cron job (15sec probe).


Thanks and regards
Stephane

Options: ReplyQuote


Subject
Written By
Posted
Re: sql select with a simple join does not works ...
November 04, 2018 08:27AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.