Custom Stats Page

[gentlegiant]

I've made myself a stats page that auto refreshes.

Basically, it gives me the last 10 orders, last 10 customers and who's online.

 

What I'd like to do is to know which catagory or which product their looking at since it's kinda hard to guess from "/product_info.php?cPath=48&products_id=178"

 

so, whats the best way of saying....

if the first 17 charecters are "/product_info.php" then take the last 3 charecters and look up in the products description table for the last three charecters as product_ID and return Product_description?

 

The select statement I can do, but whats the PHP to 'extract' a certain number of charecters from a string?

 

Thanks