RE: [PHP-DB] auto_increment problem???

2002-08-26 Thread Miles Thompson
Russ, I'd pursue this on the mysql list as this behaviour appears erratic. I'd have to check docs, but would assume that autoincrement data is kept in the parent (mysql) table. If these keys are not sequential it doesn't matter. (That's one of the great things about Visual FoxPro's sys(2015)

[PHP-DB] inserting blank records into database WHY?

2002-08-26 Thread murtaza
i had created a guestbook in PHP with mySQL database connectivity, i'm taking values from a form SIGN.php -- form action=create_entry.php method=POST Name : input type=text name=name size=40 Location : input type=text name=location size=40 .

Re: [PHP-DB] inserting blank records into database WHY?

2002-08-26 Thread Jason Wong
On Monday 26 August 2002 20:16, murtaza wrote: i had created a guestbook in PHP with mySQL database connectivity, i'm taking values from a form SIGN.php -- form action=create_entry.php method=POST Name : input type=text name=name size=40 Location : input type=text

Re: [PHP-DB] inserting blank records into database WHY?

2002-08-26 Thread namaide tajeryno
- Original Message - From: murtaza [EMAIL PROTECTED] Date: Mon, 26 Aug 2002 15:16:34 +0300 To: [EMAIL PROTECTED] Subject: [PHP-DB] inserting blank records into database WHY? mysql_query(INSERT INTO guestbook(name,location,email,url,comments) values

Re: [PHP-DB] inserting blank records into database WHY?

2002-08-26 Thread namaide tajeryno
- Original Message - From: murtaza [EMAIL PROTECTED] Date: Mon, 26 Aug 2002 15:16:34 +0300 To: [EMAIL PROTECTED] Subject: [PHP-DB] inserting blank records into database WHY? input type=submit name=submit value=Sign if ($submit ==$_POST[Sign] ) shouldn't the if conditional be 'if

[PHP-DB] is the following query legal?

2002-08-26 Thread Adam Williams
I have an informix database with a table called phptesttable. It has a SERIAL field (for mysql users that can help, its the same as INT NOT NULL PRIMARY KEY AUTO_INCREMENT) and a CHAR field (CHAR in Informix is the same as VARCHAR in mysql). In my PHP script if I submit an array and then insert

[PHP-DB] Query display question

2002-08-26 Thread Dan J.
Hello, I am some what new to php. I have an odbc query written and it displays like I want it to but... I want to be able to setup a next / prev button when say records = 10. How would I go about this? Thanks Dan J. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

Re: [PHP-DB] is the following query legal?

2002-08-26 Thread Adam Williams
I got it to work. I have to put the statement in ifx_prepare right before I call it in the loop. I think its because when I define the statement at the start of the code, $statement[$counter] has not been asigned yet so it sets its value to nothing. Adam -- PHP

[PHP-DB] How do I submit data AND send user to other page?

2002-08-26 Thread Gerd Ulrich
Hello, I want to build a questionaire where the user is guided through five pages of questions. How can I program PHP that the user gets to the second page after pushing the Submit-Button? My solution printed here doesn't work. Any hints are greatly apreciated! S. Maier ?php if ($submit) { //

[PHP-DB] Radio buttons

2002-08-26 Thread Gerd Ulrich
Hello, I get forms posted and working, but as soon as I include radio buttons, the whole form doesn't function anymore. The code of the radio button part is included in this posting. Can you tell me, what I'm doing wrong? Help would be greatly appreciated! S. Maier TR TD

Re: [PHP-DB] How do I submit data AND send user to other page?

2002-08-26 Thread Adam Williams
use an HTML form. Adam On Mon, 26 Aug 2002, Gerd Ulrich wrote: Hello, I want to build a questionaire where the user is guided through five pages of questions. How can I program PHP that the user gets to the second page after pushing the Submit-Button? My solution

[PHP-DB] next prev links for search result

2002-08-26 Thread Smita Manohar
hiii.. i want page no. and next prev links while displaying search result. the script which im using presently, needs to run the search query 2 times for each search operation. first time it finds all the records matching the query string, ie, select * from table where field like

Re: [PHP-DB] Radio buttons

2002-08-26 Thread Support @ Fourthrealm.com
Your radio buttons look fine. I would ensure to add quotes (single or double) around the attribute settings, for HTML compliance. If you must go without quotes, then make sure that you don't put spaces in any of the attribute values. INPUT type=radio value=6 name=surf_erf As for the form

[PHP-DB] a beginner

2002-08-26 Thread Pax
Hi, there! I am new to PHP/Postgres. I come from an ASP/(ADO)/MSSQL environment and I have problems figuring out how to do things that are quite simple there. First of all, a question that regards Postgres (I couldn't get an answer at PG newsgroups). I understand that the PG 'synonym' for MSSQL

[PHP-DB] php doubt

2002-08-26 Thread suman
hi i am working with php on a postgres server .so i have some doubt's. my project is a student information management system on an apache web server using php and postgres as backend my doubts are 1.i wanna insert a timestamp type into db and php doesn't have such a type so i use int for

Re: [PHP-DB] How do I submit data AND send user to other page?

2002-08-26 Thread Colin Odden
Hi Adam, I think that you have to put the header command before anything else. (that is, putting the header (Location:X) command at the bottom of your block might be the trouble) If putting it somewhere else in your script doesn't work, how about: echo htmlhead; echo meta

RE: [PHP-DB] a beginner

2002-08-26 Thread Ruprecht Helms
Hi Pax, ' does .. MSSQL stored proc? I don't think. Mysql handles the handling of SQL-processes by creating a link for the time the process is working. After it the link dies. The result mysql have no transaction-tracking. That's my actual knowledge of mysql. The other database I don't know.

Re: [PHP-DB] How do I submit data AND send user to other page?

2002-08-26 Thread John Coder
On Mon, 2002-08-26 at 13:25, Gerd Ulrich wrote: Hello, I want to build a questionaire where the user is guided through five pages of questions. How can I program PHP that the user gets to the second page after pushing the Submit-Button? My solution printed here doesn't work. Any hints are

Re: [PHP-DB] a beginner

2002-08-26 Thread Pax
Sorry, Ruprecht. I was talking about mSsql (miscrosoft). Ruprecht Helms [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi Pax, ' does .. MSSQL stored proc? I don't think. Mysql handles the handling of SQL-processes by creating a link for the time the