如何在我的网站上显示查询结果

Question

so I want to show the result of my query, and I can't seem to find anything that works. this is what I have so far and I have no idea why it won't work.

daydream festival <?php
$queryday="SELECT `tickets_MAX`-`tickets_VERKOCHT` AS `tickets_over` FOR `evenementdata`        WHERE `ev id`=1";
$resultday=mysql_query($queryday);
$rowday = mysql_fetch_assoc($resultday);
echo $rowday;?> tickets left    

Answer 1

Building on other reasons why this won't print anything like your rows not existing, or misnaming things.

If I'm not mistaken mysql_fetch_assoc returns an array, echo does not print arrays. You need to use print_r($rowday); - Assuming that $rowday contains data.