Re: [PHP-DB] Problem with query

2013-06-25 Thread Karl DeSaulniers
Im going to play devils advocate here and say, why is it the one who's helping that needs to be polite and respectful? Isn't it also the newbies responsibility to respect and be polite to those taking time out of their day to help them and not be so stubborn as to not take the advice given

Re: [PHP-DB] Problem with query

2013-06-23 Thread Matijn Woudt
On Sun, Jun 23, 2013 at 8:31 PM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: Dear List - There is an error in my query, and I cannot find it. This fails: $_SESSION['Cust_Num'] = $_REQUEST['cnum']; $_SESSION['CustNum'] = $_REQUEST['cnum']; echo sessionbr /; //this has

Re: [PHP-DB] Problem wkith Query

2013-06-23 Thread Ethan Rosenberg, PhD
On 23 June 2013 21:37, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: On 6/23/2013 2:31 PM, Ethan Rosenberg, PhD wrote: Dear List - There is an error in my query, and I cannot find it. This fails: $_SESSION['Cust_Num'] =

Re: [PHP-DB] Problem wkith Query

2013-06-23 Thread Richard Quadling
Turn on error reporting/logging/displaying and what errors are you getting? And as you said ... $result10 = mysqli_query($cxn, $sql10); var_dump($result1); // this returns NULL is your actual code, maybe ... ?php $a = 'set variable a to this message'; var_dump($b); ? gives you a

Re: [PHP-DB] Problem w/query - again

2012-02-09 Thread Amit Tandon
Dear Ethan It seems you are trying to build a query.But you are not getting field names. If you required field names then change the following line to foreach ( $allowed_fields AS $field = $_POST['field']) to foreach ( $allowed_fields AS $field) This would convert the variable field to value.

Re: [PHP-DB] Problem w/query - again

2012-02-09 Thread Ethan Rosenberg
At 12:13 AM 2/10/2012, Amit Tandon wrote: Dear Ethan It seems you are trying to build a query.But you are not getting field names. If you required field names then change the following line to foreach ( $allowed_fields AS $field = $_POST['field']) to foreach ( $allowed_fields AS $field) This

Re: [PHP-DB] Problem w/query - again

2012-02-09 Thread Amit Tandon
Dear Ethan The line you are getting is because the $_POST[fieldname] is blank. So for the following line if ( ! empty( $_POST['field'] ) ) change it to if ( ! empty( $_POST[$field] ) ) Your line : Program is searxchinbg for variable name field New line : The Program is seacging for varable

Re: [PHP-DB] Problem w/query - again

2012-02-09 Thread Ethan Rosenberg
At 12:48 AM 2/10/2012, Amit Tandon wrote: Dear Ethan The line you are getting is because the $_POST[fieldname] is blank. So for the following line  if ( ! empty( $_POST['field'] ) ) change it to  if ( ! empty( $_POST[$field] ) ) Your line : Program is searxchinbg for variable name field

Re: [PHP-DB] Problem w/query - again - CORRECTION

2012-02-09 Thread Ethan Rosenberg
At 12:48 AM 2/10/2012, Amit Tandon wrote: Dear Ethan The line you are getting is because the $_POST[fieldname] is blank. So for the following line  if ( ! empty( $_POST['field'] ) ) change it to  if ( ! empty( $_POST[$field] ) ) Your line : Program is searxchinbg for variable name field

Re: [PHP-DB] Problem with mysql and php

2011-11-29 Thread Tamara Temple
Jason Pruim li...@pruimphotography.com wrote: Given the following 2 queries: SELECT DISTINCT areacode FROM main WHERE state = '{$query_exploded[0]}'; SELECT DISTINCT areacode FROM main; The second displays ALOT faster Like by minutes... the first one is what I really want

Re: [PHP-DB] Problem with mysql and php

2011-11-29 Thread Dan Rowe
Try running this : http://mysqltuner.pl/mysqltuner.pl If the server has been up for over 24hrs it gives a lot of good insight and things to try tuning wise as a starting point. It'll uncover a lot of common configuration issues or MySQL server level bottlenecks. -Dan (apologizes for the top

Re: [PHP-DB] Problem with mysql and php

2011-11-29 Thread Jim Giner
Didn't the OP begin this very same subject a month ago? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Problem with mysql and php

2011-11-29 Thread Amos Jean-Baptiste
From: joker_mos...@hotmail.com To: phps...@gmail.com Date: Tue, 29 Nov 2011 23:07:13 -0500 CC: phildob...@gmail.com; php-db@lists.php.net Subject: Re: [PHP-DB] Problem with mysql and php Le 2011-11-28 à 22:38, Bastien Koert phps...@gmail.com a écrit : On Mon, Nov 28, 2011 at 9

