c_shelswell

nice one - thanks for your help

ah right so autoload only loads the class when I instantiate it? great. Thanks

Hi - I'm not sure if subject of this is really correct. What I mean is if I take one file and fill it full of all my: require('./class_user.php'); require('./class_session.php'); but don't actually call that class is this going to slow things down and use more memory or is the file effectively not read until i use $user = new user; and instantiate the class? Before i've just included the class at the top of the page that needs it just wondering if that's the best way Cheers

nice one that's easy. Just the same as you would a link. Kind of feel stupid now didn't even think of that! Cheers

Hi pretty simple question just don't know if it's possible and can't find much on it. I simply want to be able to do a Header("Location: ./page.php") but for it to show part way down page.php is this possible? Cheers

found the solution! All i needed to do was use a fulltext search maybe this will help someone else: select * from table where match (field) against ('Fruitshop opens 7am') cheers

Hi I've been looking about for this but can't seem to find an answer. I have a string that I need to search in the database for eg 'Fruitshop opens 7am' but my database field only says 'Fruitshop' I thought I could just use a search like: select * from table where field like %Fruitshop opens 7am% but that won't seem to find Fruitshop. Any ideas? Cheers

cheers phpKnight. The number format seems to have sorted it. Though I still think kind of strange it should have to. Thanks

yeah i did have them as decimal before. I assumed this might be the problem so changed it. It does it both ways. Strange thing is it has been working. Unless my web hosting people have gone and changed my mysql version but it's a dedicated server so i doubt it.

Hi I've got a bit of a baffling problem. I'm trying quite simply to subtract two number pulled from my database. They're store in the DB as DOUBLE and the sum would equate to 0.49 - 0.49 the answer i'm getting though is: 5.55111512313E-17 I don't get it! This is working fine on my local machine but on the web server i'm not having much luck. Anyone seen a problem like this before?

yeah that was my next plan. Still though I'm a bit confused why the data would go if the browser hasn't been closed. Cheers

Hi, I've got a confirmation script made that sends an email with a link for a user to confirm their email. This all works pretty good with the exception of not being able to direct them to where they were going before they verified. For everything in the site I just use HTTP_REFERER which works great. I assumed I'd be able to do the same with this if I store it to SESSION. Providing the user doesn't close their browser I thought this should work? Apparently not though. My var is no longer there. Any one have any advice? Thanks very much.

bit of a strange one. I had been getting results from this now all of a sudden i'm not. The query is working without errors it's just not returning. Here's the sql SELECT * FROM products WHERE MATCH(item_title, description) AGAINST ('saddle') Full text search is on and the word is in both the item_title and description. I'm just not getting anything back. Don't suppose anyone has any ideas? Cheers

Hi I've a bit of a puzzle that perhaps someone knows better than me if not i'll keep hunting. I basically have two arrays with different fields in them that I need to display in date order. I was thinking the best thing to do would be to combine them then sort them then to display do a foreach on them. Question is how do I select which field the arrays get sorted by? both have a date field but with different titles i.e. crt_insert_date & claim_insert_date can I select to sort by both? Any ideas would be really great - thanks!

Thanks for the reply. Thing is if i remove the [] I don't even get undefined I just don't get anything. I'm getting this: {"optionValue: 1":"optionDisplay: \u0027WELCOME GIFTS\u0027"} perhaps I'm formatting it wrong?