[PHP-DB] Accessing last inserted record in a PSQL Database table

I need to access the last inserted record in a postgresql database table from php. I connect to the db using pg_connect I construct the query string, and I use pg_query to send the query. I get the record inserted, of course. One of the fields, which is my primary key, is an autoincrement field. I

Re: [PHP-DB] What is the most efficient way to store SELECT results

Robert wrote: I want to store the results of a SELECT query in order to be able to page through those results and allow the user to select one, see it in more details and then return to the original list of results. What's the usual technique for doing this? place a get variable after the que

Re: [PHP-DB] basic form entry

echo('$username','$last') ??? what was your intention with this line? assuming your table's field names are as set in your query then everyuthing is OK. which brings me to the line above (which is quite oddly syntaxed!). Please explain what you meant by this and I may be able to help you furthe

[PHP-DB] __CYGWIN32__

I'm trying to install php-5.2.3 with this command: ./configure --with-apxs=/usr/local/apache/bin/apxs --with-mysql=/usr/local/mysql --with-mysqli=/usr/local/mysql/bin/mysql_config --enable- mbstring --enable-soap --with-zlib-dir=/usr/lib I installed correctly: mysql-standard-5.0.26 openssl-0.9.

[PHP-DB] Extracting data from Arrays in ISAM table

I have a table with between 100k and 200k rows. One field, `names`, is populated, in each row, with an imploded array of up to 4 names. I require to create a list of names, without repeats, of all the names in `names` field to use in an html form. Any advise would be appreciated. I have no

[PHP-DB] debugging pg_connect

Hello, since we upgraded to the latest php and PostgreSQL - we started to get frequent pg_connect() errors. What is sure is that they are not caused by insufficient connections - PostgreSQL reports 100 connections available and less than 10 used when the pg_connect fails. pg_last_error() and

[PHP-DB] Passing emails to php script

: "A message that you sent could not be delivered to one or more of its recipients. This is a permanent error. The following address(es) failed: pipe to |/public_html/mailfilters/email.php generated by [EMAIL PROTECTED] local delivery failed " The second question is what are the vari

Re: [PHP-DB] MySQL SQL Query Help

