[PHP-DB] pg_escape with copy

I have data that I'm running through pg_escape_sting in php and then adding to stdin for a copy command. The problem is "O'reilly" is being changed to "O''Reilly" in the string and then in the db. I saw with the copy command I can specify the escape but it isn't working for me. Should this comma

[PHP-DB] australian city db -lat/lon?

I've found a few places to get a zipped file of US cities with zips and lat/lon for insertion into my db...does anyone know of a resource where I can get the same thing for Australia?? Thanks!

[PHP-DB] optimizing indexes -mysql

I just doubled the size of my MySQL db, is there a command I should run to re-index everything or is that automatic? Thanks!

[PHP-DB] mssql_select_db(): Unable to select database:

Hello all, I set up freetds on one of my servers and everything worked fine. I just set it up on another server (this one with the latest php) and now the same code seems to connect but can't select the db mssql_select_db(): Unable to select database:. How can I figure out what's wrong? The mss

[PHP-DB] connection to mysql db

I have mysql running on a linux box at my house. I want to connect to that box from another machine on my home network but get access errors. When connecting, I use the machines internal ip and the root name and password of the linux box but I get access denied errors. How can I connect? Thanks

[PHP-DB] mssql_select_db

I have some code which connects to a remote SQL server. The code has worked fine for a year and now the mssql_select_db is failing. The code hasn't changed and I talked to the SQL Server admin who assures me nothing has changed and I am talking to the web host who says nothing changed...how can I

[PHP-DB] floats

I am running a query on MySQL: select * from cars where id =52 It returns the row and I can see that gas mileage is saved as a float with a value of 23.45. So I then do a query, select * from cars where id=52 and gas_mil=23.45 and the query doesn't retun anything. Why? Do I have to cast this a

[PHP-DB] mysql load data form input file

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: http://www.php.net/unsub.

[PHP-DB] show tables

How can I run a query to find all of the tables in a db with a certain columname? Thanks! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] group by

Hello, Let's say I have an app used in car garages. I have two tables: table cars id make model table work_done id carid details work_date I need to pull out the last work order for each car. This pulls them all: select c.make, c.model, c.id, wd.details from cars c join work_done wd on wd.car

Re: [PHP-DB] mysql 4.1-4.0

yeah, that is what I did to fix it...just curious why the problem was there in the first place. On Wed, 02 Feb 2005 14:40:55 -0600, Martin Norland <[EMAIL PROTECTED]> wrote: > blackwater dev wrote: > > Why is this query handled differently in 4.1? > > > > 4.0 > >

[PHP-DB] mysql 4.1-4.0

Why is this query handled differently in 4.1? 4.0 select lower(concat(last_name,id)) from client where prim_id=1 returns johnson1 4.1 same query returns Johnson1 Why don't the lower work in 4.1 when you concatonate with a number? Thanks! -- PHP Database Mailing List (http://www.php.net/) To u

[PHP-DB] select particular columns in query

Hello, I want to create a new row in the db by copying an existing one. My db has an auto incrementing id so I can't simply do insert into cars select * from cars where id=$id as this throws the primary key error. How can I do this with out specifying each column? Thanks! -- PHP Database Mail

[PHP-DB] returning inserted ids using "load data local infile"

Is there anyway to get an array of the inserted id's generated when I load data into mysql using an external data file??? Thanks! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Rand()

Yeah, I had tried that earlier but it doesn't work. It does generate a new value for temp each time but they are still in the same order as the first one always has a lower temp value On Thu, 7 Oct 2004 06:40:23 -0700, Ed Lazor <[EMAIL PROTECTED]> wrote: > > > select id, fname, lname, RAND

[PHP-DB] Rand()

I have the following query: Select id, fname, lname from clients where featured=1 order by RAND() At any time, there should only be three clients where featured =1. Problem is I have run this query several times yet it always returns them in the same order. Not sure it makes a difference but th

Re: [PHP-DB] rand()

I have no idea of it is on the server or now...I just have access to my little section of the server. Is there another way to randomly order? On Wed, 29 Sep 2004 23:27:43 +, Jennifer Goodie <[EMAIL PROTECTED]> wrote: > -- Original message from black

[PHP-DB] rand()

Hello, I have the following query: select * from clients order by RAND() THe query runs fine on my local server but when I run it on my hosts server, it works ok if there is only one record in the db but then there is more than one...I get this error: #1 - Can't create/write to file '/var/tmp/#

[PHP-DB] mysq query without subselects

Hello, I need to grab the max value of all of the data in a table grabbing the max total for each client. Example. T1 idtotal clientid 1 100 111 2 200 111 3 100 112 4 150 112 I need a query that will grab t