[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 [EMA

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 equiva

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? - c

Re[2]: date problem

he >> line >> from your insert 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 clobber

Re[2]: date problem

on the machine? MS> -ms MS> -Original Message- MS> From: nobody [mailto:[EMAIL PROTECTED] MS> Sent: Sunday, March 23, 2003 12:56 PM MS> To: [EMAIL PROTECTED] MS> Subject: date problem MS> Hello mysql, MS> I do this: MS> $query = "INSERT INTO news(ID,

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

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 files\ap

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='$ItemDesc

mysql@lists.mysql.com

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