RE: MySql, PHP and Javascript

2003-01-31 Thread Hoffman, Geoffrey
Absoulutely. Since PHP is server-side you can write javascript dynamically on the fly which are then executed client-side. Here's a simple example: var today = ''; > -Original Message- > From: Steve Davies [mailto:[EMAIL PROTECTED]] > Sent: Friday,

RE: Getting Images in and out of a Blob

2003-01-31 Thread Hoffman, Geoffrey
You might find this helpful - I did. http://www.phpbuilder.com/columns/florian19991014.php3 > > > Has anyone done any work with getting images into and out of a MYSQL > > database? I have used mysql for some time, but never > stored an image > in a > > blob field. -

RE: good manner for handling multiple languages dynamic websites

2003-01-25 Thread Hoffman, Geoffrey
Bear in mind that I've never attempted a multilingual website, but the first thought that I had when I read your post was to have a table name extension that gets appended based on the user's language choice/locale/whatever: $langext = "_en";// english // $langext = "_de"; // german // $lan

RE: Need nulls in my join

2003-01-25 Thread Hoffman, Geoffrey
PHP loop, but it works fine for now. Thanks though - I'm sure I'll use your suggestion somewhere in the app I'm working on. Geoff > -Original Message- > From: Loren McDonald [mailto:[EMAIL PROTECTED]] > Sent: Saturday, January 25, 2003 1:41 PM > To: Hoffman, Ge

Need nulls in my join

2003-01-24 Thread Hoffman, Geoffrey
I have an SQL query that LEFT JOINs four different tables to a main table, based on several foreign keys. It's returning only stories in a section that have photos, but I need it to return all the stories in a section whether it has a photo or not. I think the problem is in the WHERE evtphoto

Whats the best way to manage 'generic two-way relationships'?

2003-01-17 Thread Hoffman, Geoffrey
I couldn't think of a better term for what I want to do... I am building a CMS for news stories. Often news stories are related to each other, or need to be grouped by content. I need a simple way to manage storyId relationships - in both directions. Thinking about the business logic to implemen

RE: --- Best ISP for MySQL & PHP ???

2003-01-17 Thread Hoffman, Geoffrey
I've had great luck with both: http://linuxwebhost.com and http://onsmart.net WS> From: Will Standley [mailto:[EMAIL PROTECTED]] WS> Sent: Friday, January 17, 2003 7:45 AM WS> Subject: --- Best ISP for MySQL & PHP ??? WS> I'm looking for an ISP to host a couple of MySQL db's... WS> Will be usin

RE: Confirmation of SELECT...IN syntax

2003-01-15 Thread Hoffman, Geoffrey
you are correct - subselects are NOT allowed until version 4 until then: SELECT t1.* FROM table1 t1 LEFT JOIN t2 ON t1.id = t2.id OR SELECT t1.* FROM table1 t1 LEFT JOIN t2 USING (id) > -Original Message- > From: Doug Beyer [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, Janua