Re: [PHP-DB] Problem with mysql and php

2011-11-29 Thread Jason Pruim
Jim, Similar yes... But this was specifically about replacing distinct with something since it was taking WAY to long... But it did evolve into a very similar conversation :) Jason Pruim pru...@gmail.com On Nov 29, 2011, at 6:25 PM, Jim Giner wrote: Didn't the OP begin this very same

Re: [PHP-DB] Problem with mysql and php

2011-11-28 Thread Phil Dobbin
On 29/11/11 01:38, Jason Pruim li...@pruimphotography.com wrote: Given the following 2 queries: SELECT DISTINCT areacode FROM main WHERE state = '{$query_exploded[0]}'; SELECT DISTINCT areacode FROM main; The second displays ALOT faster Like by minutes... the first one is what I

Re: [PHP-DB] Problem with mysql and php

2011-11-28 Thread Jason Pruim
Jason Pruim pru...@gmail.com On Nov 28, 2011, at 8:58 PM, Phil Dobbin wrote: On 29/11/11 01:38, Jason Pruim li...@pruimphotography.com wrote: Given the following 2 queries: SELECT DISTINCT areacode FROM main WHERE state = '{$query_exploded[0]}'; SELECT DISTINCT areacode FROM main;

Re: [PHP-DB] Problem with mysql and php

2011-11-28 Thread Phil Dobbin
On 29/11/11 02:08, Jason Pruim pru...@gmail.com wrote: PostgreSQL? ;-)... In all seriousness... Would it help or change it in anyway? :) I am free to use what I want (I believe) on this project... It's well worth looking into. Postgres can handle far bigger db's much quicker than MySQL

Re: [PHP-DB] Problem with mysql and php

2011-11-28 Thread Bastien Koert
On Mon, Nov 28, 2011 at 9:19 PM, Phil Dobbin phildob...@gmail.com wrote: On 29/11/11 02:08, Jason Pruim pru...@gmail.com wrote: PostgreSQL? ;-)... In all seriousness... Would it help or change it in anyway? :) I am free to use what I want (I believe) on this project... It's well worth

Re: [PHP-DB] Problem with mysql and php

2011-11-28 Thread Amos Jean-Baptiste
Le 2011-11-28 à 22:38, Bastien Koert phps...@gmail.com a écrit : On Mon, Nov 28, 2011 at 9:19 PM, Phil Dobbin phildob...@gmail.com wrote: On 29/11/11 02:08, Jason Pruim pru...@gmail.com wrote: PostgreSQL? ;-)... In all seriousness... Would it help or change it in anyway? :) I am free

Re: [PHP-DB] problem in connecting to mysql from php

2011-06-14 Thread Niel Archer
Hello everyone, I am in the process of learning php and I was trying to connect to a mysql database on my own computer(localhost). I have done the following as prerequisites: copied the dll files in system32 removed the semicolon(;) from extension=php_mysqli.dll You should NOT need to

Re: [PHP-DB] problem in connecting to mysql from php

2011-06-14 Thread Abah Joseph
create a file with phpinfo() and make sure mysqli is listed in the loaded modules On Tue, Jun 14, 2011 at 12:07 PM, Niel Archer n...@chance.now wrote: Hello everyone, I am in the process of learning php and I was trying to connect to a mysql database on my own computer(localhost). I

Re: [PHP-DB] problem in connecting to mysql from php

2011-06-13 Thread C0mf0rtably Numb
Okay. I tried using that too. If I run this: ?php $link = mysql_connect('localhost', 'root', 'Password123'); if (!$link) { die('Could not connect: ' . mysql_error()); } echo 'Connected successfully'; mysql_close($link); ? I get the error: *Fatal error*: Call to undefined function

Re: [PHP-DB] problem in connecting to mysql from php

2011-06-13 Thread Richard Quadling
On 13 June 2011 13:26, C0mf0rtably Numb 08.kus...@gmail.com wrote: Okay. I tried using that too. If I run this: ?php $link = mysql_connect('localhost', 'root', 'Password123'); if (!$link) {    die('Could not connect: ' . mysql_error()); } echo 'Connected successfully';

Re: [PHP-DB] Problem with pg_prepare - PostgresSQL

2010-04-26 Thread Chris
Giancarlo Boaron wrote: Hi all. I'm receiving the following message when I try to use pg_prepare() function: Call to undefined function pg_prepare(). My application works very well with others pg_* commands... What version of php do you have? This came in with 5.1.0 according to the

Re: [PHP-DB] Problem with PDO Mysql and FETCH::ASSOC

2009-03-20 Thread Thodoris
Hello, I am using the following code to perform queries on a MySQL database: $dbh = new PDO($GLOBALS['database'],$GLOBALS['username'],$GLOBALS['password']); $dbh-setAttribute(PDO::ATTR_EMULATE_PREPARES, true); $dbh-setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $query =

