What's wrong with my code?

[ueon]

SELECT a.*, b.* FROM friendlist a INNER JOIN attend b ON (a.friendemail=b.email) WHERE a.email='$email' GROUP BY b.eventid ORDER BY count(*) DESC LIMIT 5

 

This query returns the right results in PHPmyadmin, but when it's executed in a php file through the chrome or firefox, it doesn't display anything. As in the entire webpage won't show up. In chrome, it says server error

 

any ideas?

[AyKay47]

this has nothing to do with the query, the error lies somewhere else in your code.

[ueon]

<?php‎

$events = mysql_query("SELECT a.*, b.* FROM friendlist a INNER JOIN attend b ON (a.friendemail=b.email) WHERE a.email='$email' GROUP BY b.eventid ORDER BY count(*) DESC LIMIT 5");

?>

 

this is all i have in the page

[AyKay47]

where is your link establishment using mysql_connect?

[ueon]

<?php‎

include "base.php";

$events = mysql_query("SELECT a.*, b.* FROM friendlist a INNER JOIN attend b ON (a.friendemail=b.email) WHERE a.email='$email' GROUP BY b.eventid ORDER BY count(*) DESC LIMIT 5");

?>

 

it still doesn't work :s it's giving me a 500 error

[AyKay47]

what is the contents of base.php?

[jonsjava]

<?php‎
include "base.php";
$events = mysql_query("SELECT a.*, b.* FROM friendlist a INNER JOIN attend b ON (a.friendemail=b.email) WHERE a.email='$email' GROUP BY b.eventid ORDER BY count(*) DESC LIMIT 5");
?>

You aren't executing the code. Nowhere do you actually call $events, which would then have PHP execute the query that resides in the variable. Also, you do nothing with the data it may return.

 

Try this:

 

<?php
include "base.php";
$sql = "SELECT a.*, b.* FROM friendlist a INNER JOIN attend b ON (a.friendemail=b.email) WHERE a.email='$email' GROUP BY b.eventid ORDER BY count(*) DESC LIMIT 5;";
$res = mysql_query($sql) or die("Error!<br />".mysql_error());
while ($row = mysql_fetch_assoc($res)){
$out[] = $row;
}
var_dump($out);
?>