having a problem with query using multiple sources

2003-03-02 Thread Sunfire
hi.. having a problem with a mysql query where 2 different sources use the same query.. the only problem is that in my where clause i.e.: where '$edit[company]'==$company the $edit[company] is not valid for one of the sources... is there a way to let both sources use the same query like that.. my

case sensitivity in a delete query

2003-03-02 Thread Sunfire
hi i have a delete query that will delete a record based on the company name: delete from members where company='$company'; the query works fine and all but there is a problem because if there is more than 1 company listed but with different use of case in their name then allrecords that match $com

Re: Dumping a database

2003-02-24 Thread Sunfire
yes mysqldump database name >filename.sql where database name is the name of the database to dump and filename.sql is the file to dump it into including a valid pathname.. it will dump everything into the text file as valid mysql statements that will let you run the script again.. actually when yo

Re: Access Denied Help Needed

2003-02-20 Thread Sunfire
if i remember right you should make a hosts file in c:\windows\ dir and thats where it sits.. at least thats where i have mine and it works fine... in the file do this: 127.0.0.1 localhost #or whatever your domain name and ip address is but its #the same format and always include localhost -

@ character appended at end of username problem

2003-02-20 Thread Sunfire
hi.. i have an mysql username that is in the form of an email address and when i use it in my php scripts for some reason i get an error: warning: connection to host failed access denied for '[EMAIL PROTECTED]@' in filename.php on line 4 anybody know what the extra @ is for at the end of the user

Re: With or Without PHP

2003-02-20 Thread Sunfire
yes ther is a mailing list for php/mysql.. they deal with php and any other sql servers out there as well as lots and lots of other stuff out there... it is [EMAIL PROTECTED] but before you send mail to that address subscribe to it by going to www.php.net and finding the right mailing list you need

Re: Are you willing to help?

2003-02-02 Thread Sunfire
i have a windows ME box with .net framework v1.0 and odbcmysql driver 3.5.xxx will this work for your testing? if so i might be willing to try it out and se how it works... let me know in mail off list... tnx - Original Message - From: "Nasser Ossareh" <[EMAIL PROTECTED]> To: <[EMAIL PROT

Re: mysql php and blank variables...

2003-01-29 Thread Sunfire
ok will try that too... - Original Message - From: "Sherzod Ruzmetov" <[EMAIL PROTECTED]> To: "Sunfire" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, January 29, 2003 7:07 AM Subject: RE: mysql php and blank variables... > :wh

mysql php and blank variables...

2003-01-29 Thread Sunfire
hi all.. having a little problem with mysql_query()... for some reason when i type mysql_query("insert into table_name ('$var list'...); i come up with a bunch of blank/empty variables... im using apache 1.3.4x mysql 3.2.3.x wwinME .. any ideas how to fix the problem...? --- Outgoing mail is ce