This link may help you...near the midlle they talk of "multiple selects" and writing the choices to an array. Their is some sample cgi code. You just need to add the code to write to the MySql table.
http://www.cgi101.com/class/ch5/text.html
Have you checked "register_globals =" setting in php.ini & tried it with them on vs off. ? It sounds like your variable $query is not getting passed.
Mike
I would do it in two steps, although others may have a more efficient way. First you need to SELECT the 10 most current Records into a temporary table. Then sort those 10 by the field you called "rubrik".
1. CREATE TABLE temp SELECT *, MAX(date)AS Max FROM table_name GROUP BY...
I would use mysqldump for this. It will backup all tables in a database.
from the unix/linux propmt(not in mysql):
mysqldump -u username -p database > backup.sql
On the second machine first create the database where you want the tables then:
mysql -u username -p database < backup.sql
Mike
I was also having trouble getting connected to mysql from a remote client throught the internet (ODBC and PHPSQLAdmin). I kept getting:
"ERROR 2013: Lost connection to MySQL server during query"
although I could connect locally just fine. So I knew my permissions were o.k. in mysql...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.