Re: [PHP-DB] Problem with PDO Mysql and FETCH::ASSOC

2009-03-20 Thread Thomas Robitaille
Does anyone have any ideas as to what I might be doing wrong? Thanks for any help! Thomas First of all check if you are actually connecting to the same database both times. Start with printing $GLOBALS['database'] and see if it connects where you really want. You mentioned a field

Re: [PHP-DB] Problem with PDO Mysql and FETCH::ASSOC

2009-03-20 Thread Christopher Jones
Thomas Robitaille wrote: I've managed to fix the issue by switching to a 32-bit installation of MySQL and Apache. The problem appeared to be due to the 64-bit versions somehow. If you think there's a bug (and you tested the latest version of PHP), please report the problem at

Re: [PHP-DB] Problem with PDO exceptions

2009-03-07 Thread Kesavan Rengarajan
I think it is a bug. I have seen this happening at work (PDO not throwing exception when executing a query on a non existing table) News on iPhone: http://trk7.com/mob On 08/03/2009, at 6:44 AM, Daniel Carrera daniel.carr...@theingots.org wrote: Hello, I have MySQL 5.1 and PHP 5.2. For

Re: [PHP-DB] Problem with PDO exceptions

2009-03-07 Thread Zoltan Ormandi
Hi, Did you set the value of the |PDO::ATTR_ERRMODE| attribute to |PDO::ERRMODE_EXCEPTION|? Btw, I don't think ||prepare would throw an exception even for a malformed query, but ||execute definitely should. Regards, Z

Re: [PHP-DB] Problem with PDO exceptions

2009-03-07 Thread kesavan trichy rengarajan
yup, I have set the |PDO::ATTR_ERRMODE| attribute to |PDO::ERRMODE_EXCEPTION| and I am still not getting an exception! My Code is something like this: $query = $db-prepare($sql); $query-execute($bind); $row = $query-fetch(PDO::FETCH_ASSOC); wher $db is the PDO obj and

Re: [PHP-DB] Problem with PDO exceptions

2009-03-07 Thread kesavan trichy rengarajan
I am sorry, setting |PDO::ATTR_ERRMODE| attribute to |PDO::ERRMODE_EXCEPTION| *does* throw an Exception when the table cannot be found. Stupid me; I was trying to catch Exception rather than a PDOException. On Sun, Mar 8, 2009 at 6:03 PM, kesavan trichy rengarajan k...@trk7.comwrote: yup, I

Re: [PHP-DB] Problem after moving servers

2008-08-31 Thread Evert Lammerts
$list-render( $db, $start, COUNT ); Send the code of this function and tell me the value of COUNT. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Problem after moving servers

2008-08-31 Thread Evert Lammerts
Can you send over the function ProfileList::render? And you should make sure that whenever the render() function of one of ProfileList's subclasses is called, the value of $count is 30... It seems the most likely source of your problem to me. To check the value of $count you can do and echo

Re: [PHP-DB] Problem after moving servers

2008-08-31 Thread Gav
On Sun, Aug 31, 2008 at 8:09 PM, Evert Lammerts [EMAIL PROTECTED]wrote: Can you send over the function ProfileList::render? And you should make sure that whenever the render() function of one of ProfileList's subclasses is called, the value of $count is 30... It seems the most likely source

Re: [PHP-DB] Problem after moving servers

2008-08-31 Thread Evert Lammerts
The code you've sent seems to be fine, and if I check your website it does everything it should do in terms of filtering - if I select Tayside as a region I get a development company with the region set to Tayside. It seems to me that this means the problem is not in one of the subclasses of

Re: [PHP-DB] Problem after moving servers

2008-08-31 Thread Evert Lammerts
You don't need to print the query anymore - I already did that. You need to change your code because right now it is open for SQL injection attacks: I added some SQL to the url and generated an SQL error (http://www.iwdp.co.uk/list.php?region=1start=30,2). When you retrieve start, e.g.

Re: [PHP-DB] Problem after moving servers

2008-08-31 Thread Gav
On Sun, Aug 31, 2008 at 9:27 PM, Evert Lammerts [EMAIL PROTECTED]wrote: You don't need to print the query anymore - I already did that. You need to change your code because right now it is open for SQL injection attacks: I added some SQL to the url and generated an SQL error

Re: [PHP-DB] Problem after moving servers

2008-08-31 Thread Gav
Just copying the error messages here so I can revert my changes on the site. *Notice*: Undefined variable: PHP_SELF in * /var/virtual/web/w0019/html/profilemanager.php* on line *75* *Notice*: Undefined variable: PHP_SELF in * /var/virtual/web/w0019/html/profilemanager.php* on line *76 x 22 more

