Any PHP Guru's Here?

[fatoftheland]

Ok.... we're currently compiling a database which basically contains product reviews. Each review has a product code which matches a product reference in our actinic store. Anybody know how I might be able to create a query which takes the actinic product reference (not quite sure how it would get this, perhaps within the current html of the page?) and search for that in a mysql db. Then relay the results of a field based on finding a matching product reference in a table row?

Any advice whatsoever would be greatly appreciated, even if you think it can't be done...

PS. Hoping to display the results on the static actinic html pages by using some form of php include..?

[NormanRouxel]

I'm assuming this database is held on your server and you want the info displayed when the customer visits a page.

In your product layout, try (untested)

<?php
$prodref = '<actinic:variable name="ProductReference" encoding="perl" selectable="false" />';
echo "The product reference is: $prodref";
?>

And make sure your page names end in .php

[fatoftheland]

Thanks very much norman, thats great. I'll give it a bash and see what happens... Seems sooo simple now it's been posted.

[Darren B]

Normans the man around these parts

[leehack]

I think Norman invented php. Wish he'd invented ASP.net, boy do i need some guidance!

[wjcampbe]

Drop me a PM Lee and I'll see if I can help.

[leehack]

Thanks Bill, PM sent.

[NormanRouxel]

Wish he'd invented ASP.net

I've managed to reach a ripe old age without depending on any Microsoft specific technology. Not going to start now