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