Retrieving a piece of text

[Chris_Evans]

Hi there.
I have a database:

something(something)

How can I retrieve what the text inside the brackets is from the database, but that only so when I come to insert into database it inserts it into the correct field.

E.g.

Products(Software)

When I come to insert into the table I can use the $products variable to use the correct insert.

Products(Gardening)
Products(Hardware)

If you see what I mean?

And I thought I might be able to creep another little part in here... how can I retrieve the file name of the page you're viewing.

E.g. I'm writing in newthread.php?

Thanks in advance,

Chris

[Sphynx]

Not sure I get exactly what you mean with the database insert question. But the page you are viewing is $PHP_SELF.

[Chris_Evans]

Ah, never thought of it that way. Thanks. 🙂

[statrat]

one caveat. $PHP_SELF is relative to root, so if you have www.example.com/somedir/newthread.php
your $PHP_SELF='/somedir/newthread.php';

if this is a problem, i got the following from php.net manual comments. works pretty well:

$filename = substr($_SERVER['PHP_SELF'], strrpos($_SERVER['PHP_SELF'], "/") + 1);
echo $filename;//prints newthread.php

[Chris_Evans]

Cool - that's also given me some extra ideas. 🙂 Thanks. 🙂