Re: [PHP-DB] Problem after moving servers

2008-08-31 Thread Evert Lammerts
In PHP5 register_globals defaults to off. You can either switch it back on through your php.ini and restart your webserver, or change all PHP_SELF references to $_SERVER['PHP_SELF']. See if that fixes your problem. I hope you understood the SQL injection problem I pointed out. Anybody can drop

Re: [PHP-DB] Problem after moving servers

2008-08-31 Thread Gav
On Sun, Aug 31, 2008 at 10:36 PM, Evert Lammerts [EMAIL PROTECTED]wrote: In PHP5 register_globals defaults to off. You can either switch it back on through your php.ini and restart your webserver, or change all PHP_SELF references to $_SERVER['PHP_SELF']. See if that fixes your problem. I

Re: [PHP-DB] Problem after moving servers

2008-08-31 Thread Gav
On Sun, Aug 31, 2008 at 10:45 PM, Gav [EMAIL PROTECTED] wrote: On Sun, Aug 31, 2008 at 10:36 PM, Evert Lammerts [EMAIL PROTECTED] wrote: In PHP5 register_globals defaults to off. You can either switch it back on through your php.ini and restart your webserver, or change all PHP_SELF

Re: [PHP-DB] Problem after moving servers

2008-08-31 Thread Evert Lammerts
I'm pretty sure I found the problem - I should've spotted it earlier. The function ProfileList::render gets a reference to the $db object by its parameter $db. While you loop over your results, you pass the reference on to $this-des-load. I'm guessing that the definition of $this-des-load is

Re: [PHP-DB] Problem after moving servers

2008-08-31 Thread Gav
On Mon, Sep 1, 2008 at 9:23 AM, Evert Lammerts [EMAIL PROTECTED]wrote: I'm pretty sure I found the problem - I should've spotted it earlier. The function ProfileList::render gets a reference to the $db object by its parameter $db. While you loop over your results, you pass the reference on

Re: [PHP-DB] Problem after moving servers

2008-08-31 Thread Gav
On Mon, Sep 1, 2008 at 10:10 AM, Gav [EMAIL PROTECTED] wrote: On Mon, Sep 1, 2008 at 9:23 AM, Evert Lammerts [EMAIL PROTECTED]wrote: I'm pretty sure I found the problem - I should've spotted it earlier. The function ProfileList::render gets a reference to the $db object by its parameter

Re: [PHP-DB] Problem after moving servers

2008-08-31 Thread Gav
On Mon, Sep 1, 2008 at 10:38 AM, Gav [EMAIL PROTECTED] wrote: On Mon, Sep 1, 2008 at 10:10 AM, Gav [EMAIL PROTECTED] wrote: On Mon, Sep 1, 2008 at 9:23 AM, Evert Lammerts [EMAIL PROTECTED]wrote: I'm pretty sure I found the problem - I should've spotted it earlier. The function

Re: [PHP-DB] Problem with updating MySQL table

2008-08-27 Thread YVES SUCAET
Ah, how to debug SQL code in PHP... Here's what I would do: run your query separately in something like SQLyog or the Netbeans database interface. Just to echo $sql and copy and paste. An echo $Record statement may also help to assure that you're passing on the PK to the record correctly. One

Re: [PHP-DB] Problem with updating MySQL table

2008-08-27 Thread Evert Lammerts
Your index.php looks very strange: ?PHP form method=post action=purlprocess.php /form ? I'm guessing you're echoing this? I never echo from my scripts so I don't know if this is new functionality, but in my days you echoed either by ?=...;? or by ? echo ...; ?. Anyway, since you're

Re: [PHP-DB] Problem with updating MySQL table

2008-08-27 Thread Fergus Gibson
Hi, Jason. Do you realize this code is wide open for an SQL injection attack? The problem could easily be addressed by using a prepared query instead. For more details, check the mysqli documentation. Jason Pruim wrote: The problem is when I am attempting to update some of the info, it

Re: [PHP-DB] Problem with updating MySQL table

2008-08-27 Thread Jason Pruim
Hi Yves, I plan to wrap the $_POST's into something to protect against some issues like that. But this was a proof of concept for the boss so it just needed to be up quickly to see if it was something we wanted to go ahead with :) On Aug 27, 2008, at 12:21 PM, YVES SUCAET wrote: Ah,

Re: [PHP-DB] Problem with updating MySQL table

