| |
Haven't registered yet? Do it here now!
|
oil
Joined: 15 Jul 2007
Posts: 106
|
|
|
 |
|
 |
|
 Posted: Thu Mar 18, 2010 10:19 pm Post subject: phpmyadmin |
 |
|
|
 |
|
 |
|
|
|
|
i am total noob with mySQL and so, so since GS dont have a export feature which i am truly missing what must i type in phpMyAdmin in order to get
all galleries from one specific sponsor, which all data Pipe | delimited as
url|desc|longdescription|keyword|cf1 |
|
|
|
|
|
|
|
kaktus
Owner
Joined: 22 May 2004
Posts: 1576
Location: CheapestAdultScripts.com
|
|
|
|
|
|
|
| Posted: Fri Mar 19, 2010 10:49 am Post subject: |
|
|
|
|
|
|
|
|
|
|
in phpmyadmin there's no such option to export both in that format and specific rows. It can dump a whole database or table..
here's php file you can use for that:
lookup the ID of the sponsor you want to export from. Make a tmp.php file and put it in the main GS folder
| Code: |
require_once 'info.inc.php';
$zaiavka=@mysql_unbuffered_query("SELECT url,descr,longdescr,keywords,cf1 from gsgals where spid=PUT_HERE_ID");
while($otgovor=mysql_fetch_row($zaiavka))
{
echo implode('|',$otgovor).'<br>';
}
@mysql_free_result($zaiavka);
|
(just enclose this code in opening and closing php tags, coz phpbb is messing it up here)
then simply visit the tmp.php from your browser and you will get the exported list..
_________________
 |
|
|
|
|
|
|
|
oil
Joined: 15 Jul 2007
Posts: 106
|
|
|
|
|
|
|
| Posted: Fri Mar 19, 2010 5:36 pm Post subject: |
|
|
|
|
|
|
|
|
|
|
| sweet thx, worked just sweet |
|
|
|
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2002 phpBB Group
|
 |
phpBB Template designed by SkaidonDesigns |
 |
| |
