I need 10,000 + links formatted. I will pay you a reasonable fee.

**madawgz** · 09-29-2006, 01:05 PM

so how much are you paying?

**NTSS** · 09-29-2006, 01:07 PM

Originally posted by madawgz

so how much are you paying?

Whatever it cost....what's your price?

**Brujah** · 09-29-2006, 01:12 PM

Looks pretty simple NTSS, if it's in SQL format like you show above. Just a matter of throwing it back in SQL and exporting it into the format you need.

**xanx** · 09-29-2006, 01:16 PM

if there is no way to automate it and it has to be done by hand I will do it for 600.00, paid 100% when finished, and would need the weekend to finish it.

**4Pics** · 09-29-2006, 01:20 PM

Do you need it done one time?

If so icq me i'll do it for free real quick.

**NTSS** · 09-29-2006, 01:23 PM

Originally posted by 4Pics

Do you need it done one time?

If so icq me i'll do it for free real quick.

Yes...just once

but I don't have ICQ....email me

**u-Bob** · 09-29-2006, 01:33 PM

I can write you a lill script to do that...

**u-Bob** · 09-29-2006, 01:34 PM

will only take a couple of lines of perl...

**Dvae** · 09-29-2006, 01:49 PM

Originally posted by xanx

if there is no way to automate it and it has to be done by hand I will do it for 600.00, paid 100% when finished, and would need the weekend to finish it.

Remind me to never hire you for anything.

As others have said Perl, PHP or good text editor that can handle regular expressions could do it in a few minutes

.

**NTSS** · 09-29-2006, 02:24 PM

Originally posted by Dvae

Remind me to never hire you for anything.

As others have said Perl, PHP or good text editor that can handle regular expressions could do it in a few minutes

.

Yeah I agree....

so who's gonna hook me up?

**Brujah** · 09-29-2006, 02:33 PM

Zip it up.. put it online.. let someone download it and transform it for you.

**Dvae** · 09-30-2006, 05:23 AM

Originally posted by NTSS

Yeah I agree....

so who's gonna hook me up?

Have you found a solution yet?

**lucas131** · 09-30-2006, 06:39 AM

I can do it, contact me

**TMM_John** · 09-30-2006, 06:51 AM

Do you have the table created? If you do then just run that sql you have against it and then run this on the server.

Code:

<?

  mysql_connect("host","username","password");
  mysql_select_db("yourdbname");
  
  $query = "select * from L;";
 
  $result = mysql_query($query);

  while( $row = mysql_fetch_assoc($result)){

    print $row["url"].",".$row["title"].",,,,".$row["description"]."\n";


  }
?>

Then view source as HTML won't interpret the line break.

If you need the table structure created or need info on how to get the SQL inserts you have put into it let me know.

**Beejeebers** · 09-30-2006, 06:53 AM

PHP Code:

<?php
$db = mysql_connect("localhost", "username", "password");
mysql_select_db("database_name",$db);
$result = mysql_query("SELECT url, title, description FROM your_table_name",$db);
while($a=mysql_fetch_array($result)){
    echo $a['url'].",".$a['title'].",,,,".$a['description']."<BR>";
}
?>

That should do it...

**borked** · 09-30-2006, 07:44 AM

And using Perl....

Code:

#!/usr/local/bin/perl

use DBI;
my $dbhost = 'localhost';
my $dbport = '3306';
my $dbuser = '';
my $dbpass = '';
my $db_name = '';
my $table_name = '';
my $outFile = 'output.csv';

$db_handle = DBI->connect("dbi:mysql:database=$db_name;host=$dbhost:$dbport;user=$dbuser;password=$dbpass")
    or die "Couldn't connect to database: $DBI::errstr\n";
$sql = "SELECT * FROM $table_name";
$statement = $db_handle->prepare($sql)
    or die "Couldn't prepare query '$sql': $DBI::errstr\n";
$statement->execute()
    or die "Couldn't execute query '$sql': $DBI::errstr\n";
open OUTPUT_FILE , ">$outFile";
while ($row_ref = $statement->fetchrow_hashref())
{
    print OUTPUT_FILE $row_ref->url .",".$row_ref->title ."$row_ref->description.",";
}
clode OUTPUT_FILE;
$db_handle->disconnect();