2008-08-27 Thread Fergus Gibson
YVES SUCAET wrote: One suggestion: you may want put mysql_real_escape_string() wrappers around all those $_POST[] fields to prevent SQL hijacking of your site. [...] mysqli_query($link, $sql) or die(Could not update... . Yves, he's using mysqli, not mysql. You should not mix those

Re: [PHP-DB] Problem with updating MySQL table

2008-08-27 Thread Fergus Gibson
Jason Pruim wrote: I plan to wrap the $_POST's into something to protect against some issues like that. But this was a proof of concept for the boss so it just needed to be up quickly to see if it was something we wanted to go ahead with :) Well, no worries about that then. We're just

Re: [PHP-DB] Problem with updating MySQL table

2008-08-27 Thread Evert Lammerts
Everybody seems to agree on escaping :-) And I'm learning! HEREDOC, nifty indeed! How about your $_POST variable, is there anything in there? On Wed, Aug 27, 2008 at 6:38 PM, Jason Pruim [EMAIL PROTECTED] wrote: On Aug 27, 2008, at 12:24 PM, Evert Lammerts wrote: Your index.php looks very

Re: [PHP-DB] Problem with updating MySQL table

2008-08-27 Thread Jason Pruim
On Aug 27, 2008, at 12:41 PM, Evert Lammerts wrote: Everybody seems to agree on escaping :-) And I'm learning! HEREDOC, nifty indeed! Yeah, ever since I found out about HEREDOC I've used it quite extensively with some of my projects... Also, when you're in the HEREDOC block, if you need

Re: [PHP-DB] Problem with updating MySQL table

2008-08-27 Thread Jason Pruim
On Aug 27, 2008, at 12:48 PM, Jason Pruim wrote: For everyone that has helped me on this thank you! :) the solution was changing from: input type=text name=txtFName DISABLED to input type=text name=txtFName READONLY Read only fields still get passed with POST'ed info where as disabled

Re: [PHP-DB] Problem with updating MySQL table

2008-08-27 Thread Micah Gersten
Putting commands into input containers in HTML is deprecated in the XHTML specification. You should use this instead in the input: readonly=readonly Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com Jason Pruim wrote: On Aug 27, 2008, at 12:48 PM, Jason

Re: [PHP-DB]problem in creating the ibm_db2 extension

2008-05-01 Thread H Thirividi
On Thu, May 1, 2008 at 5:53 AM, Chris [EMAIL PROTECTED] wrote: H Thirividi wrote: Hi All, I have installed db2 on my* fedora core 7* system and now i wan t to access the database using the* php apis*. For this reason I downloaded the *ibm_db2 1.6* package and tried to create the

Re: [PHP-DB]problem in creating the ibm_db2 extension

