Hi there,
When i try to do the following in PHP I get errors. Is this not permitted or
is this due to a setting somewhere? Can i do only one SQL statement per call
to mysql_query?
$sql = CREATE TEMPORARY TABLE tmp
SELECT field1_index, field2_index FROM test_table WHERE field1_index = '1';
Edison Cneeden [EMAIL PROTECTED] wrote:
Hi there,
When i try to do the following in PHP I get errors. Is this not permitted or
is this due to a setting somewhere? Can i do only one SQL statement per call
to mysql_query?
Yes.
$sql = CREATE TEMPORARY TABLE tmp
SELECT field1_index,
As far as I'm aware, in php you can only do one statement per call.
Terry
--Original Message-
Hi there,
When i try to do the following in PHP I get errors. Is this not
permitted or is this due to a setting somewhere? Can i do only one SQL
statement per call to
I have a mysql dbase.
I use a time field to save a number of hours (think about number of
houres spent out of office, or anything else).
A table holds the global values for people and their status, another
table holds every single entry of data, so
john smith 5 hours and 2 minutes outside on
On Sunday 02 December 2001 23:18, Venu wrote:
snip
in themysql monitor. It *shows* when I run isql -v m97.
I have modified /etc/odbc.ini and /etc/odbcinst.ini and /etc/odbc.ini as
snip
The problem is that, unixODBC is not able to find your MyODBC
DSN entry. This is probably due to the fact
I am new to both PHP and MySQL (I have experience in ASP) and am trying
to get my server running both. I can connect to the MySQL server under
DOS using the command line and can create new databases this way. I want
to create a web data site so I need to accomplish this via HTML. I have
tried to
At 4:50 PM +1000 9/15/01, mike wrote:
I am new to both PHP and MySQL (I have experience in ASP) and am trying
to get my server running both. I can connect to the MySQL server under
DOS using the command line and can create new databases this way. I want
to create a web data site so I need to