$13,000 please
PayPal Only

**pornguy** · 09-30-2006, 07:48 AM

I have someone that will do it 75cents per URL and by hand so theres no mistakes,

**borked** · 09-30-2006, 07:49 AM

bollox, didn't see the multiple comma formatting:

after: while ($row_ref = $statement->fetchrow_hashref())
change to:

Code:

{
       print OUTPUT_FILE $row_ref->url .",".$row_ref->title .",,,,".$row_ref->description;
}

**1200mics** · 09-30-2006, 07:53 AM

good technical tips

**woj** · 09-30-2006, 09:18 AM

did you figure it out? if not, shoot me an email woj [at] wojfun dot com

**fuzebox** · 09-30-2006, 09:26 AM

You fuckin php noobs

No need to import into mysql, 1 regex line on the existing dump file will take care of it.

**Solid Bob** · 09-30-2006, 09:33 AM

Originally posted by pornguy

I have someone that will do it 75cents per URL and by hand so theres no mistakes,

IT'S A 2 MINUTE JOB!!!!!!!!!!!!!!!!!!

**Solid Bob** · 09-30-2006, 09:35 AM

Originally posted by fuzebox

You fuckin php noobs

No need to import into mysql, 1 regex line on the existing dump file will take care of it.

Well the php pros are in here killing the market. The guy said he'll pay whatever and the first person offers it for free. lol Sometimes you just need to learn when to shut up.

**psili** · 09-30-2006, 09:37 AM

Isn't it just something like:

SELECT url,title,',',',',',',description FROM [table] INTO outfile 'dump.txt'

-- just do a quick search for "mysql select into outfile" and you'll be golden.

**Fizzgig** · 09-30-2006, 09:39 AM

Originally posted by Beejeebers

PHP Code:

<?php
$db = mysql_connect("localhost", "username", "password");
mysql_select_db("database_name",$db);
$result = mysql_query("SELECT url, title, description FROM your_table_name",$db);
while($a=mysql_fetch_array($result)){
    echo $a['url'].",".$a['title'].",,,,".$a['description']."<BR>";
}
?>

That should do it...

This wasnt' the end of it?

**CaptainWolfy** · 09-30-2006, 09:41 AM

Originally posted by Solid Bob

Well the php pros are in here killing the market. The guy said he'll pay whatever and the first person offers it for free. lol Sometimes you just need to learn when to shut up.

**borked** · 09-30-2006, 09:48 AM

Originally posted by fuzebox

You fuckin php noobs

No need to import into mysql, 1 regex line on the existing dump file will take care of it.

what, like s/^\w.*,{1}\w.*,{1}\w.*,{1}(\S.+),{1}(\w.+),{1}(\w.+ ),{1}.*$/
(assuming its a CSV)

hell yeah, but you've still gotta iterate through the file

**Brujah** · 09-30-2006, 10:01 AM

pretty funny the quick 1 minute, 1-line regex script hasn't been posted then by the so-called experts. prove it.

**baddog** · 09-30-2006, 10:03 AM

Originally posted by u-Bob

will only take a couple of lines of perl...

are you good at PERL?

**Burridge** · 09-30-2006, 10:04 AM

ill do it if you put me through computer programmer school at my community college, and loan me about 150k to live off for the next for years while i learn. then another 30k for my after college trip to europe so i can get cultured and explore the world. I'll get right on it as soon as i get back.

Otherwise, here's a bump for you guy.

**psili** · 09-30-2006, 10:10 AM

Originally posted by Brujah

pretty funny the quick 1 minute, 1-line regex script hasn't been posted then by the so-called experts. prove it.

Wish I could remember the article I read, but it was about how to find the right programmer for a company. It pretty much boiled down to finding someone who was compatible with the environment (people) and who was open to say "I don't know" but was willing to research and learn, rather than just saying they have an answer when really they don't.

Sadly, I've met very, very few of those people. And what this has to do with this thread, I have no idea. *shrug*

I need 10,000 + links formatted. I will pay you a reasonable fee.

I need 10,000 + links formatted. I will pay you a reasonable fee.

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment