[PHP-DB] Distinct with Order By

I'm looking for the last six different people to make entries to a table, but this syntax: SELECT DISTINCT Poster_ID FROM Posting ORDER BY Posting_Date DESC LIMIT 6; Gives a result which is absolutely not ordered by date. Removing the DISTINCT keyword results in a correct list of the last six

RE: [PHP-DB] Max DB as Database for PHP

You could try ODBC instead. Neil Morgan -Original Message- From: Morten Gulbrandsen [mailto:[EMAIL PROTECTED] Sent: 16 December 2003 05:45 To: [EMAIL PROTECTED] Subject: [PHP-DB] Max DB as Database for PHP Hello, Has anyone tried to connect to MaxDB with PHP ?

RE: [PHP-DB] sql errors?

is register_globals set to off in php.ini? this may be the issue if it is set to on. -Original Message- From: Jas [mailto:[EMAIL PROTECTED] Sent: 15 December 2003 22:50 To: [EMAIL PROTECTED] Subject: [PHP-DB] sql errors? I have checked and rechecked my code on these php to mysql

[PHP-DB] ibase_fetch_* = request sync. error

Hi ! Habe folgendes Problem : Jeder Aufruf der Funktion ibase_fetch_assoc() resultiert in dem Fehler Request Synchronization Error. Ich habe es auch schon mit der anderen Variante ibase_fetch_object() probiert. Die lieferte die gleiche Fehlermeldung. Die Skripte laufen lokal auf einem APACHE HTTP

[PHP-DB] Re: php mail() question

Hi, Are you using the test_pop3.php file that you showed me with the script that handles the bounced emails? If so, could you please show me a basic example of it working with it? My return_path is set as an email alias. (not a real address at the domain) [EMAIL PROTECTED] So that

[PHP-DB] MySQL Field length

Hi, What is the maximum length for the name of a column in MySQL? Thanks for your help -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: MySQL Field length

Hi, What is the maximum length for the name of a column in MySQL? Thanks for your help http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Legal_names -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Something ease... I guess

Hello list I have 4 variables, $check1, $check2, $check3, $check4 How can i use a for loop to echo each one. (lets say echo $check($i)...) Thanx -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] method question

I am looking to create a comp-time calculator of sorts using PHP/MySQL. I am still in the learning process of how all of this works. I want to be able to create a web interface where my employee can login and enter her comp-time as she works extra. I also want to be able to have an admin side

Re: [PHP-DB] Something ease... I guess

El Mar 16 Dic 2003 10:44, Nikos Gatsis escribió: Hello list I have 4 variables, $check1, $check2, $check3, $check4 How can i use a for loop to echo each one. (lets say echo $check($i)...) foreach(list($check1, $check2,...) AS $c){ echo $c; } -- 15:20:02 up 16 days, 21:36, 3

Re: [PHP-DB] Something ease... I guess

Thanx everybody It was easy indeed! - Original Message - From: Martin Marques [EMAIL PROTECTED] To: Nikos Gatsis [EMAIL PROTECTED]; PHP-mailist [EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 3:55 PM Subject: Re: [PHP-DB] Something ease... I guess El Mar 16 Dic 2003 10:44, Nikos

[PHP-DB] Architecture Question - Opinion

All, I am considering moving to a true 3-tier structure where the web server does not have direct access to the database server - many times a government requirement. I want to keep the PHP front end and use an application server (middle tier) to handle all the DB calls and sessions. I

[PHP-DB] Re: Architecture Question - Opinion

Paul Miller wrote: All, I am considering moving to a true 3-tier structure where the web server does not have direct access to the database server - many times a government requirement. I want to keep the PHP front end and use an application server (middle tier) to handle all the DB calls

[PHP-DB] Query Sum problem

I need to sum the field *COST* in this query where data in *STATUS* is equal to HELD and OPEN, so I will have 2 totals passed below and do not know where to begin . All information is in 1 table. Original query select distinct(Company_name), account, City, State from table where number =

RE: [PHP-DB] Re: Architecture Question - Opinion

That is the major issue at hand, the slow Live DB calls. Is there any way around it while maintaining the constraints listed below using another method of standard communication. Is the slow going to be unacceptable? I used SOAP to call an off site document server and that was slow. I do not

Re: [PHP-DB] Query Sum problem

From: Larry Sandwick [EMAIL PROTECTED] I need to sum the field *COST* in this query where data in *STATUS* is equal to HELD and OPEN, so I will have 2 totals passed below and do not know where to begin . SELECT status, SUM(cost) FROM Table WHERE status IN ('HELD','OPEN') GROUP BY status

[PHP-DB] Query Problem

I need to sum the field *COST* in this query where data in *STATUS* is equal to HELD and OPEN, so I will have 2 totals passed below and do not know where to begin . All information is in 1 table. Original query select distinct(Company_name), account, City, State from table where number =

Re: [PHP-DB] Query Sum problem

From: Larry Sandwick [EMAIL PROTECTED] I appreciate the quick response, but I should have been more clear. I understand the query below, but I would only have 2 total and it is not group by the companies. The query below gives me the main information without totals. How do I add the 2

[PHP-DB] Hello

Hi everybody, i'm new in this list, so let me introduce my self. My name is Rodrigo and i'm from brazil, so sorry if my english isnt correct. let me know know if there's anothers brazilians here. And i'd like to starting using this to ask about some tutorial or something like that to help me

[PHP-DB] Where's the mix-up?

Help: snip $sql = select id1 from GCN_Salesmen where username = '$PHP_AUTH_USER'; $user_id = mysql_query($sql) or die(mysql_error()); /snip Produces: You have an error in your SQL syntax near 'id #2' at line 1 snip $sql = select id1 from GCN_Salesmen where username = $PHP_AUTH_USER; $user_id =

[PHP-DB] Creating temp tables in MSSQL

Hi all, I've been handed a query which I'm trying to get to work. I'm using PHP to talk to MSSQL 7. My question is this: Can I create temp tables with mssql without executing the code in a stored procedure? The simplified version of the query is as follows: $query = SELECT distinct

Re: [PHP-DB] Creating temp tables in MSSQL

Hi, Any table that starts with # is a temp table. You can use create table #mytemp (...) or you should be able to use the query you suggest. You just have to make sure you have enough space in tempdb (a system database) - Frank Hi all, I've been handed a query which I'm trying to get to

[PHP-DB] Re: php mail() question

Jerry, Actually I just relised what you meant. :P And that would work great by having it like that.. Something like this would work fine. If the email bounces return it to [EMAIL PROTECTED] So I would set the sender as whatever I want and the return_path as a way to identify the user? Is

[PHP-DB] Query and math

Hi, q1) i got a database with 2 diffrent tables, i want to take out all the information that arent duplicated from on of the tables, like this: $sql = SELECT t1.rubrik, t1.info, t2.priser FROM table1 AS t1, table2 AS t2 WHERE t1.arkiv = '0' ORDER BY t1.rubrik; the problem is that i got alot of

[PHP-DB] mssql and resource handling

I have a fairly common problem that I have not been able to find the solution for in the documentation and FAQs. I have to access a MSSQL box from a LAMP box using PHP. That part works fine (thank you freetds.org). I need to display results from user queries 10 at a time with the basic NEXT and

[PHP-DB] Re: php mail() question

Hello, On 12/16/2003 10:04 PM, Jerry wrote: Actually I just relised what you meant. :P And that would work great by having it like that.. Something like this would work fine. If the email bounces return it to [EMAIL PROTECTED] So I would set the sender as whatever I want and the return_path as a

Re: [PHP-DB] mssql and resource handling

Michael, Don't store resources in your session. They die when the page is finished rendering. Variables you can store in your session. Even objects can be stored in your session. But do not store resources. I would suggest a couple of things. 1: Use ADOdb instead of just raw my_sql

[PHP-DB] odbc_connect() failure

I'm running the MySQL-supplied MyODBC driver (3.51) on top of iodbc on OS X 10.3.1. I am running Apache 2.0.48, MySQL 4.0.15, and PHP 4.3.4. I am making the following call: $odbc_id = odbc_connect(myodbc3, root, x); I get the following result: Warning: odbc_connect(): SQL error: