Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by blekfis
-
-
Possible JOIN question
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 ;) -
Possible JOIN question
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... -
Create a serie of databases
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... -
Create a serie of databases
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 -
Create a serie of databases
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... -
Get part of string
You're fast - and also gave the right answer to what I've been looking for :) Thanx!! -
Get part of string
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? -
Differences in MySQL-databases
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... -
Differences in MySQL-databases
Tables :) Running a phpBB-forum hosting site -
Differences in MySQL-databases
Problem is PMA times out since I have ~45000 tables in the db I'm moving to. -
Differences in MySQL-databases
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... -
-
mysqldump certain tables via prefix_*
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 ... ) -
Send referer with header
Since no answer I guess it's impossible to do it the way I need...
