Bevan Christians wrote:
Is there any to query a mysql table to get it to return the field
names that it currently
has marked as Fulltext Indexes?
|SHOW COLUMNS FROM sometable
-Stut
|
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Anyone have any idea how i can query the tables in order to get it to
return the indexes
show indexes from tablename;
http://dev.mysql.com/doc/refman/5.0/en/show-index.html
--
Postgresql php tutorials
http://www.designmagick.com/
--
PHP Database Mailing List (http://www.php.net/)
To
thanks muchly for the help guys :D
On 24/05/06, Chris [EMAIL PROTECTED] wrote:
Anyone have any idea how i can query the tables in order to get it to
return the indexes
show indexes from tablename;
http://dev.mysql.com/doc/refman/5.0/en/show-index.html
--
Postgresql php tutorials
LOAD DATA INFILE 'persondata.txt' INTO TABLE persondata (col1,col2,...);
Syntax isn't quite correct with field and line terminators specified.
You must also specify a column list if the order of the fields in the
input
file differs from the order of the columns in the table. Otherwise,
MySQL
Greets,
I'm trying to use the load data infile syntax within a php script. The data
is in csv format. I was under the impression that I could reorder the
fields during the insert, such as:
load data infile 'currentData.txt' into table(fieldName2, fieldName1)
fields terminated by ','; The stuff
Am Dienstag, 16. Mai 2006 17:40 schrieb [EMAIL PROTECTED]:
Greets,
I'm trying to use the load data infile syntax within a php script. The data
is in csv format. I was under the impression that I could reorder the
fields during the insert, such as:
load data infile 'currentData.txt' into
Am Dienstag, 16. Mai 2006 17:40 schrieb [EMAIL PROTECTED]:
I'm trying to use the load data infile syntax within a php script. The
data
is in csv format. I was under the impression that I could reorder the
fields during the insert, such as:
load data infile 'currentData.txt' into
Hi,
I've been searching all day through all the reasources i can find for a
pointer in the right direction. I've just started a clean install of my
LAMP system, and got to PHP. On ./configure it goes through all the
normal processes untill it reaches the -lmysqladmin line, where it kicks
out
Hello, I'm unsure how to write the follow query, Please can someone assist.
I am writing in short hand the basis of the two queries I would like to
combine. The object is to select all the products that have not meet the min
sale requirements so I can send myself a reminder email.
The first
I have run into an issue where I keep getting InnoDB tables everytime I create
a new table in PHPMyAdmin, and I want MyISAM tables. It's very annoying. Anyone
got any suggestions as to what I might have done that made MySQL or PHPMyAdmin
do this?
--
Mark Benson
--default-storage-engine option in your options file (my.ini) where
engine is the the type of table engine you want to use, in your case MYISAM.
If you cant change that then specify the engine type every time you
create a table:
create table table_name{
.
} TYPE=myisam;
Regards
I have been using MySQL for quite some time and am now running Server 4.1. I
have been developing custom web-based software for a customer and recently
moved their server to a different machine. I have everything running
smoothly EXCEPT for mySQL. Any time I try to start the service I get an
I have been using MySQL for quite some time and am now running Server
4.1. I
have been developing custom web-based software for a customer and
recently
moved their server to a different machine. I have everything running
smoothly EXCEPT for mySQL. Any time I try to start the service I get an
Hello,
I hope somebody can assist. I am using dreamweaver 8, Mysql, PHP5 for a
simple we application. After using the dreamweaver wizard to make a
connection, then created a recordset. Trouble starts when I use
require_once(connections/ConnSAFDEM) to link to the database connection
file. I get
On 3/14/06, Eustace [EMAIL PROTECTED] wrote:
Hello,
I hope somebody can assist. I am using dreamweaver 8, Mysql, PHP5 for a
simple we application. After using the dreamweaver wizard to make a
connection, then created a recordset. Trouble starts when I use
require_once(connections/ConnSAFDEM)
To: [EMAIL PROTECTED]
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] Mysql/PHP5 connection error
On 3/14/06, Eustace [EMAIL PROTECTED] wrote:
Hello,
I hope somebody can assist. I am using dreamweaver 8, Mysql, PHP5 for
a simple we application. After using the dreamweaver wizard to make
\safdem_web\Admin\Connections\connSAFDEM.php
because that's what the server is looking for.
-Original Message-
From: chris smith [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 14, 2006 12:04 PM
To: [EMAIL PROTECTED]
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] Mysql/PHP5 connection error
Never trust DW to do the testing for you. I never user DWs built in server
stuff to test...create it and then test it thru the browser like it would
actually operate.
Bastien
From: Eustace [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: RE: [PHP-DB] Mysql
Hi,
Apologies if this isn't the right place to ask - but I'm banging my head
against the wall with this one!
I'm trying to update a record in the table (creation script below) using the
following SQL statement:
UPDATE shop_customer SET eu_vat_number = SK1234567890 AND vat_amount = 0
AND
You need to separate the SET arguments with commas, not ANDs...
It's really doing something like this:
UPDATE shop_customer SET eu_vat_number = (SK1234567890 AND vat_amount = 0
AND total_amount = 8.4925) WHERE customer_id = 7 AND hash=dcd5e751
(SK1234567890 AND vat_amount = 0 AND total_amount =
Message-
From: Jenaro Centeno Gómez [mailto:[EMAIL PROTECTED]
Sent: 04 March 2006 17:35
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MySQL update statement problem
Maybe I am wrong, biut isn´this the rigth way to do this:
UPDATE shop_customer SET eu_vat_number = SK1234567890, vat_amount =
0
(Previous sending failed for some reaseon!)
Hello,
I suppose i am not the only one who has got that problem about transferring
site
database to MySQL 4.1x and to utf8 charset. Before it was MySQL 3.23 and
latin1.
I have read this article Turning MySQL data in latin1 to utf-8 on
Forgive me that this isn't really PHP related, but solely MySQL.. but
the MySQL mailing lists drive me nuts and figured someone here would
have a quick answer.
I'm trying to sort by a date and time field(s) (two separate fields).
It's a dumb system but until we do the next revision, it's
. You can
also add ASC or DESC for Ascending or Dscending as desired.
N.B. the ORDER BY statement must be the last part of you query!
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 17 January 2006 16:42
To: php-db@lists.php.net
Subject: [PHP-DB] MySQL date
Ahh! Thank you Philip! That's what I was looking for! I see what I did wrong
now.
I was using the date format strings wrong. I was using it like I'd use it for
DATE_FORMAT() instead of as an input filter.
This is what I was trying to do:
select STR_TO_DATE('2003-11-05 06:00 PM', '%Y-%m-%d
Youcould also try CASTing
(http://dev.mysql.com/doc/refman/5.0/en/cast-functions.html) the data
Bastien
From: [EMAIL PROTECTED]
To: php-db@lists.php.net
CC: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MySQL date casting..
Date: Tue, 17 Jan 2006 12:51:44 -0500
Ahh! Thank you Philip! That's
. .$queryresult. rows were
altered.;
}
echo $msg;
Hope this helps.
Rich
-Original Message-
From: maestro [mailto:[EMAIL PROTECTED]
Sent: Friday, November 25, 2005 1:11 PM
To: php-db@lists.php.net
Subject: [PHP-DB] MySQL Update Quandry
Greetings,
I am doing an update
Subject: [PHP-DB] MySQL Update Quandry
Greetings,
I am doing an update to a table as such:
class DB {
function updateMember($email, $password, $postalCode,
$language, $id, $word) {
...
if (!(@ mysql_query($query, $connection))) {
$this-errors = array
Greetings,
I am doing an update to a table as such:
class DB {
function updateMember($email, $password, $postalCode,
$language, $id, $word) {
...
if (!(@ mysql_query($query, $connection))) {
$this-errors = array(mysql_errno(), mysql_error());
Hi,
I'm tring to run this query to find orphan entries.
SELECT c.eventid, e.ID
FROM col_links c left outer join calendar_v2 e
ON c.eventid = e.ID
LIMIT 0, 999;
Then I have to scan the list to find entries where
e.ID equals NULL.
I was wondering if anyone know how to expand this
query with a
SELECT c.eventid, e.ID
FROM col_links c left outer join calendar_v2 e
ON c.eventid = e.ID
where e.id is null
LIMIT 0, 999;
From: Keith Spiller [EMAIL PROTECTED]
To: [PHP-DB] php-db@lists.php.net
Subject: [PHP-DB] MySQL Query
Date: Sat, 19 Nov 2005 19:29:25 -0700
Hi,
I'm tring to run
Multiple query can only be done in PHP 5 with MySQLI extension.
In PHP 4 maybe you can use an array to store the query and execute each
query with foreach :
?php
$query[] = UPDATE bla.. bla..;
$query[] = UPDATE bla.. bla..;
$query[] = UPDATE bla.. bla..;
foreach ($query as $eachquery){
I have a php function that creates the following SQL below with this
statement in the loop:
~~~
$myQuery .=UPDATE page SET
page_order_id = \$page_order_id\
WHERE page_id
You can't stack queries this way. PHPMyAdmin parses out the queries based on
the ';'. You will need to run the query after each one is created.
Bastien
From: Malcolm JC Clark [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] MYSQL IN A PHP LOOP
Date
Ive heard that mysql 5 now supports stored procedures. Can you call
these from PHP? or is it too early to expect functionality already?
Mark
--
This message is best viewed with your eyes.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Thanks a lot. Ive just been reading them up on the MySQL website, and
they seem really useful, so this really helps.
Mark
On 03/11/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
It is possible using PHP 5. Simply make a query like this:
Select name_of_procedure(parameter1,parameter2,...);
Hi,
I'm new to PHP and am wondering how I might be able to use MySQL with
JavaScript. I was thinking that I could use PHP to convert a query from a
database into a XML file, and then use JavaScript to access the results from
the XML file.
The only thing is that I'm not sure how fast PHP is on a
, believe me,
it is.
Alternatively look up the error code, although I don't know if that would've
helped in this case.
-Original Message-
From: W Roothman [mailto:[EMAIL PROTECTED]
Sent: 13 October 2005 06:18
To: php-db@lists.php.net
Subject: [PHP-DB] MySQL Connect using Dreamweaver
Dear
PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] MySQL Connect using Dreamweaver
Date: Thu, 13 Oct 2005 07:17:56 +0200
Dear All,
I have installed MySQL 5 with PHP 4.3.3.
When trying to connect to a database form the 'Database' tab in
Dreamweaver, I now get the following error when trying to select
Dear All,
I have installed MySQL 5 with PHP 4.3.3.
When trying to connect to a database form the 'Database' tab in Dreamweaver, I
now get the following error when trying to select a DB:
'1251 Client does not support authentication protocol requested by server;
consider upgrading MySQL client'
Hi,
Im trying to get a query result from mysql database to
show it on a flash animation, so far i have this code
that its supposed to connect to mysql server , make
the query and get the results, store them on variables
so that flash can read them. Basically i have these
main fileds like :
Hi,
Im trying to get a query result from mysql database to
show it on a flash animation, so far i have this code
that its supposed to connect to mysql server , make
the query and get the results, store them on variables
so that flash can read them. Basically i have these
main fileds like :
Hi,
Im trying to get a query result from mysql database to
show it on a flash animation, so far i have this code
that its supposed to connect to mysql server , make
the query and get the results, store them on variables
so that flash can read them. Basically i have these
main fileds like :
The code looks correct so my guess is that you are parsing it inorrectly in
actionscript...
Bastien
From: Juan Stiller [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] MySQL query result with some errors!
Date: Tue, 11 Oct 2005 18:14:42 -0300 (ART)
Hi,
Im trying to get a query
I have problem with MySQL in PHP 5.0.4 (WIN XP). I use charset cp1250
(win-1250, Czech) and PHP5 show results from db in incorect charset. When i
use PHP 4, there is no problem! Configuration MySQL server is in both case
the same.
--
PHP Database Mailing List (http://www.php.net/)
To
I have problem with MySQL in PHP 5.0.4 (WIN XP). I use charset cp1250
(win-1250, Czech) and PHP5 show results from db in incorect charset. When i
use PHP 4, there is no problem! Configuration MySQL server is in both case
the same.
--
PHP Database Mailing List (http://www.php.net/)
To
does your web server, php and db all use the same charset? they all should
match
From: Dominik Fi¹er [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] MySQL in PHP5 - problem with charset
Date: Sun, 11 Sep 2005 14:35:44 +0200
I have problem with MySQL in PHP 5.0.4 (WIN XP). I
:[EMAIL PROTECTED]
does your web server, php and db all use the same charset? they all should
match
From: Dominik Fi¹er [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] MySQL in PHP5 - problem with charset
Date: Sun, 11 Sep 2005 14:35:44 +0200
I have problem with MySQL in PHP 5.0.4
Hi all, I have a problem with mysql:
this code produce a not valid mysq resource.
$sql=select distinct des_riga, count ( des_riga ) as freq from k_riga
where id_tabella= . $id_tabella . and id_colonna= . $id_colonna .
group by des_riga order by des_riga;
$query=mysql_query ($sql, $connessione);
try adding some debug code to the statement execution
$query=mysql_query ($sql, $connessione) or die (error is .mysql_error());
to get an error message that can help debug the query
bastien
From: Marco Strullato [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] mysql not valid
AM
To: php-db@lists.php.net
Subject: [PHP-DB] mysql not valid resource
Hi all, I have a problem with mysql:
this code produce a not valid mysq resource.
$sql=select distinct des_riga, count ( des_riga ) as freq from k_riga
where id_tabella= . $id_tabella . and id_colonna= . $id_colonna .
group
: [PHP-DB] mysql not valid resource
Hi all, I have a problem with mysql:
this code produce a not valid mysq resource.
$sql=select distinct des_riga, count ( des_riga ) as freq from k_riga
where id_tabella= . $id_tabella . and id_colonna= . $id_colonna .
group by des_riga order by des_riga;
$query
Hi,
It is possible to use mysqli_connect and the others mysqli functions in
PHP4? I have downloaded the PHP4 and compiled using these parameters on my
MacOSX:
./configure --prefix=/usr/local/php4compiled
--with-apxs=/usr/sbin/apxs
--enable-mbstring
--with-xml
--with-mysql=/usr/local/mysql
4 does not come with the mysqli extension. You would need to download it
(seprately or as part of the php5 module) and then move the extension
aapropriate folder...
Bastien
From: Andre Matos [EMAIL PROTECTED]
To: 'PHP-mailist (PHP-mailist)' php-db@lists.php.net
Subject: [PHP-DB] MySQL 4.1
Anyone using MySQL 4.1 as a backend to their PHP apps? I'm particularly
interested in the cluster software that the docs say are part of 4.1. I
have some apps that would benefit from a high uptime db backend but I'm a
bit concerned about the 'not enterprise-ready' disclaimer on the mysql
On Thu, June 30, 2005 9:05 pm, blackwater dev said:
Does anyone know if it is possible to load data into multiple
tables using one file when you use load data local infile?
That is not possible.
I need to load several tables but don't want to have tons of files.
You may need to change your
Does anyone know if it is possible to load data into multiple tables
using one file when you use load data local infile? I need to load
several tables but don't want to have tons of files.
Thanks!
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
Hi
I have two MySQL databases, on for aeromodelistas (aeromodelling) and
another for Códigos Postais (Postal Codes). I whant to do the
following query
SELECT CódigoPostal FROM Aeromodelistas
WHERE CódigoPostal IN
(SELECT distinct(CP4) FROM codigopostal.LOCART,codigopostal.DISTRITO
WHERE
This is what I use when needing to do this:
1. Put all the values you want to search for in an array $vals (loop
around the first result)
2. $query =
select count(Nome) from Aeromodelistas
where year(AnoQuota)=2005
and Sexo='Masculino' and Distrito IN .sqlIn($vals)
;
function
Ok here's a dummy question from yet another newbie:
Reading the instructions for enabling the MySQL Functions, I understood
until i get to this:
For compiling, simply use the --with-mysql[=DIR] configuration option where
the optional [DIR] points to the MySQL installation directory.
i have a
with the above code -- but this should get
you to the place where you can work it out.
Mark Cain
- Original Message -
From: [EMAIL PROTECTED]
To: php-db@lists.php.net
Sent: Friday, June 24, 2005 5:25 AM
Subject: [PHP-DB] mysql check boxes
Dear Friends,
I have mysql database and php script
Message -
From: [EMAIL PROTECTED]
To: php-db@lists.php.net
Sent: Friday, June 24, 2005 5:25 AM
Subject: [PHP-DB] mysql check boxes
Dear Friends,
I have mysql database and php script.
Script pulls all the data with their serial number in html form, from
database however, I want each field
I created a PHP based mailing list that sends out a Bible verse and a
quotation each day. Today's verses were:
Bible verse of the day:
Matthew 17:19-21 Then the disciples came to Jesus privately and said, Why
could we not cast it out? And He said to them, Because of the littleness
of your
On Thu, 9 Jun 2005, Ron Piggott wrote:
I created a PHP based mailing list that sends out a Bible verse and a
quotation each day. Today's verses were:
[snip]
Let me show you some code:
It selects a Bible verse:
SELECT * FROM bible ORDER BY RAND() LIMIT 1
On a side note, this is going to
have a look at http://www.webmasterworld.com/forum88/3653.htm
hope this helps!
Mike
ioannes wrote:
I usually use INNER JOIN to link tables together in a straight line,
like a branch. Can I use it to link tables like twigs stemming off
the branch. If so, do I use:
SELECT
TABLE1.FIELD,
I usually use INNER JOIN to link tables together in a straight line, like a
branch. Can I use it to link tables like twigs stemming off the branch. If
so, do I use:
SELECT
TABLE1.FIELD, TABLE2.FIELD, TABLE3.FIELD
FROM
(
TABLE1 INNER JOIN TABLE2
ON TABLE1.FIELD =TABLE2.FIELD
)
INNER JOIN
Hi,
I've got question on using LOCK TABLES with MySQL and PHP.
I don't have a great understanding of LOCK TABLES, but I'll lay out my
situation:
I've got a table and a PHP function to rebuild several columns in this
table. I need to read these columns from the database (all of them) and
At 09:01 PM 5/1/2005, Chris wrote:
Hi,
I've got question on using LOCK TABLES with MySQL and PHP.
I don't have a great understanding of LOCK TABLES, but I'll lay out my
situation:
I've got a table and a PHP function to rebuild several columns in this
table. I need to read these columns from
Miles Thompson wrote:
At 09:01 PM 5/1/2005, Chris wrote:
Hi,
I've got question on using LOCK TABLES with MySQL and PHP.
I don't have a great understanding of LOCK TABLES, but I'll lay out
my situation:
I've got a table and a PHP function to rebuild several columns in
this table. I need to read
I seek for a MySQL newsgroup, can anybody help me?
Martin
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I am using mysql 4.1 and php 5.0 in my WINDOWS XP. I
am trying to use it. But, this error msg eccurs.
Fatal error: Call to undefined function
mysqli_connect() in c:\Inetpub\wwwroot\mysql_up.php
Anyone can help me?
Thank you.
__
Do You Yahoo!?
On Thursday 21 April 2005 13:41, Ong Teng Siong wrote:
I am using mysql 4.1 and php 5.0 in my WINDOWS XP. I
am trying to use it. But, this error msg eccurs.
Fatal error: Call to undefined function
mysqli_connect() in c:\Inetpub\wwwroot\mysql_up.php
Your PHP installation does not support the
I have 2 tables employees transactions. 'employees' carry info about the
employees and transactions carry there payslip info for each period.
I am trying to display a list of employees that don't have transactions in
the current ($pp_id) period,
thus doing an array of the $emp_ids, having
I am still new to this, but I turned the manual upside down, or at least I
tried.
I am designing a payroll application by which payslips can be processed for
each employee for each period.
The problem lays where I would like to display a list of employees that
don't have transactions
Hi,
I've been trying to get MySQL 5 installed with php-5.0.4(windows). I'm
getting several messages about entry points not being found in dlls etc
etc. Am I being over optimistic to expect this configuration to work?
Indeed has anyone got it working? If it should work, I'll press on and
When checking for unmatched records, you use a left join as you are
doing. This assures all records are retained from the left side table
(i.e. employees), regardless if there is a matching record or not.
Obviously if you have a filter on the left side table it will narrow
down the result.
Get those with transaction into a php array
Get those without transaction into a php array
Then use array_diff() (or one of its variants)
graeme.
jinxed wrote:
I am still new to this, but I turned the manual upside down, or at least I
tried.
I am designing a payroll application by which payslips
Hello,
First time on this list, I generally use the general PHP list... but I was
curious if alot of people are using SQL CACHE with MySQL and PHP and
does it seem to increase the performance... or lighten the load on mysql for
you?
Thanks
Joe
Hello,
We are working to optimize a few queries. When we run the query with
Explain, it appears that the query optimizer is not using one of the
tables index and doing a full table scan while it appears to use other
tables' indices properly. We then remove the table with the full
scan, run
table join into 3 queries and application based arrays, I
reduced the run time to about 10 seconds with 50x the output.
Bastien
From: Eddie Peloke [EMAIL PROTECTED]
Reply-To: Eddie Peloke [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] mysql query plan
Date: Wed, 13 Apr 2005 15:42:41
I am trying to connect to a DB on a difrent server but mysql keeps connecting to the local server via the socket. What is going on?
-- code snippet--
$connection = mysql_connect(mysql.meanspc.com:3306, Removed, Removed);
--
Jeffrey D. Means [EMAIL PROTECTED]
Owner / CIO for MeansPC
: [PHP-DB] MySql and PHP question
All,
I have a question as how I can return some results that I am looking
for. Ideally I'd like to run this sql statement but for some reason MySql
won't allow me to run it:
SELECT
*
FROM
zip_code
WHERE
zg_latitude between ((select zg_latitude from
Jeffrey D. Means wrote:
I am trying to connect to a DB on a difrent server but mysql keeps
connecting to the local server via the socket. What is going on?
-- code snippet--
$connection = mysql_connect(mysql.meanspc.com:3306, Removed,
Removed);
Well try some debugging :
$connection =
-Original Message-
From: ReClMaples [mailto:[EMAIL PROTECTED]
Sent: 07 April 2005 06:04
To: PHP
Subject: [PHP-DB] MySql and PHP question
All,
I have a question as how I can return some results that I am looking
for. Ideally I'd like to run this sql statement but for some reason MySql
won't allow
: ReClMaples [mailto:[EMAIL PROTECTED]
Sent: 07 April 2005 06:04
To: PHP
Subject: [PHP-DB] MySql and PHP question
All,
I have a question as how I can return some results that I am looking
for. Ideally I'd like to run this sql statement but for some reason MySql
won't allow me to run it:
SELECT
*
FROM
subselects are available as of 4.1
bastien
From: graeme [EMAIL PROTECTED]
To: Juffermans, Jos [EMAIL PROTECTED]
CC: 'php-db@lists.php.net' php-db@lists.php.net
Subject: Re: [PHP-DB] MySql and PHP question
Date: Thu, 07 Apr 2005 12:55:13 +0600
From memory earlier versions of MySQL don't support
All,
I have a question as how I can return some results that I am looking
for. Ideally I'd like to run this sql statement but for some reason MySql
won't allow me to run it:
SELECT
*
FROM
zip_code
WHERE
zg_latitude between ((select zg_latitude from zip_code where zg_zipcode =
I am working with one of our Oracle DBAs to have him try and
help me get a couple of queries working. The problem is that in looking
at the documentation for MySQL it seems that what we are attempting
should work. Unfortunately, it doesn't. Here is what we are trying...
mysql SELECT
only mysql 4.1+ supports subqueries..if you version is lower it won;t work
Bastien
From: NIPP, SCOTT V (SBCSI) [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] MySQL Subquery problems...
Date: Wed, 30 Mar 2005 09:25:36 -0600
I am working with one of our Oracle DBAs to have him
-
From: Bastien Koert [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 30, 2005 9:35 AM
To: NIPP, SCOTT V (SBCSI); php-db@lists.php.net
Subject: RE: [PHP-DB] MySQL Subquery problems...
only mysql 4.1+ supports subqueries..if you version is lower it won;t
work
Bastien
From: NIPP, SCOTT V (SBCSI
yeah...errora are important. I do not escape my quotation marks in a
query. I use single quotes within my insert and select statements.
If it says No valis MySQL resource then you are returning 0 records
which may be caused by escaping the quotations.
I follow this pattern
$sql =INSERT INTO
-db@lists.php.net
Subject: Re: [PHP-DB] MySQL query problems...
Date: Thu, 24 Mar 2005 08:35:56 -0500
yeah...errora are important. I do not escape my quotation marks in a query.
I use single quotes within my insert and select statements.
If it says No valis MySQL resource then you are returning 0
: J. Connolly [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 24, 2005 7:36 AM
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] MySQL query problems...
yeah...errora are important. I do not escape my quotation marks in a
query. I use single quotes within my insert and select statements.
If it says
I am getting errors for the following queries. This query seems
to work fine in phpMyAdmin.
$query2 = SELECT AllMid_Data.CPU_Hostname FROM AllMid_Data, accounts
WHERE AllMid_Data.CPU_IN_SVC = \Y\
AND AllMid_Data.CPU_DNS = \sbcld.sbc.com\
um, the errors might be helpful
bastien
From: NIPP, SCOTT V (SBCSI) [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] MySQL query problems...
Date: Wed, 23 Mar 2005 17:18:44 -0600
I am getting errors for the following queries. This query seems
to work fine in phpMyAdmin
I'm currently using MySQL 4 and php 4.3.10 right now
but as you may already know that, mysql 4.X has new Client Library(it
comes with new PASSWORD encryption method) and it is bundled with php
and mysql itself.
the problem is i cannot use that latest MySQL client Library, php
still using the
'];
$result2 = mysql_query(SELECT DriverID, Driver, CarNbr FROM Drivers LEFT
JOIN $LeagueList ON Drivers.DriverID = $driverID
WHERE $driverID) Is Null ORDER BY Drivers.DriverID);
hth
Bastien
From: Pete Ruby [EMAIL PROTECTED]
Reply-To: Pete Ruby [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB
I am looking to do the following w/ MySQL and PHP. Have 1 query that
gets
results, then use those results in another query:
$l = 2;
$result1 = (SELECT * FROM Drivers WHERE League = $l);
$result2 = mysql_query(SELECT DriverID, Driver, CarNbr FROM Drivers
LEFT
JOIN $LeagueList ON
I am looking to do the following w/ MySQL and PHP. Have 1 query that gets
results, then use those results in another query:
$l = 2;
$result1 = (SELECT * FROM Drivers WHERE League = $l);
$result2 = mysql_query(SELECT DriverID, Driver, CarNbr FROM Drivers LEFT
JOIN $LeagueList ON
I'm pretty new to this...I've set this book example up on my PC and
it's fine.
I've attempted this on two Macs...
Here's the error I get when I try to run the application. What does
the error mean?
UNHANDLED ERROR on line 84 in
/Library/WebServer/Documents/wda2-winestore/index.php.
[PHP
201 - 300 of 1362 matches
Mail list logo