Hello!

I have a question. I have a table of matches in this table 5 cells id, team 1, team 2, event, bon. I wrote a code that displays all the information from the cells with a limit of 21

function getPost() { global $link; $sql = "SELECT * FROM `matches` ORDER BY id DESC LIMIT 0, 21 "; $result = mysqli_query($link, $sql); $posts = mysqli_fetch_all ($result, 1) ; return $posts; }

And what happened: type cool picture

How to do that in the transition to one match it was the data of this match that was displayed, here is my code:

 function getMatch() { global $link; $sql = "SELECT 'id' FROM `matches` WHERE 'id'='Вот тут я даже не знаю что придумать'"; $result = mysqli_query($link, $sql); $matches = mysqli_fetch_all ($result, 1) ; return $matches; }

With links everything is fine, for each match it has its own. For example: http://csesports.ru/match.php?m=38 .

But I don’t know how to put a link to the same match in the 2 function, because if I insert $match['id'] into the getMatch() function into the WHERE id = '' line, it starts to swear. How can I fix this?)

  • one
    Pass the match Id to the function as a parameter - Mike
  • reformulate the question title, it should not explain the conditions and so on, it should briefly and clearly indicate the problem - Anatol

1 answer 1

 $sql = "SELECT * FROM `matches` WHERE 'id'=". (int)$_GET['m'];

The fastest way If m is the id of your match

  • Comments are not intended for extended discussion; conversation moved to chat . - Nofate ♦