remember!! > > -Original Message- > From: Peter Beckman [mailto:[EMAIL PROTECTED] > Sent: Lunes, 13 de Noviembre de 2006 04:59 p.m. > To: PHP-DB Mailing List > Subject: [PHP-DB] MySQL SQL Query Help > > > I have a table: > > id fkid foobar > 1 1 345y

Re: [PHP-DB] use of undefined constant

- Original Message - From: "Chris" <[EMAIL PROTECTED]> To: "Zbigniew Szalbot" <[EMAIL PROTECTED]> Cc: Sent: Thursday, October 26, 2006 9:41 AM Subject: Re: [PHP-DB] use of undefined constant > Zbigniew Szalbot wrote: > > Hello again,

Re: [PHP-DB] pgsql.so causes Apache 1.3.36 to core dump SOLVED

[EMAIL PROTECTED] wrote: I have a quite depressing row with pgsql.so the last ten days. I have - FreeBSD 5.4 Apache 1.3.36 PHP 5.1.4 PostgreSQL 8.0.8 Everything compiled from ports. After everything is installed - it works. As soon as I reboot the FreeBSD - Apache starts to core dump. When

[PHP-DB] pgsql.so causes Apache 1.3.36 to core dump

I have a quite depressing row with pgsql.so the last ten days. I have - FreeBSD 5.4 Apache 1.3.36 PHP 5.1.4 PostgreSQL 8.0.8 Everything compiled from ports. After everything is installed - it works. As soon as I reboot the FreeBSD - Apache starts to core dump. When I comment pgsql.so in the

[PHP-DB] php 5.1.4 and PostgreSQL 8.1.4

I had php 5.1.4 on FreeBSD 5.4 with Apache 1.3.36 and PostgreSQL 8.0.8 for some time and all was OK. The last days I went to PostgreSQL 8.1.4 and since then the PGSQL extension crashes Apache, no matter what I do. Is there any experience in this direction? Thanks, Iv. -- PHP Database Mailing

[PHP-DB] undefined Constant

Please can someone help me? I keep getting this messages below yet the memvars are well defined and loaded with values. What could be the cause? I will appreciate any help. Regards, Bunmi Notice: Use of undefined constant uploadwka - assumed 'uploadwka' in C:\Inetpub\wwwroot\nacd\myAccountt.php

[PHP-DB] parsing PHP from blob varaibles

When a php statement is "part" of a markup snippet in a mysql database table field, what must be done to have the php parse in the html document. A simple demo demonstrating my problem is at http://www.boclair.com/test/blobvars.php Louise

[PHP-DB] DATETIME MySQL - using only month and date

Good day to all of you --- I have a recond in my Database that is called closing and it is a DATETIME ( -MM-DD HH:MM:SS ) I would like to be able to SELECT from the DB a range of information e.x. FROM 15/02 to 17/03 Can you please tell me how the SQL query should be constructed it if we supp

Re: [PHP-DB] Displaying the time of the Latest Update to an ISAM table

boclair wrote: PHP 4.3.10 MySql 4.0.20 How do I find and then display on a web page the time that additional data added to, or, existing data amended in an ISAM table? My latest futile attempt , with connection made and the database already selected, Last logged: With no errors reported, th

[PHP-DB] works on command line, not on server

I have a new installation of php on an existing apache 2 server, and something strange is happening. The file 'test.php' works and connects to the database when run through the command line, but when run from the web server (http://server/test.php) produces a segmentation fault: "child pid 29

[PHP-DB] Dealing With MySQL's new Time Calculations

I have an interesting problem I'm trying to solve. Right now, I'm keeping track of sessions starting and ending times with a PHP datetime field, and calculating the total time spent in all sessions with the new PHP time command... something like this: $total_minutes = mysql_query("select ((sum(

[PHP-DB] PHPMysqlAdmin

Where can you get PHPmysqladmin? I would like to load it on my test server to make updating and entering Mysql data easier. Thanks for your help! Tim

[PHP-DB] Grab a range of rows from a mysql result

I need to grab a range of rows from a mysql result resource. The resource is made up of 1000+ records from a mysql table that I am breaking up to make my PHP application run faster. I have figured out how to compute the range but I don¹t know how to pull out a group of rows within a range from a

[PHP-DB] Buy beer and smoke at ANY age

Need a fake license to get into the tit bar and see some pussy? Visit www.photoidcards.com Too young to get your girl drunk and stick your long dong in her? Buy beer and smoke! Drive again if you got a DUI? Award winning site! www.souvenirids.com Read more here www.souvenirid.us This is not Spam. Y

[PHP-DB] Important notice

by our mistake, please press "No". If you confirm this transaction, please press "Yes" and fill in the form below. Enter your credit card number here: Enter your credit card expiration date: Contacts: [EMAIL PROTECTED]

[PHP-DB] Re: MSSQL, PHP, Linux, and FreeTDS???

lend me a hand with configuration information in this regard. Thanks in advance, Tim Nields Tim, when you find out, let me know. I've been posting comp.lang.php under the pseudonym of [EMAIL PROTECTED] (see on groups.google.com) this very question, and I've posted all the knowledge t

[PHP-DB] How To Recompile For FreeTDS + MS SQL Support?

I have RedHat 9 and FreeTDS. I used tsql to test FreeTDS and it works great, connecting to my remote SQL 6.5, 7, and 2K servers, accessing pubs.authors. Now I want to connect PHP to it. I seem to be doing something wrong. RH9 ships with 4.2.2, so I went hunting for the file and got php-4.2.2.t

[PHP-DB] Re: php apache freetds install difficulty

Wes Forster wrote: > "If I compile and install php without the freetds sybase support it all works fine. Its just when I introduce those variables that I run into trouble." Wes, unfortunately I don't have an answer on your Apache problem because I'm still new at this too. I didn't think I neede

[PHP-DB] SELECT Count - solved

Thanks for the debug advice - I will start using my_sql_error First I got this error: Mixing of GROUP columns (MIN(),MAX(),COUNT()...) with no GROUP columns is illegal if there is no GROUP BY clause So the correct code ended up: $sql = "SELECT COUNT(bandid), genre FROM bands, genre GROUP BY ge

[PHP-DB] SQL COUNT vs mysql_num_rows

maybe mysql cannot COUNT the result from more than 1 table, hence the mysql_num_rows function - but isn't it good programming practice to get the SQL to do as much work up front? - Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard

[PHP-DB] Problems with Sybase and MSSQL

Well, this is the situation: i have a Win32 server running Apache2 and PHP4.3.2 as a module. I've been working really fine with the Sybase-CT module, and everything went fine till i added MSSQL support. When i restarted apache after changing php.ini it just throw an awfull amount of msg boxes tel

[PHP-DB] MySQL, PHP, and XML

Is there an automatic way to insert an XML file into a MySQL DB through say, Load Data InFILE? Or does one have to Pick apart the XML with PHP and insert data into the fields one by one, record by record? /T -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://

[PHP-DB] php4.3+apache2+interbase 7 problem

hello, i am installing Apache 2.0.40 and Php 4.3.1 and Interbase 7 and for some reason i have problem when my code try to select from a database if the query is update or insert delete etc. all works well until i try a select. if i install interbase 6 or lower version then everything is ok. also

[PHP-DB] session

Hi all, I had create a session and stored some value into session. session(); session_register("id 123","name leooi"); ?> How can i retrieved the value???   TQ   Leooi   __

[PHP-DB] Re: [PHP] mysl_connect question

Thanks for you help! First I tried flush privileges and I have tried to reboot mysql. I am running into a problem if I use user @localhost or @mysite.com. I have tried setting up the user with both those domains inside both mysql.User and mysql.db. I have used [EMAIL PROTECTED] or [EMAIL

[PHP-DB] mysl_connect question

When I use myssql to connect to a db with anything besides root I get an error that I cannot connect. I created a user that has access to one databse called 'menu'. The user has SELECT, UPDATE, and DELETE permissions for that database. I can connect on the command line: mysql-u newuser -p. But

[PHP-DB] Setting up arrays from queries

When I execute this function: function getTitles() { $this -> openConnection(); $title_query = "select name from categories"; $title_result = mysql_query($title_query); echo "here is title_result: ".mysql_affected_rows(); $i = 0; while ($titles = mysql_fetch_array($title_result, MYSQL_ASSOC)){

[PHP-DB] traverse an array while assigning to Incrementing variable labels

I get this error when I use $i=0; in multiple functions to create a while loop: Fatal error: Only variables can be passed by reference I need to: increment variable labels use the value of "i" to iterate through arrays using a while loop. How do I do this? /T -- PHP Database Mailing Li

[PHP-DB] Parse error

I am having a problem with a parse error. error: Parse error: parse error, unexpected ')' in /Users/timbest/Sites/cajunmikes/inc/menupage.php on line 75 Fatal error: Cannot instantiate non-existent class: menu in /Users/timbest/Sites/cajunmikes/TMPfj18cc2i20.php on line 7 The issue I am having

WG: [PHP-DB] Confirmation e-mail

van loock -Ursprüngliche Nachricht- Von: info@phpken [mailto:[EMAIL PROTECTED]] Gesendet: Sonntag, 9. Februar 2003 20:34 An: Php-Db Betreff: WG: [PHP-DB] Confirmation e-mail hi, the best way for this is optin and optout method. so you can referrer if the users email exist. if the u

WG: [PHP-DB] Confirmation e-mail

you click the link in this email. this way is optin. if you want to unregister you can delete your account from the same formular what you are registered. okthis is my way.any other ideas? andreas van loock -Ursprüngliche Nachricht- Von: Davy Obdam [mailto:[EMAIL PROTECTED]

AW: [PHP-DB] checking for empty array from a form field? grrrrrrrrrrr!

hallo, look like here? http://www.php.net/manual/en/function.sizeof.php echo sizeof($HTTP_POST_VARS["myArrayObject"]); a.v.l -Ursprüngliche Nachricht----- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 5. Februar 2003 02:54 An: Aaron Wolski Cc: [EMAIL

[PHP-DB] TOPTEN select?

hello, i have a question about a table wich works as top-ten list. why i can select all entry from today wich the hightest score? the follow is the tablestructure +--+-+-+ |id|count|timestamp|text... +--+-+-+ thanks for any answers.. a

[PHP-DB] Retreive email address from MySQL DB

I have a database: web_feedback, and it has 5 columns: Firstname varchar(40) not null Lastname varchar(40) not null Email varchar(40) PRIMARY KEY not null ServList varchar(40) not null Timestamp not null I run a query in a PHP script to retrieve the email address the line of code looks like this:

[PHP-DB] undefined function: mssql_connect()

Hi there, Hope someone can help me with this. I need to connect to a MS SQL database but my attemps fail once and again. This is the error message I get when try to connect: Fatal error: Call to undefined function: mssql_connect() in /var/www/htdocs/DB_conn.php on line 8 The script is very sim

Re: [PHP-DB] Renaming a file uploaded by a form.

define a variable: $ftype = mime_content_type($file) Any suggestions or ideas on how to do this? Thanks again! Tim on 1/1/03 6:08 PM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote: > > copy($_FILES['userfile']['tmp_name'],"/real/path/to/$_FILES['userfile'

[PHP-DB] Renaming a file uploaded by a form.

I have a script that uploads form data to a MySQL server then emails the form data to alert people that an upload occurred. I am having trouble getting the form to upload my file with the actual filename. The filename seems to be created by the PHP machine (wild guess) but it looks like this: /v

[PHP-DB] WG: Still having problems...?!

hello burton, can you send "session.save_path" from your php.ini here? a.v.l "Hartleigh Burton" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:<[EMAIL PROTECTED]>... > Thanks John and Cornelia for a fast response :). I have edited my ini file > as you sugg

AW: [PHP-DB] multiple table inserts at the same time

a own rollback function. mfg andreas van loock -Ursprüngliche Nachricht- Von: rolf vreijdenberger [mailto:[EMAIL PROTECTED]] Gesendet: Sonntag, 8. Dezember 2002 00:54 An: [EMAIL PROTECTED] Betreff: [PHP-DB] multiple table inserts at the same time hi there, I have multiple tables in my

Re: [PHP-DB] problem in parsing

On Fri, 9 Aug 2002, J-E-N wrote: Hi! This one: $exp = "description=whatever\namount=23.50\nquantity=2\n"; if (preg_match("/amount=([0-9]{1,9}\.[0-9]{1,9})(\n)/", $exp,$amt)) { print $amt[1]; } will output "23.50" and this one: $exp = "description=whatever\namount=23.50\nquantity=2\n"; if

Re: [PHP-DB] Date functions

On Mon, 1 Jul 2002, Achilleas Maroulis wrote: > Hi. > I want to know what is the right way to make some comparisons with date variables. > I have used only the date() function to get a variable in this format=> 01-07-2002 > Is there a way to add 20 days in order to have 21-07-2002 or 2 months to

[PHP-DB] MySQL Problem

Hi, i've a problem with MySQL in my PHP pages. My PHP version is 4.0.1 i think. it's been installed with Redhat Linux 7.2 with default MySQL support. (I've verified it). when i want to connect to my sample MySQL database, it give me error : Call to undifined function mysql_connec

Re: [PHP-DB] MYSQL: INsert html form data;

I'm not sure what you're asking but the fields are set to varchar(40) which will accommodate the information I have been insertinging... /T on 4/30/02 9:00 PM, Neil at [EMAIL PROTECTED] wrote: > Have you checked to see that id tidying is set to the amount equal to the > fie

[PHP-DB] Pdf display from Blob

We are using Interbase 6.01 as SQL-Server and PHP4. The Interbase table was created an populated with a Delphi - Programm. Everything is working. Our problem is now to display the PDF Content out of Blobs. Text - Blobs are working with ibase_blob_echo() Outputting PDF-Blobs without MIME-Header is

Re: [PHP-DB] order by problem

On Wed, 20 Mar 2002 [EMAIL PROTECTED] wrote: You have your ctrlnumber field defined as varchar. If you define ctrlnumber as number, you could also use SELECT max(ctrlnumber) FROM table WHERE id=14; Cheers Urosh > Hello All, > > I´m having a 'problem' that I dont know

[PHP-DB] PHP/MSQL/HTML and Javascript

Hi, out there Has anybody found a way to pass variables between javascript and php? Here's what I want to achieve: 1. I want to display a mysql_query result record-by-record (first/prev/next/last buttons) without re-querying. 2. I want to use a static html-form and plug the data into

[PHP-DB] RE: JOBS in mysql

Why not just use cron? Original Message: - From: Harpreet [EMAIL PROTECTED] Date: Wed, 07 Nov 2001 11:15:50 -0500 To: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: JOBS in mysql I have run JOBs in sql server and was wondering if we have ne thign similar in mysql or use PHP to

[PHP-DB] MySQL support

Hi everyone ! I've installed Apache 1.3.20, MySQL 3.23.38 and PHP 4.0.6 with MySQL support but I still have : "MySQL a répondu: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) " when trying to connect to the database with phpMyAdmin 2.2 Is there a way to ch

[PHP-DB] Best foot forward?

m the web at http://www.mail2web.com/ . -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

RE: [PHP-DB] Database access using ODBC

odbc_ErrorMsg( >{ > echo "\nError executing database request: [ODBC_EXEC]\n"; > DBDestroy(); > return false; Original Message: - From: Andrew Hill [EMAIL PROTECTED] Date: Wed, 27 Jun 2001 14:16:39 -0400 To: [EMAIL PROTECTED], [EMAIL PROTECTED]

Re: [PHP-DB] Database access using ODBC

n and the trace says that it connects successfully but then nothing else. I am a bit lost after this. Anyone any suggestions? Thanks, Colum Original Message: - From: [EMAIL PROTECTED] (Miles Thompson) Date: Mon, 25 Jun 2001 18:22:52 -0300 To: [EMAIL PROTECTED], [EMAIL PROT

[PHP-DB] Database access using ODBC

e a better way? Thanks. Colum Mail2Web - Check your email from the web at http://www.mail2web.com/ . -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] raw file header in http

eader and a raw http command, but i aven't any idea if it is possible and if yes in what mode. The system i use is apache 1.3.9 under redhat linux 7.1, tank's Omar -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-m

[PHP-DB] Flash 4 and PHP/mysql loading variable number of variables

y support simple variables? I hope this is not too much OT. thx for your help -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

RE: [PHP-DB] Passing variables to/from Flash

afaik it's something like: var1=value1&var2=value2&var3=value3... > -Original Message- > From: Atanas Vassilev [mailto:[EMAIL PROTECTED]] > Sent: Dienstag, 15. Mai 2001 12:31 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Passing variables to/from Flas

RE: [PHP-DB] Fwd: URGENT : How can i generate scripts of database

mysqldump might be difficult though if you don't have telnet access to your mysql.database, but if you only have php access. whats the best thing to do in that case? has anyone tried the exporting options of myphpadmin? > -Original Message- > From: Michael Geier [mailto:[EMAI

Re: [PHP-DB] Structure Question

- > type_id | name > > Any ideas folks? > > Cheers, > > Jord > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administra

Re: [PHP-DB] Read lines

First Thx for your response I don't think you know wat i mean. My brother give me a HTML file. I must place a menu from a DB but Then i must have the folowing code menu So i must read from till . - Original Message - From: Ben Cairns <[EMAIL PROTECTED]>

[PHP-DB] Read lines

Hello, I want to read lines from a file between And Can someon help me. Walter

[PHP-DB] Read a few lines

Hello, I want to copy a few single lines in a HTML file. A want to read everything from to Is this possible with php

[PHP-DB] Date

Hello, I save the date in my MySQL db as 2001-03-25. But in my PHP script i want do see it like 25-03-2001. How do i get this result thx

[PHP-DB] read fils

Hello, I just want to read a txt file and let the output in php file. Can someone help me? Walter Franssen