[PHP-DB] MySQL Error???

Is anyone familiar with this MySQL error? "1062: Duplicate entry '127' for key 1" I wrote a great bookmark management program that works fine, but everytime I insert bookmarks, I insert somewhere over 120 and I start getting this error, and it won't add them anymore. Any suggestions??? Thanks,

RE: [PHP-DB] Database access using ODBC

Colum, What does the ODBC trace show right after connection, and any subsequent calls? Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Data Integration Technology Providers > -Original Message- > From: Mile

RE: [PHP-DB] Variable Variables in PHP

Try changing your inputs to: PRINT ""; PRINT ""; On the following page after the form is submitted, PHP will create 2 new arrays, $name_array and $email_array. From there, you can do a foreach on the arrays: foreach($name_array as $id => $name) { print "My name is $name and my e-mail is

[PHP-DB] mssql_xxx() and characters

Hi! I have PHP4.05 and MSSQL7 desktop on Win2k. Problem occurs when I query results contain some extended characters, for example "ä" or similar. In place of these chars thaere are some non-aphanumeric ones displayed like boxes, etc.(",," instead of "ä") or simply some alphabetic character. Mssq

[PHP-DB] FW: strange numbers in link

Our website uses mysql/php. I found the link written below as a "hard coded" link and I can't figure out why the programmer would have used "c2x5han" as a keyword instead of using "chan" as the keyword- which is an acronym for "Child Health & Nutrition". Child Health & Nutrition I thinking a

[PHP-DB] perl fork() in PHP?

Can I do something similar to the perl fork() in php and if so, does anyone know of any examples of this. regards Tom Hodder -- 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

Re: [PHP-DB] Variable Variables in PHP

On Wed, Jun 27, 2001 at 12:03:42PM +1000, Morgan Tocker wrote: > ## THIS SHOULD SUBMIT SOMETHING LIKE THIS > > test.php?name1=avalue&email1=avalueagain&name2=secondname&email2=secondemail > > THE PROBLEM: > From PHP with variable variables, how do I change $name1 and $email1 into - > > ##

[PHP-DB] Modify Query, or sift through results?

I've got a script that searches a db every night and sends out e-mail if it finds something a person would be interested in, based on criteria they gave us. The problem is that I have one field that stores regions of the country in a very unpleasant way. It stores them as: Northeast;West;South S

Re: [PHP-DB] error ORA-12699

I have read some doc. $connect_string is set to equal from tnsnames.ora. $connect_string="(DESCRIPTION=(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 1521))(CONNECT_DATA = (SID = ORCL)))"; I can connect my local oracle server before when using OCILogon("system","manager"); But now ,

Re: [PHP-DB] Extracting enum/set values from database

On Fri, Jun 22, 2001 at 04:45:53PM -0700, Todd A. Jacobs wrote: > Is there a way to dynamically build an option list from an enum/set type? > In other words, if I don't know the possible values of the enum or set > field ahead of time, how can I retrieve that information at run-time? Here is a fu

Re: [PHP-DB] error ORA-12699

Sang, Since you're trying to connect from another computer to the Oracle server, you probably need to specify a connect string in the OCILogon command. OCILogon('system', 'manager', "$connect_string"); What's the value for $connect_string? It depends on how you've set-up your Oracle networking.

[PHP-DB] Storing Code in a db?

Hey there, Is it possible to store code like a function, for example, in a mysql database and pull it into a php dynamicallly so you can use the function if needed? Mark

RE: [PHP-DB] Variable Variables in PHP

"; WHILE ($i < $num) { $name = mysql_result($result,$i,name); $email = mysql_result($result,$i,email); $id = mysql_result($result,$i,id); PRINT ""; < modified PRINT ""; < modified $i++; } PRINT ""; } ?> To create the q

Re: [PHP-DB] php/mysql horizontal listing query

Hi, may be this will be helpfull $res=mysql_query("select release from tbl_release"); for ($i=1;$i<=4;$i++){ if ($i==1)echo ""; $row=mysql_fetch_row($res); if ($row) echo "$row[0]"; else { $end=1; echo " "; } if ($i!=4)echo ' '; if ($i==4){ echo "";

[PHP-DB] making queries

Yes, it's possible. What you do is write the var names and values after the page name as follows: click my link This would call a script called mylink.php, initializing two vars, namely $foo (containing the value 'bar') and $bar (containing the value 'foo'). So, to pass info to a script using a

[PHP-DB] error ORA-12699

I have installed NT4+PHP+ORACLE8.0.4+APACHE in my computer. I want to access ORACLE server to another computer from web server. It is ok to access ORACLE SERVER with PERL, but i cannot access using PHP. The first error is ora-12514 , but i change, change and change, now it is always ORA-12699 Nati

[PHP-DB] Variable Variables in PHP

I am having trouble with variable variables; I want to create a form as follows :- "; WHILE ($i < $num) { $name = mysql_result($result,$i,name); $email = mysql_result($result,$i,email); $id = mysql_result($result,$i,id); PRINT ""; PRINT "";

Re: [PHP-DB] php/mysql horizontal listing query

on 6/26/01 10:43 AM, Matt Nigh at [EMAIL PROTECTED] wrote: > I need a section of a record label site with a releases section listed > horizontally but here's the twist: after every 4 releases, I want the > releases to move to the next columns below. > > ex. > release#1, release#2, release#3, re