2008-05-01 Thread Chris
H Thirividi wrote: On Thu, May 1, 2008 at 5:53 AM, Chris [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: H Thirividi wrote: Hi All, I have installed db2 on my* fedora core 7* system and now i wan t to access the database using the* php apis*. For this

Re: [PHP-DB]problem in creating the ibm_db2 extension

2008-04-30 Thread Chris
H Thirividi wrote: Hi All, I have installed db2 on my* fedora core 7* system and now i wan t to access the database using the* php apis*. For this reason I downloaded the *ibm_db2 1.6* package and tried to create the extension. I did the following phpize output is Configuring for:

Re: [PHP-DB] Problem when using SQL_CUR_USE_ODBC on connect

2008-04-01 Thread Jon L.
(This isn't a solution, per se...just a suggestion.) I don't know how they compare; I've never personally used the ODBC functions... But, you may give the MSSQL functions a try: http://php.net/mssql - Jon L. On Mon, Mar 31, 2008 at 3:27 PM, cfs [EMAIL PROTECTED] wrote: I'm using PHP with

Re: [PHP-DB] problem in recorset that seems temporary

2008-01-25 Thread Krister Karlström
Hi! I did not quite get the point here, but maybe that's not needed to solve the problem... :-) First of all, you seem to have enabled the register_global setting, since I can't see from where the parameter $id is posted. Use the $_GET or $_POST superglobal array instead. Take big care of

Re: [PHP-DB] Problem with reading out value from urlline

2007-08-06 Thread Aleksandar Vojnovic
Hi, you should do it like this ?php $id = $_GET['id']; // -- getting var from the url line echo $id; ? - Aleksandar Ruprecht Helms wrote: Hi, I have the problem that a phpscript is not able to read out a value from the browserline. In the browserline I have the URL domain/page?id=value. The

Re: [PHP-DB] Problem with passing variable to mssql

2007-06-28 Thread Stut
William Curry wrote: I have issues I cant understand passing a sql statement to mssql, most of which work fine, however in some cases, a statement like SELECT * FROM tblX where value like 'variable%' will return 0 records when I know they are there. No errors, just 0 records. When I echo the

Re: [PHP-DB] Problem with passing variable to mssql

2007-06-28 Thread Stut
Please include the list when replying. William Curry wrote: Thanx for the quick reply, I left out the concats in my sample here is the exact statement: $qry1 = SELECT *,CONVERT(Char(24),CALL_ENTRY_DATE,101) as MYDATE from PcarsCallComplete where Location_address = .$Location2. order by

Re: [PHP-DB] Problem with passing variable to mssql

2007-06-28 Thread James Gadrow
William Curry wrote: $qry1 = SELECT *,CONVERT(Char(24),CALL_ENTRY_DATE,101) as MYDATE from PcarsCallComplete where Location_address = .$Location2. order by CALL_NO; This method usually works well for me for debugging purposes: immediately prior to query, echo it to see exactly what you're

Re: [PHP-DB] Problem with rss-feed generation

2007-06-16 Thread Hassan
I support Neil on this point! But anyway this list has answered many other aspects, so why not some XML? Ruprecht you might like FeedCreator latest stable from here http://www.bitfolge.de/rsscreator it just doesn't generate ATOM 1.0, but all other formats will be readable atleast by IE and

Re: [PHP-DB] Problem with rss-feed generation

2007-06-15 Thread Niel Archer
Hi the first line is badly formed xml version=1.0 encoding=ISO-8859-1 Should be: ?xml version=1.0 encoding=ISO-8859-1 ? Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Problem with rss-feed generation

2007-06-15 Thread Ruprecht Helms
Niel Archer wrote: Hi the first line is badly formed xml version=1.0 encoding=ISO-8859-1 Should be: ?xml version=1.0 encoding=ISO-8859-1 ? ok by beginning the php-code with ?php I fixed the problem. Unfortunately my RSSowl tell me that there must be other errors in the xml-formating.

Re: [PHP-DB] Problem with rss-feed generation

2007-06-15 Thread Niel Archer
Hi ok by beginning the php-code with ?php I fixed the problem. Unfortunately my RSSowl tell me that there must be other errors in the xml-formating. And I don't got a detailed information what RSSowl dislike in the xml-file. Try opening it in a browser. Opera, for example, tells you what

Re: [PHP-DB] Problem with rss-feed generation

2007-06-15 Thread Ruprecht Helms
Niel Archer wrote: Hi ok by beginning the php-code with ?php I fixed the problem. Unfortunately my RSSowl tell me that there must be other errors in the xml-formating. And I don't got a detailed information what RSSowl dislike in the xml-file. Try opening it in a browser. Opera, for

Re: [PHP-DB] Problem with rss-feed generation

2007-06-15 Thread Ruprecht Helms
Hi Niel, firefox tells me that it dislike the closing xml-tag. In my quanta-editor it seems that can be difficulties with the tagend of the opening xml-line of the second position of the questionmark. Because you missed the space in front of it. You really need to find out more about

Re: [PHP-DB] Problem with rss-feed generation

2007-06-15 Thread Niel Archer
Hi Du you know a good tutorial for XML and RSS, possible relating with PHP. Not a tutorial, no. I got my information from the specification documents. You should consider changing your method. Instead of creating the RSS/XMl file manually, try using one of the PHP extensions that will

Re: [PHP-DB] Problem with imagebuilding

2007-05-04 Thread bedul
$hintergrund = $row_hintergrundsbild-Bildname; $backgroundimage = $hintergrund; this is the problem whole about. u call img name but not img file.. fyi.. to build a img u must begin with this.. $im = imagecreatefrompng(test.png); what u want to do?? plz explain - Original Message -

Re: [PHP-DB] Problem with ocilogon

2007-02-16 Thread Brad Bonkoski
Dominik Helle wrote: Hi, I've a problem with php-oci and I hope anybody can help me. I want to connect with ocilogon to an Oracle Database. If i call my php-Script in the browser, this error message turn up: Warning: ocilogon() [function.ocilogon]: OCIEnvNlsCreate() failed. There is

Re: [PHP-DB] Problem with ocilogon

2007-02-16 Thread Dominik Helle
Brad Bonkoski schrieb: Dominik Helle wrote: Hi, I've a problem with php-oci and I hope anybody can help me. I want to connect with ocilogon to an Oracle Database. If i call my php-Script in the browser, this error message turn up: Warning: ocilogon() [function.ocilogon]: OCIEnvNlsCreate()

Re: [PHP-DB] Problem with ocilogon

2007-02-16 Thread roy . a . jones
IT, Financial Shared Services IT External: (919) 483-0266 Internal: 703-0266 Fax: (919) 315-4979 Office: STH D-1228 Email: [EMAIL PROTECTED] Pager: (919) 312-0729 Dominik Helle [EMAIL PROTECTED] 16-Feb-2007 09:58 To php-db@lists.php.net cc Subject Re: [PHP-DB] Problem with ocilogon Brad

Re: [PHP-DB] Problem with PHP 4.4.4 and MSSQL in Centos

2007-01-12 Thread Frank M. Kromann
Hi Claudio, 1) Check the version of FreeTDS on both systems. 2) Check the freetds.conf file for differences (use the sam TDS version) 3) Check that php is compiled using --with-mssql on both systems (--with-sybase will give you aliases to some mssql_( functions but not all) - Frank Hi all!

Re: [PHP-DB] Problem with PHP 4.4.4 and MSSQL in Centos

2007-01-12 Thread Claudio Saavedra
Hi Frank, El vie, 12-01-2007 a las 10:49 -0800, Frank M. Kromann escribió: 1) Check the version of FreeTDS on both systems. It proved irrelevant. See above. 2) Check the freetds.conf file for differences (use the sam TDS version) No differences. 3) Check that php is compiled using

