dammitjanet

Is this setup on a local server, on webhost supplied webspace? I beleive you can turn of these advanced features (that dont exist on mySql) in the phpMyAdmin config files. the array it is talking about, is part (as I understand) of the phpMyAdmin configuration files, its seems to be asking you to insert your databasename and details into this array so that hphMyAdmin can use the advanced features.

I use EMS also, but yog is free. perhaps, EMS is being too strict on its SQL parsing, or perhaps MySQL admin is being too lax?

is $query_events being redefined between the two code snippets? if its not, and you are working on the same result set, then the first while loop exhausts the query results, and the second one will never be true and will not run. you will have to either store the results within your first qry in an array or whatever you choose, or run the query again to get the result set. Id advocate the first choice.

http://www.webyog.com/sqlyog/

why dont you download a mysql manger like SQLyog instead? you define you database connections in the program and then admin from within the GUI

echo "scrollercontent[0]=\'<b>-</b> $event\'n"; // add on to scrollies thats your probelm - you are replacing the content - not adding to it..

its an issue with mysql unfortunately - many functions which one takes for granted using oracle/m$sql/postgres are just not supported in mysql however, there is light at the end of the tunnel, things like subselects, increased support for joins will be available in MySql in the near(ish) future.

just to expand of effigy\'s post you can do this. select count(*) from table; and stick it in a variable called $max ... and subtract 20 from it. then make your query string \"select * from table limit $max,-1\" which should give you the last 20 lines of the table. you may want to stipulate an order by clause on a datetime field or unique incremental to make sure the data is the last 20 entries.

in your connection information to your database, is the server localhost or another server name? In most cases that I have seen where the server is localhost, you can connect remotely, in the other, ive found thru experieince that there is usually a firewall between the webserver and the database server which will only allow traffic thru from the webserver and not from external connections. Having said that, one site I mange has an option to allow remote access which is user configurable, so Im not sure how that is managed, its just possible.