Jump to content

[SOLVED] Query problem


newby_dude

Recommended Posts

Hi,

 

Trying to get the max id in the table calender (Dutch for calendar)

I get the following error:

 

Parse error: syntax error, unexpected T_VARIABLE in /home/bbakker1/www/ichthus/home_bericht_1.php on line 49

 

When I try to run the SQL in phpmyadmin it works fine.

This is my code

-------------------------------------------------------------

46 //max id ophalen van de calender

47    $query_cal = "select max(id) from calender"

48   //gegevens binnenhalen

49       $result_cal = mysql_query($query_cal);

50       $ID_top_cal = mysql_fetch_assoc($result_cal);

51

52           echo $ID_top_cal['ID'];

-------------------------------------------------------------

 

The same setup has worked just fine for other pages I have.

 

Hope to hear from you all.

 

Greetz Bas B.

Link to comment
https://forums.phpfreaks.com/topic/118934-solved-query-problem/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.