Re: [PHP-DB] Problem with PHP 4.4.4 and MSSQL in Centos

2007-01-12 Thread Frank M. Kromann
Hi Claudio, bugs.php.net would be the place to report the bug. As both the MSSQL and Sybase extensions are using the same FreeTDS library I would think the bug is in the Sybase extension. You will get more mssql_* functions with the MSSQL extension, and much better support for storred procedures

Re: [PHP-DB] Problem with executing Oracle query for creating procedure

2006-10-28 Thread Rosen
Christopher Jones [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Rosen wrote: Hi, i have problem with PHP and Oracle database. I read with PHP script an sql files like this: create or replace procedure test_proc1(p1 IN number, p3 OUT number) as begin p3 := p1 + 10; end;

Re: [PHP-DB] Problem with executing Oracle query for creating procedure

2006-10-27 Thread Christopher Jones
Rosen wrote: Hi, i have problem with PHP and Oracle database. I read with PHP script an sql files like this: create or replace procedure test_proc1(p1 IN number, p3 OUT number) as begin p3 := p1 + 10; end; And when I execute it I receive an error: Warning: ociexecute(): OCIStmtExecute:

Re: [PHP-DB] Problem with Oracle

2006-10-25 Thread Christopher Jones
[EMAIL PROTECTED] wrote: In Oracle you would write: insert into pts (pid, txt) values (1,'502a'); But in PHP you are going to do the following: $conn = oci_connect('scott','tiger','my_db'); $sql = insert into pts (pid, txt) values (1,'502a'); $cursor = oci_parse($conn, $sql); if (! $cursor) {

Re: [PHP-DB] Problem with Oracle

2006-10-24 Thread roy . a . jones
In Oracle you would write: insert into pts (pid, txt) values (1,'502a'); But in PHP you are going to do the following: $conn = oci_connect('scott','tiger','my_db'); $sql = insert into pts (pid, txt) values (1,'502a'); $cursor = oci_parse($conn, $sql); if (! $cursor) { $err = oci_error($conn);

RE: [PHP-DB] Problem with pg_fetch_array

2006-10-23 Thread Bastien Koert
show relevant code around the query and attempt to loop thru resultset bastien From: Vignesh M P N [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] Problem with pg_fetch_array Date: Mon, 23 Oct 2006 15:12:25 -0500 Hi I am trying to display the rows from a database table in a

Re: [PHP-DB] Problem with pg_fetch_array

2006-10-23 Thread Chris
Vignesh M P N wrote: Hi I am trying to display the rows from a database table in a grid. I retrieved the results using pg_query() with a Select command. pg_query() returns true. But when I pass the results $rows to pg_fetch_array(), it returns false. I even tried displaying the

Re: [PHP-DB] Problem with Oracle

2006-10-23 Thread Chris
Rosen wrote: Hi, I have a problem with PHP and Oracle 10 Database. I read sql script from file and execute it. Files are something like this: insert into pts (pid, txt) values (1,'502a'); insert into pts (pid, txt) values (2,'502b'); . I receive a message: ORA-00911: invalid character When

Re: [PHP-DB] Problem with Oracle query

2006-10-13 Thread roy . a . jones
Try this ... SELECT m.id ,m.text FROM main m ,recs r WHERE m.id = r.id AND r.log like '%sometext%' ORDER BY m.id / Roy A. Jones Rick [EMAIL PROTECTED] 13-Oct-2006 10:53 To php-db@lists.php.net cc Subject Re: [PHP-DB] Problem with Oracle query Brad Bonkoski

Re: [PHP-DB] Problem with Oracle query

2006-10-13 Thread Rosen
' in the Recs table Roy A. Jones Rick [EMAIL PROTECTED] 13-Oct-2006 10:53 To php-db@lists.php.net cc Subject Re: [PHP-DB] Problem with Oracle query Brad Bonkoski [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Rosen wrote: Hi, I have a problem with PHP and Oracle SQL

Re: [PHP-DB] Problem with Oracle query

2006-10-13 Thread roy . a . jones
'%sometext%' ORDER BY m.id / Roy A. Jones Rosen [EMAIL PROTECTED] 13-Oct-2006 11:09 To php-db@lists.php.net cc Subject Re: [PHP-DB] Problem with Oracle query [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Try this ... SELECT m.id ,m.text FROM main m

RE: [PHP-DB] Problem with insert BLOB into Oracle

2006-10-05 Thread Vincent DUPONT
Hello you can not insert a lob this way. Refer to the php manual pages at http://www.php.net/oci And search for Example 3. Inserting data into a CLOB column Vincent -Original Message- From: Rosen [mailto:[EMAIL PROTECTED] Sent: jeudi 5 octobre 2006 14:43 To: php-db@lists.php.net

Re: [PHP-DB] problem with header()

2006-10-04 Thread Dimiter Ivanov
On 10/4/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi I can not submit any header() information in the following context. What is wrong within the code? ?php require_once includes/db.inc; require_once HTML/Template/ITX.php; if (!($connection = @ mysql_connect($hostname, $username,

Re: [PHP-DB] Problem with list#2

2006-07-07 Thread tg-php
You may get duplicate messages sometimes when someone responds directly to you as well as copying the message to the main mailing list. Like in this ccase, my To: field is the PHP DB list, and my CC: field is your personal email address. If that's not the issue, then try what Dave suggested

Re: [PHP-DB] Problem with list#2

2006-07-07 Thread Jack Gates
On Friday 07 July 2006 14:30, Karl James wrote: Team, I am still receiving duplicate emails. Karl James (TheSaint) mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] www.theufl.com Did you save your confirm and welcome e-mail from the list? That will

Re: [PHP-DB] Problem with a login page.

2006-03-06 Thread dpgirago
snip... // check passwords match $_POST['password'] = stripslashes($_POST['password']); $info['password'] = stripslashes($info['password']); $_POST['password'] = $_POST['password']; if ($_POST['password'] != $info['password']) { die('Incorrect password, please try

RE: [PHP-DB] Problem installing mssql extension

2006-01-25 Thread Jim McDonald
release. -jim -Original Message- From: Andrew Kleimeyer [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 24, 2006 11:21 PM To: Bastien Koert Cc: php-db@lists.php.net Subject: Re: [PHP-DB] Problem installing mssql extension Yes. My extensions directory is c:\php\extensions and I'm already

RE: [PHP-DB] Problem installing mssql extension

2006-01-25 Thread Frank M. Kromann
, as these dll's may change with the stable release. -jim -Original Message- From: Andrew Kleimeyer [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 24, 2006 11:21 PM To: Bastien Koert Cc: php-db@lists.php.net Subject: Re: [PHP-DB] Problem installing mssql extension Yes. My

Re: [PHP-DB] Problem installing mssql extension

2006-01-25 Thread Andrew Kleimeyer
To: Bastien Koert Cc: php-db@lists.php.net Subject: Re: [PHP-DB] Problem installing mssql extension Yes. My extensions directory is c:\php\extensions and I'm already successfully running the mysql extension. On 1/25/06, Bastien Koert [EMAIL PROTECTED] wrote: Have you added the path

RE: [PHP-DB] Problem installing mssql extension

2006-01-24 Thread Bastien Koert
Have you added the path to the extensions in the path/dir section to point to the extensions directory? ext_dir = c:\php5\ext; bastien From: Andrew Kleimeyer [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] Problem installing mssql extension Date: Wed, 25 Jan 2006 12:56:09 +0800

Re: [PHP-DB] Problem installing mssql extension

2006-01-24 Thread Andrew Kleimeyer
Yes. My extensions directory is c:\php\extensions and I'm already successfully running the mysql extension. On 1/25/06, Bastien Koert [EMAIL PROTECTED] wrote: Have you added the path to the extensions in the path/dir section to point to the extensions directory? ext_dir = c:\php5\ext;

Re: [PHP-DB] Problem with creating parallel connections with mysql_connect

2006-01-18 Thread David Robley
On Wed, 18 Jan 2006 19:51, Aarno Syvänen wrote: Hi List, decided to try non-permanent connections for now. So now I have: ? /* db.php */ $db_server=127.0.0.1; $db_user = asterisk; $db_pass = bozzo984; $db_db = bebbicell; $db_account_server=127.0.0.1; $db_account_user = asterisk;

Re: [PHP-DB] Problem with creating parallel connections with mysql_connect

2006-01-18 Thread Aarno Syvänen
I go following debug: got error when doing first connection resource id was Resource id #3 got error when selecting first database got error when doing second connection resource id was Resource id #4 got error when selecting second database the code was:

  1   2   3   4   >