Recent content by blekfis

Worked perfect! Thanx!!

I'll try this later and also try to understand how it works now that I have a piece that I can relate to. Visibility = 0 for users, =1 for admins only ;)

I've read tutorials and forums, but I just dont get it or it's not possible to do what I want... I've got two tables (a bit cut here): albums (aid, visibility) pictures (pid, aid, name, title) // pid increases by 1 for each new row I'd like to select the latest addition from pictures, but if...

Correct! It's those small things that's hard to see... This is being used now: <?php $mysql_access = mysql_connect("localhost", "root", ""); $count = 1; while ($count < 5) { $query = "CREATE database_" . $count; mysql_query($query, $mysql_access) or die (mysql_error()); echo...

Sorry... Should have been in the first post... Warning: Wrong parameter count for mysql() in C:\xampp\xampp\htdocs\create_db.php on line 6

Hi, I would like to make a script that creates a serie of databases. This is what I thought could do the job... $mysql_access = mysql_connect("localhost", "user", "pass"); $count = 1; while ($count < 5) { $query = "CREATE database_" . $count; mysql_query($query, $mysql_access) or die...

You're fast - and also gave the right answer to what I've been looking for :) Thanx!!

My script is called like this: script.php?sms=123#456 Then I use GET to read $sms into the script. 123 and 456 is two separate values I'd like to retrieve. They can be from 1-5 digits each. Best way to do this?

I have noticed on phpMyAdmin there is a collation column,listing different language options. I do no profess to know what it means but this may be the difference you are looking for. Had a look at this for a smaller database on same server. It looks exactly like the other server, so my guess...

Tables :) Running a phpBB-forum hosting site

Problem is PMA times out since I have ~45000 tables in the db I'm moving to.

How come this difference? INSERT INTO `db1_search_wordlist` VALUES ('bara', '251', '0'); INSERT INTO `db2_search_wordlist` VALUES (0x3237, 3861, 0); Data from two different databases on different servers, both using phpBB. But why that difference in the database? Trying to move phpBB-forums...

Ok, thanx!

The normal way to use is: shell> mysqldump [options] db_name [tables] Is it possible to do something like this shell> mysqldump [options] db_name [prefix_*] I want to backup certain tables from a db which all have the same prefix (xyz_a, xyz_b, xyz_c ... )

Since no answer I guess it's impossible to do it the way I need...