Zaphod

I’ve had to take those tags out for now – but I’ve just commented them out using <?php # role=”main”; ?> etc so that it’ll be easy for me to put them back later on should these tags become compliant.

Marking as resolved…. possibly a bug in WordPress though…

One other point on this is that the contact page had been a child page, but was later made a top level page…. so some of the redirection tables had (for example) /about/contact/ and others had /contact/

Dunno if this helps…

NorysLintas – thanks, but I’d already tried that.

Ok – found a “fix” as such – not sure if this is a WP bug, but I went looking for references to contact in the other tables – first looking at the wp_redirection_logs, and from there, the wp_redirection_items.

There was a lot of entries for contact etc, so I took a chance, and deleted all of those. I then resaved the page in the admin area, and all is good.

I’ll not mark this as resolved for a few hours just to see what others think – and what is thought of my supposed solution.

Oh,

Just in case it’s relevant I should say that there was a previous CONTACT page – which was deleted. To be sure it was gone I deleted it from the TRASH and also deleted all records from the posts and postmeta table with the corresponding page id.

I thought that’d fix it but……

Just to confirm – works perfectly. Now I just need to dynamically write the queries and I’m done. THANKS SO MUCH.

Thanks a million, that seems to be doing the trick. Just for anyone who might copy and paste and change variable names…. you missed a quote after Silver..

AND (cc_color.meta_key = 'Colour' AND cc_color.meta_value = 'SILVER)

and a – rather than a _

AND (cc-model.meta_key = 'Model' AND cc_model.meta_value = 'Laguna')

I feel bad even pointing that out as I think you’ve cracked it for me – thank you SO MUCH. I must get a book on SQL as while I’m pretty handy at the basic SQL, joins boil my brain.

THANKS AGAIN. [I’ll update on progress later just to hopefully confirm that this is the right tack]

Sorry – I should’ve said you’d think it’d be easier to do queries and show results based on custom field data….. it is easy enough to just show them….

Thanks for that – do I need to do a join for each extra variable I want though? I’ll logon to the PHP MySqlAdmin to test the queries…

You’d think (imho) that wordpress would have a feature that’d allow you to easily show the custom fields though….

t31os_,

Many thanks for that post. It kinda helps, but is presenting a few problems. This query:


SELECT wposts.*
FROM cc_posts wposts, cc_postmeta wpostmeta
WHERE wposts.ID = wpostmeta.post_id
AND wpostmeta.meta_key IN ('Colour','Make','Model')
AND wpostmeta.meta_value IN ('Silver','Renault','Laguna')
AND wposts.post_status = 'publish'
AND wposts.post_type = 'post'
AND wposts.post_date < NOW()
ORDER BY wposts.post_date DESC


Returns a correct result but returns it three times. It seems that for each match (Colour, Make, Model) it’s returning a row. So although there is only one Renault on the system, it’s showing three times.

Also if I change the colour to Blue (there *isn’t* a blue Renault on system) it shows two rows (again, I’m guessing the two matches for Make and Model). It should show none as there are no Blue Renault Laguna’s on the system…

Huge thanks for the help though – you’ve got me further than I was.

MichaelH – will be trying your solution shortly as well. I think I may need something more like this as some of my search critia will be comparison based – i.e. price more than 3k and less than 4k etc so….

Will post back how I get on.

Again… HUGE THANKS!

This issue has reared it’s ugly head again ??

Basically when I create a page called News, and apply the template I want on in ADMIN, it works exactly fine.

Now, when I then go to ADMIN -> SETTINGS -> READING and make that page the page for the POSTS page, and save, it goes back to using some other template. If I then change this page back to a normal page, it uses my template again just fine.

Is this a wordpress bug?! It’s causing me huge problems…

Thanks for the reply, but as you guessed I’m already doing the things you suggest. I deleted the news page and recreated it again, doing everythign the same as before, and although I’m not quite sure why – it seems to have worked.

I did this a number of times before it worked, so for now, I’ll presume I was just missing something…. but I don’t think so and now have my fingers crossed that it doesn’t break ??

I think I’ll just leave it alone at this point!

…anyone got any ideas on this..?

Many thanks for any suggestions.

Right,

But I want to have a situation where when the site admin adds files, that they automatically appear under this widget – i.e. not to have to do it by hand each time.

Even if I could get a pointer on how to upload a file and give it a category or something I could probably write the PHP to list the files – i.e. some method of distinguishing between image / video files that the admin might upload and the actual files that he / she would want to present as user download files.