Also, I appreciate you typing all that, but it doesn't mean much to me.. Would that replace all or that PHP file I attached or just part of it?

Shove it on the end.

The end of what, I'm not quite sure. :$

Are you browsing directly to the attached file, or using include(file.php) or similar?

That file can be found in the module/froogle/ directory. I started messing with it after reading this.

I got confused with that link, so I jumped into PHPEclipse and fixed the file.

 

Not quite so bad to identify the relevant parts to change with a decent font, word wrap off, and syntax formatting on, but I've still only modified the actual file output stuff - that utterly evil SQL query is no doubt doing more work than it needs to be, but I'm definitely not diving in to go fix that.

 

Anyway, should be attached. (Use BeyondCompare/WinDiff/etc if you want to see what I changed).

Cheers Pete, I'll look over that with a furrowed brow. Just tried using it as is and it broke, but I'll look at it closer tomorrow.

Bah!

Broke with an error broke, or worked but produced the wrong results broke?

And did the original version work (just with too many columns) or had you not tried it?

Well, there's a section in my admin to export a Tab Delimited file, that just doesn't work.

 

The original works but gives me more columns than I require.

Arse.

I missed the trailing concatenation and semi-colon stuff. (I blame PHP being crap for that.)

Anyway, this one will work.

Cheers Pete, will try that tomorrow when I am on a desktop, for it is fiddlier than Vannesa Mae on the Netbook.

Have you tried PDT yet? If so, Howse it compare to PHPEclipse?

 

deit: mind you, this is like me axing a brain surgeon if he prefers a hacksaw or a chainsaw...

Haven't tried it - was about three years ago when I setup that Eclipse config, and at the time PHPEclipse was the only (usable) Eclipse plugin for PHP.

Since I do so little PHP stuff, I haven't bothered updating, nevermind considering alternatives.

The only reason I ask is because Aptana ('nuther Eclipse-based ide, which I happen to use rather a lot) recently switched to PDT.

Aptana sucks.

Tried it a couple of times (for JS/CSS/XML stuff), most recently about a month ago, but every time it has annoyed me a great deal.

My work colleagues feel the same, and they're far less fussy about their software than I am.

Yeah but it sucks less than netbeans ime (at least for generic [x]html/css, and beats the living shit outta anyfink for rails, dunno 'bout javascript per se or anyting heavy), and is a pretty decent replacement for dw, in that it doesn't attempt to 'help' you rewrite your code into an undifferentiated mass of blood, bone and brainmatter...

Still giving me the same old headers that when I export a file :(

Huh? :S

Look at lines 115..122 - the old headers should be commented out with double slash, with the shortened versions beneath?

Only thing I can think is that maybe I've gone mad and PHP doesn't use that for comments - try switching for the hash that the other comments use and see if that makes a difference?

It says:

if ($fp !== false) {
		# Write file header
 
		# Full header: 
		# title\tdescription\tlink\timage_link\tid\texpiration_date\tlabel\tprice\tprice_type\tcurrency\tpayment_accepted\tpayment_notes\tquantity\tbrand\tupc\tisbn\tmemory\tprocessor_speed\tmodel_number\tsize\tweight\tcondition\tcolor\tactor\tartist\tauthor\tformat\tproduct_type\tlocation
		if ($froogle_iso) {
			// fputs($fp, "title\tdescription\tlink\timage_link\tid\tprice\tcurrency\tpayment_accepted\tpayment_notes\tquantity\tweight\texpiration_date\tbrand\tcondition\tproduct_type\tlanguage\n");
			fputs($fp, "title\tdescription\tlink\timage_link\tid\tprice\tcondition\tlanguage\n");
 
		} else {
			// fputs($fp, "title\tdescription\tlink\timage_link\tid\tprice\tcurrency\tpayment_accepted\tpayment_notes\tquantity\tweight\texpiration_date\tbrand\tcondition\tproduct_type\n");
			fputs($fp, "title\tdescription\tlink\timage_link\tid\tprice\tcondition\n");
		}

I believe it is commented out correctly... I kind of did that sort of thing myself before and it didn't work, so I assumed there must be something else.

Sorry Pete :(

Hmmm. Is there any form of caching in place?

I don't think so.. tried it again in a different browser with no luck. Grr..

I meant server/software level, rather than browser.

Also, do you have any of the other PHP files lying around in the same directory - if so, try moving them or changing the extension in case the software tries to be clever and execute them all.