[PHP-DB] Problem with SQL Server.

Hello, I'm working with a DB SQL Server. This DB has a table with Japanese characters. When I read a field (with Japanese characters) with function mssql_fetch_array(), always it return characters '?'. If I put 'print("(Japanese characters)");', these Japanese characters are shown correctly. My

[PHP-DB] Problem with SQL Anywhere 5.5 and PHP ODBC

Hi everybody, i have a problem with php 4.0 an Sql Anywhere 5.5. The Webserver (Apache), the database and PHP are all installed on the same server( win 2000). PHP is using ODBC to connect to the database. This works if no other programm using the ODBC-connection ! If i start a programm that use th

Re: [PHP-DB] Problem with SQL

Most likely the datatype you are using for the id field is tinyint, auto increment. The tinyint datatype only goes to 127, so once you get to 127, it tries to assign the same value for the next one. Try changing your id datatype to int. HTH Maureen Brtosz Matosiuk <[EMAIL PROTECTED]> sa

RE: [PHP-DB] Problem with SQL

September 2002 10:22 To: [EMAIL PROTECTED] Subject: [PHP-DB] Problem with SQL Hi all SQL gives me a strange error and I can't find any info about it. Mayby someone of you could give me a clue what is wrong. The error is : 'Duplicate entry '127' for key 1' Thanks for any

[PHP-DB] Problem with SQL

Hi all SQL gives me a strange error and I can't find any info about it. Mayby someone of you could give me a clue what is wrong. The error is : 'Duplicate entry '127' for key 1' Thanks for any help -- -= MAdSiuK ([EMAIL PROTECTED]) =- "(...) jestesmy nihilistami, w nic nie wierzymy, doslo

RE: [PHP-DB] Problem with SQL query on several tables

f1 LEFT JOIN f2 ON f1.some_field=f2.some_field > LEFT JOIN f3 > > > > ON f2.some_field=f3.some_field roder by f1.datestamp; > > > >> Regards, > >> Andrey Hristov > >> IcyGEN Corporation > >> http://www.icygen.com > >> BALANCED SOLU

Re: [PHP-DB] Problem with SQL query on several tables

ALANCED SOLUTIONS >> >> >> ----- Original Message - >> From: "Rosen" <[EMAIL PROTECTED]> >> To: <[EMAIL PROTECTED]> >> Sent: Tuesday, November 27, 2001 5:34 PM >> Subject: [PHP-DB] Problem with SQL query on several tables >&g

Re: [PHP-DB] Problem with SQL query on several tables

>BALANCED SOLUTIONS > > >- Original Message - >From: "Rosen" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Tuesday, November 27, 2001 5:34 PM >Subject: [PHP-DB] Problem with SQL query on several tables > > >> Hi, >> I'

Re: [PHP-DB] Problem with SQL query on several tables

, Andrey Hristov IcyGEN Corporation http://www.icygen.com BALANCED SOLUTIONS - Original Message - From: "Rosen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, November 27, 2001 5:34 PM Subject: [PHP-DB] Problem with SQL query on several tables > Hi, &g

[PHP-DB] Problem with SQL query on several tables

Hi, I'm trying to execute SQL query: "select * from f1,f2,f3 order by datestamp" MySQL returns me an error: "1052 - Column: 'datestamp' in order clause is ambigious" The tables f1,f2,f3 have some structure. The field "datestamp" is type datetime. Why I can't order query on 'datestamp' ? Thanks