fenway

Two things: 1) It's not really a hash, since the RVALUE should really be: { 'fromid':'<?php echo $row['fromid'];?>', 'subject':'<?php echo $row['subject'];?>', 'mail':'<?php echo nl2br($row['mail']);?>' }; 2) That's because you have to escape linebreaks in JS -- in fact, if you had single-quotes in your subject field, you'd have problems too. So I don't know what nl2br() is not doing...

First, that's impossible. Second, you have some very scary looking code there -- for example, you should be calling inform(this.value)... not hard-coding the order! Third, your button function should at least take the form object (with this.form)...

Try this: SELECT products.name, products.prodID, IFNULL( promotions.price, products.price ) AS price FROM products LEFT JOIN promotions ON ( promotions.prodID = products.prodID )

All SQL dates are stored in a standard format... so you have to store it that way too (and you should). You can request it in any way you want.

Don't change how to store it... it was correct. If you want it back different, use DATE_FORMAT().

That's how you search and store them....

I usually just include a parent_uid field, have it NULL for the "parent", and then just left join in as many levels as are needed.

A few things... 1) link1 is a string, not a JS variable. Not that I know where the id variable comes from...? 2) You have quoting issues -- you can't put double quotes in a double quoted string literal, or the parser won't know where the string starts and end. 3) document.write() isn't always the best way to go. 4) You have lots of code duplication -- a hash would be better. 5) No semi-colons? 6) No functions? Something like: <script type="text/javascript"> var sLink = ( hLinks[id] ) ? id : 'DEFAULT'; var hLinks = { 'link1':{ 'id':'link1', 'href':'#', 'src':'page GFX/New_Products/More_offers.jpg' }, 'link2':{ 'id':'link2', 'href':'#', 'src':'page GFX/New_Products/Back_to_start.jpg' }, 'DEFAULT':{ 'id':'default, 'href':'#', 'src':'page GFX/New_Products/default.jpg' } }; var sImageHTML = '<a href="'+hLinks[sLink].href+'" id="'+hLinks[sLink].id+'"><img src="'+hLinks[sLink].src+'"></a>'; document.write( sImageHTML ); </script> Of course, if I were emehrkay, then writing out the HTML code would be method of an custom object ;-)

onclose has strange browser support... there's another thread my jaymc on this topic.

Easy? I find the method they discuss to be very difficult to maintain.

LEFT( speakers, 1 ) will also work.

I'd put parenthesis around your BETWEEN clauses... ANDs and ORs don't mix.

Why not just interconvert?

No it's not... you were *denied* access. Check the grants table for that host.

Don't add the trailing semicolon.

Yeah, that's not very elegant at all.. but you're limited by the denormalization of the source data... and I assume you don't want to fix it during the import. At the very least, make a fulltext index for the notes and use that.

At the risk of sounding stupid, "how/where?" Take a look at the relevant refman page -- this way, you can compare the variables (global is the important one).

That's the right way to build a RegExp object.

Well, the number 101 is arbitrary -- so you know it -- a COUNT(*) will give you other #.

that NOT IN is very expensive... are you running this often, or just as maintenance once?

The error is that you're not showing us the query.

How did you work around this?

You're trying to build HTML from MySQL...

Yes, but the ISO is the default... it's not "detecting" that.

You need to compare the sql modes on the source & destination databases.