[SOLVED]Re: LEFT JOIN problem

Thanks Roger That fixed the problem.I was under the impression that I only had to put the linked columns n the ON and everything else in the WHERElive an learn I guess. Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] There are 10 kinds of people in this world, those who

Re: unable to connect after log in

Hi Have you tried using mysql_connect instead of mysql_pconnect? Does it make any difference? Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] There are 10 kinds of people in this world, those who understand binary and those who don't (Unknown) - Original Message - From:

Re: Moving databases

Off the top of my head:) In the my.cnf file under the [mysqld] section add the following line: datadir= /path.to/new/datadir Stop mysql. Move all dbs to new datadir (if your'e only using MYISAM, this is a straight copy). Restart mysql. HTH Rory McKinley Nebula Solutions +27 82 857 2391

Re: newbie select statement question

I am not sure if this has any significance - but isn't 31 Dec 1969 the day before the UNIX epoch (1 Jan 1970 - i think)? Jordan, how are the dates stored in the database - as dates or unix timestamps? Also, the function fixDate isn't in the online PHP manual - is it a function defined by you? -

Re: [MYSQL] Combine tables from two different systems

Hi Paul If all the tables have a primary key set, you can do an INSERT IGNORE from the tables in System A to the tables in System B (either manually or write a script). Any rows form System A that already have a System B equivalent will be silently dropped and only those that do not have an

date problem

Hello mysql, I do this: $query = INSERT INTO news(ID, author, title, text, date) VALUES(NULL, '.$_SESSION[ulogged].', '.$title.', '.$text.', UNIX_TIMESTAMP(NOW())); $result = mysql_query($query, $connection) or die(problem with query); I get this: mysql select * from news where id='1';

Re[2]: date problem

Month = 03 MS Date = 23 MS Hour = 22 (or 10pm) MS Minute 56 MS Seconds 45 MS Someone else on the list: where or how is the timezone encode, or this is MS entry in GMT? Is there a way to determine the local timezone on the machine? MS -ms MS -Original Message- MS From: nobody [mailto

Re[2]: date problem

statement is DR Nope, that's a MySQL timestamp. DR UNIX_TIMESTAMPS are # of seconds from the epoch (Jan 1 1970). DR nobody [EMAIL PROTECTED] is trying to store an INT in a timestamp column and DR probably clobbering his values. 20030323225645 If we break this apart, we see: Year = 2003

Re: Updat not Updating

Hello Andrew, Friday, March 14, 2003, 6:18:15 PM, you wrote: A Can anyone tell me why this is not updating records for this table? A mysql_connect($DBHost,$DBUser,$DBPass); A mysql($DBName,UPDATE items A SET ItemSKU='$ItemSKU', A ItemName='$ItemName', A ItemDescription='$ItemDescription', A

Re[2]: Updat not Updating

Hello Andrew, Friday, March 14, 2003, 7:41:56 PM, you wrote: A yes you are right an I am very stupid for not doing this: It is very important A for debugging as I now have this error :):) A Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in A c:\program

synopsis of the problem (one line)

Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:root Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: