[PHP-DB] Semi-newbie - postgres polygon/points and PHP?

2002-02-16 Thread Roger Southwick
Ok, a kinda newbie question. I set up a Postgres DB with a table that had a Point and a Polygon in it (to hold XY and shape settings for munging a jpeg image in php). I could not easily figure out how to extract the data into a reasonably easy to use format in PHP. The best I could do seemed

Re: [PHP-DB] Semi-newbie - postgres polygon/points and PHP?

2002-02-16 Thread DL Neil
Ok Roger, Ok, a kinda newbie question. I set up a Postgres DB with a table that had a Point and a Polygon in it (to hold XY and shape settings for munging a jpeg image in php). I could not easily figure out how to extract the data into a reasonably easy to use format in PHP. The best I

Re: [PHP-DB] counting multiple columns based on different values

2002-02-16 Thread DL Neil
John, I'm gonna go out on a limb and guess that I'm missing something obvious (and easy) because this sure seems like it should be able to be done. Here's the issue: I need to pull the client name and ID out of one table and then, count the records in a different table (called

[PHP-DB] PHP InterBase Multiple BLOBs display

2002-02-16 Thread Marian Vigenin
Hi, I have read several posting on How to display a graphical BLOB but all of them show how to display only one image. I need to display all the images found in the query including some descriptions for that images. I tried the following but of course only one image appeared. ?PHP

[PHP-DB] Re: can't insert into MS-access

2002-02-16 Thread Joe Van Meer
Hi there, sounds like you do not have the proper read/write permissions on that file. HTH Joe :) Penockio [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I can't use sql command insert into but I can use select and it condition.I use DSN that provide by ODBC

[PHP-DB] Session confusion :-(

2002-02-16 Thread Dave Carrera
Hi All I am send variable values via set links i.e.: http://domian_name.com/page.php?category=1 http://domian_name.com/page.php?category=2 http://domian_name.com/page.php?category=3 Etc etc The value is sent to a session. THIS WORKS BUT. If I click on the first link session variable

[PHP-DB] Connecting to mySQL database

2002-02-16 Thread Alvin Ang
Hi ppl, I'm new to both PHP and mySQL but have no choice but to crash-course on both before end of mid of march to complete my University project. I would really appreciate alittle help from any kind soul out there. I have already created a mySQL database and create all the tables *well at

Re: [PHP-DB] Connecting to mySQL database

2002-02-16 Thread DL Neil
Hi Alvin, I'm new to both PHP and mySQL but have no choice but to crash-course on both before end of mid of march to complete my University project. I would really appreciate alittle help from any kind soul out there. I have already created a mySQL database and create all the tables *well

[PHP-DB] Page Expired - Post form

2002-02-16 Thread olinux
My situation is extremely common. I've searched the newsgroups for several hours now looking for a straight answer and have found no solution. I am testing on my local but will not have access to apache config file. I get the infamous page expired warning and have tried all i know to fix. I can't

Re: [PHP-DB] counting multiple columns based on different values

2002-02-16 Thread John Hawkins
DL, I ran the query exactly as you had sent it and ran into the same error where it talked about mixing counts without a group clause. So, I added a quick group by clientname and ran it again One word PERFECTION. I can't thank you enough. This is now a blistering fast query that

[PHP-DB] Is it possible ?

2002-02-16 Thread CK Raju
Is it possible to get the AUTO-INCREMENTed ID's value while doing an INSERT and have the value INSERTed to another table in the same FORM ? Raju ** Message from InterScan E-Mail VirusWall NT ** ** No virus found in attached file noname.htm This is a virus free message scanned by

Re: [PHP-DB] Is it possible ?

2002-02-16 Thread Kodrik
On Saturday 16 February 2002 07:35 pm, you wrote: Is it possible to get the AUTO-INCREMENTed ID's value while doing an INSERT and have the value INSERTed to another table in the same FORM ? Raju mysql_query(insert whatever); $insertid=mysql_last_insert(); Then you use this value for your

[PHP-DB] finding ID's

2002-02-16 Thread jonknee41
First off, sorry for the newbie question... :(. I want to be able to query the database and find the record with the highest ID value. Example... each row ideally has an incremented integer ID (1, 2, 3, 4...) but I am running into problems when I try and delete a row (let's say row 2). My PHP