Search:

I think svdigen understands what i meant - sorry if i confused matters when talking about searching/sorting etc -

To explain it better, basically what i meant was that say i have 20 different...

I think this is more a PHP question than SQL.

I know it depends on the usage, but i wanted other people's opinions on when to use PHP to process/filter/sort data and when to use the database.
...

Usually you would use the same server-side code you are using to generate the options via AJAX, to generate the lists on page load once the form has been submitted. You have all the values you need...

I've got to stop you there, wordpress is NOT a CMS, it's a blogging platform - don't use wordpress expecting it to do what a CMS will do because you'll end up starting all over again.

Sorry, but...

I'd write it myself if i went down that route, would rather use a tried and testing one though. Thanks anyway

Depends completely on how often your site gets crawled by Google - the more your site is updated and the more content is contains then the more often Google will crawl, this could be anything from...

I'm looking at writing a simple app to track and manage link building requests - something that will fire an email off to the thrid party site and which you can report on which ones have replied and...

Thanks Ribeyed, good link there

Jarrod, your help has been tremendous, thank you very much.

In actual fact though, I was planning on storing the whole request path in the database i.e. everything after the domain.

Two reasons...

Yes, i'm afraid i didnt understand either.

On another matter though, the table which stores the URL request paths could potentially build to many millions of rows - in time well over 5 million....

Any ideas folks?

An interesting point came up recently when deciding on what the URLs should be on our ecommerce site - is a URL in the format http://www.example.com/some-keywords/name-of-product (where...

Hi Jarrod, thanks for the advice, that's exactly what I'll aim to do first. Can you offer any advice on how I create some 301 redirects on 1 million products though? Use the product code in the...

Hi,

In my job I have been given a project to convert the existing web site to use url rewrites for the product pages. Currently the pages are in the format www.example.com/Name-of-Product/12345...

I see, so using jQuery as a Javascript example of a framework - you'd stil create your own classes etc but core functionality is helped along by the framework itself?

Some fair points guys, thanks, i havent as yet gone ahead with the project, as to do so would mean putting everything else aside for at least 6 months, but that's not to say I won't revisit it at a...

Sorry i forgot to post the headers!!

But i have solved it anyway - i was missing a quote at the end of the filename.

For anybody else's benefit, here are the headers to use.



...

Hi folks,

I'm trying to output a .csv format file for download via php, but over a secure connection (https). I have been using the following headers, but have found that in Google Chrome, the...

The reason for the LEFT JOIN of the stock table in the SELECT query is to see if the item has an associated entry in the stock table. Once the result set is returned to PHP then an INSERT to the...

Hi svidgen,

The IDs of the returned rows are used in insert/update commands to another table, where the ID is a foreign key in the that table. It does however mean temporarily storing the data in...

By the way....here is the result from EXPLAIN on the above query, if it helps



id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE ...

Hi guys, taking your advice i have grouped the queries into one larger one rather than performing multiple single queries. The whole command has gone down to about 8 seconds and about 7.5 seconds of...

Hi Svidgen, thanks for your reply - are you saying it is better to have one SELECT...WHERE...IN (...,...,...) with multiple values than to have 80 SELECTs? I guess I haven't really thought about it....

This may be a bit of a long shot but thought i'd give it a try...

I have constructed a script which retrieves a list of approx 80 products, no issues there, however each product has say approx 100...

Hi apeg, no errors, it's just that the content is not copied to the other <div>. However i have just tried a simple example at home and it works fine - will try the same when i'm back at work,...