[PHP-DB] PHP/MySQL to generate colums with results

Hi all, I have seen queries of this nature before, but they never seem to get a thorough answer - and that maybe because the issue isnt explained properly.. okay, so here is the scenario. I have a database which features the following tables: hst_category hst_product

[PHP-DB] error_reporting = off dont works!?

hi, I've following system: apache 2.0.36 on a w2k server with PHP/4.2.1 as a module. I configured the php.ini in this way: error_reporting = E_ALL ~E_NOTICE to avoid php displaying warnings and notices. ( of course I restartet the apache service ). But I got even so warnings and notices

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

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: ? include(functions.php); ? I've been working with includes recently and that's the standard syntax. Furthermore, if you put the functions.php

[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

[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

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,

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

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 slashes in

[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

[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:

[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

[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

[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

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.