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: [My
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 statements.
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
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 BAC
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
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 that
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
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 convert
Help:
$sql = "select id1 from GCN_Salesmen where username = '$PHP_AUTH_USER'";
$user_id = mysql_query($sql) or die(mysql_error());
Produces: You have an error in your SQL syntax near 'id #2' at line 1
$sql = "select id1 from GCN_Salesmen where username = $PHP_AUTH_USER";
$user_id = mysql_quer
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 with
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 ad
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
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
sta
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
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
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 an
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 could
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
- Original Message -
From: "Muhammed Mamedov" <[EMAIL PROTECTED]>
To: "Nikos Gatsis" <[EMAIL PROTECTED]>
Sent: Tuesday, December 16, 2003 3:56 PM
Subject: Re: [PHP-DB] Something ease... I guess
> you will need dynamic variable construction..
> use this
> for($i=1;$i<5;$++) {
> $tmp
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,
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
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
> 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
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
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 bounce
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 HTT
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 stateme
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 ?
http://www.mysql.com/
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 peo
29 matches
Mail list logo
