MySQL Forums
Forum List  »  German

help php run mysql function
Posted by: Michel mbdec
Date: November 14, 2018 01:08PM

Hello people!
I would like to help you define php buttons voil mysql functions.

here is a mysql function to bring the set result and do echo

is a nutritionist system that makes comparisons in the database

Food Table:
Food_ID
Name


Table Profits_Males
Benefits_Males_ID
Name
Type ('B', 'M') (Whether it is benefit or males)

Food_Benefits_Malons Table
Food_ID
Benefits_Males_ID


For example, for all foods and their benefits

SELECT Food. *, Profit_Mal. * FROM Food JOIN Food_Beneficios_Males USING (Food_ID) JUNTAR Benefits_Males USING (Benefits_Males_ID) WHERE Type = 'B';

For example, for all foods and their males

SELECT Food. *, Profit_Mal. * FROM Food JOIN Food_Beneficios_Males USING (Food_ID) JUNTAR Benefits_Males USING (Benefits_Males_ID) WHERE Type = 'M';

____________________________ -
button to perform action | label for echo label for echo
____________________________ -------------------------- ----------------------- ----
button to perform action |
------------------------------------

Options: ReplyQuote


Subject
Views
Written By
Posted
help php run mysql function
987
November 14, 2018 01:08PM


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.