RE: [PHP-DB] auto increment

If you run an optimize or a repair on your datafile it'll set the autoincrememtn back to next number Howard -Original Message- From: Daniele Baroncelli [mailto:[EMAIL PROTECTED]] Sent: Friday, 14 June 2002 11:27 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] auto increment Hi guys, The au

RE: [PHP-DB] auto increment

hello, i think u have to create the series yourself ... before u insert every record, first calculate the next value : "SELECT MAX(ID) AS NEXT FROM TABLE" then u insert ... hope it helps ... -Mensagem original- De: Daniele Baroncelli [mailto:[EMAIL PROTECTED]] Enviada: sexta-feira, 14

FW: [PHP-DB] --- correction --- auto increment

-Mensagem original- De: José Moreira [mailto:[EMAIL PROTECTED]] Enviada: sexta-feira, 14 de Junho de 2002 9:53 Para: Daniele Baroncelli Cc: Php-Db Assunto: RE: [PHP-DB] auto increment hello, i think u have to create the series yourself ... before u insert every record, first calculate

RE: [PHP-DB] problem with login script

I haven't been following your whole thread on this issue, but I did notice that the syntax for your include statement is incorrect. Try this: I've been working with includes recently and that's the standard syntax. Furthermore, if you put the functions.php file in a different directory, remembe

[PHP-DB] REGEXP problem

Hi, I working with this query SELECT * FROM entries LEFT JOIN category ON entries.cat_no REGEXP \".\"+category.id+\"(.|$)\" LEFT JOIN entgroup ON entries.id = entgroup.eid LEFT JOIN catgroup ON category.id = catgroup.cid LEFT JOIN mzgroup ON mzgroup.id = entgroup.gid || catgroup.gid W

[PHP-DB] REGEXP problem

sorry, a bug of my e-mailclient quotes some charaters now without slashes ;-) # Hi, I working with this query SELECT * FROM entries LEFT JOIN category ON entries.cat_no REGEXP "\\."+category.id+"(\\.|$)" LEFT JOIN entgroup ON entries.id = entgroup.eid LEFT JOIN c

Re: [PHP-DB] auto increment

Hello!! ALTER TABLE $table1 AUTO_INCREMENT = 242 Replace the $table with your table's name and replace the end number with what number you want. Dan On Thursday, June 13, 2002, at 08:27 PM, [EMAIL PROTECTED] wrote: > Hi guys, > > The auto_increment field of my MySQL table gives me "258", al

Re: [PHP-DB] problem with login script

On Friday 14 June 2002 20:23, Hutchins, Richard wrote: > I haven't been following your whole thread on this issue, but I did notice > that the syntax for your include statement is incorrect. Try this: > >include("functions.php"); > ?> Doesn't really matter, it works with or without parent

Re: [PHP-DB] problem with login script

On Friday, June 14, 2002, 2:51:51 PM, Jason Wong wrote: > On Friday 14 June 2002 20:23, Hutchins, Richard wrote: >> I've been working with includes recently and that's the standard syntax. >> Furthermore, if you put the functions.php file in a different directory, >> remember to use double slash

[PHP-DB] Re: REGEXP problem

Ok I've found a solution ON entries.cat_no REGEXP CONCAT("\\.",category.id,"(\\.|$)") but nevertheless thanks too all Martin > Hi, > > I working with this query > SELECT * FROM entries LEFT JOIN category ON entries.cat_no REGEXP > "\\."+category.id+"(\\.|$)" LEFT JOIN entgroup ON entries.id

[PHP-DB] Problem with arrays

Hi there, Sorry for my bad english. I want to read a table from a mySQL-database and store it in an array built like this: $value[column][row]; I am not sure, how this is done. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Problem with arrays

You'll have to loop through the result using mysql_fetch_array and put that returned array in each index of your new array. So it would look like this: for ($i=0;$row=mysql_fetch_array($RESULT);$i++) $newArray[$i] = $row; Then $newArray should look like what you want. :-) <>< Ryan

[PHP-DB] mcrypt problems

Hello, I am getting some odd errors trying to get an encrypt/decrypt process to work. Looking at the manual examples and some other literature, I have tried the two approaches listed below. For each, I get a sometimes-works, sometimes fails result. The manual entry has a string of user notes

[PHP-DB] Connect to Inetrbase

Hi All, Can anyone post a sample ibase_connect() call? I am interested in what should appear in the host parameter. Thanks. Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] need a solution for web page navigation

I have a database of the menu items used on my web site, there are more than 100 entries. How do I set up navigation arrows to point to the next appropriate page, and the previous page, from the database? I don't want to use javascript history function, navigation is too important to allow it

[PHP-DB] FW: [[PHP-DB] need a solution for web page navigation ] -- Recurrency always helps :)

-Mensagem original- De: Pedro Oliveira [mailto:[EMAIL PROTECTED]] Enviada: quinta-feira, 13 de Junho de 2002 17:33 Para: [EMAIL PROTECTED] Assunto: [Fwd: Funcao recorrente para PHP ... guardar para me dar na TGP] -Forwarded Message- From: José Moreira <[EMAIL PROTECTED]> To: [E

[PHP-DB] Application name reporting

I'm currently using a PHP application to interact with DB2 and MSSQL (via FreeTDS). The application name reported to DB2 is httpd, and the application name reported to MSSQL is PHP 4.0. How can I replace these with my actual application's name? Thanks. Please CC me on replies as I do not keep

[PHP-DB] Magic Quotes

Frankly, I've never quite "gotten" the whole quoting thing in PHP. If magic_quotes_gpc is turned on in the environment: 1. I don't see slashes in any form variables outputted with echo() or print() Does this mean that these functions effectively remove the slashes? 2. After posting the form va

[PHP-DB] sql query problem

I have a database layout similar to this- id order title namepagecat 0 0 title1 blueap 1 2 blue1 page1 ap 2 3 blue2 page2 ap 3 1 blue3 page3 ap I would like to get title1 (title col

RE: [PHP-DB] sql query problem

The problem is they are parts of different rows. In a relational database rows only know about other rows through relationships. You have either: 1. Designed your database incorrectly. or 2. Are a genius with a unique concept that I do not grasp. <>< Ryan -Original Message- From: [EM

Re: [PHP-DB] sql query problem

Hello Chip, Could you please send your program to dig more.And also send your database schema. Do you want to select title,name from your_table_name where title='title1' and name='blue2'; Is the title and name field are unique.If it so,then the above query will helps you. Regard