Search results for query: *

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...

When a user clicks the ad (<a href="page.php?redirect=http://www.advertizer.com"><img></a>) it sends them to my redirect-page at www.mydomain.com (that counts). Code I've tried so far to redirect and send www.mydomain.com as referer: <?php $redir = $_GET["redirect"]; header("Location...

I'm redirecting traffic via this (in short...): header("Location: " . $html->param('redirect')); Only problem is that the recieving website doesn't get any referer-info, and since I'm redirecting for affiliation I don't get paid :( Is there a way of sending clicks thru my page to reciever so...

I've got a directory called "alfa" that contains both files of various types and subdirectories with files. I'd like to be able to create a new directory named "beta" and copy all the files and subdirectories from "alfa" into "beta". All should be done in PHP... Is it possible (dumb quetion!)...

Thanks a lot!! I was on my way, but some pieces were missing. Now they are all there ;-) Altough I had to change to: array_multisort($price, SORT_NUMERIC, $currency, SORT_DESC, $product, SORT_ASC, $results_array);

I've got an table that looks something like this: product | price | currency prod1 | 15 | USD prod2 | 20 | EUR prod3 | 89 | GBP prod4 | 11 | USD I extract these from the table and then converts them all to EUR, but how do I sort them from low to high (or vv)? Any code-examples are welcome...