Re: [PHP-DB] Problem with query

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 which

Re: [PHP-DB] Problem wkith Query

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 ... gives you a better clue? On 23 June 2013 23:06, Ethan Rosenberg, PhD wrote

Re: [PHP-DB] Problem wkith Query

On 23 June 2013 21:37, Ethan Rosenberg, PhD 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'] = $_REQUEST['cnum']; $_SESSION['CustNum']

Re: [PHP-DB] Problem with query

On Sun, Jun 23, 2013 at 8:31 PM, Ethan Rosenberg, PhD < [email protected]> 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 "session"; //th

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

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 N

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

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 N

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

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 st

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

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

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. I

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

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 [email protected] On Nov 29, 2011, at 6:25 PM, Jim Giner wrote: > Didn't the OP begin this very same sub

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

> From: [email protected] > To: [email protected] > Date: Tue, 29 Nov 2011 23:07:13 -0500 > CC: [email protected]; [email protected] > Subject: Re: [PHP-DB] Problem with mysql and php > > > > Le 2011-11-28 à 22:38, Bastien Koert a écrit : > >

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

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

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 post

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

Jason Pruim 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 though Currently wo

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

Le 2011-11-28 à 22:38, Bastien Koert a écrit : On Mon, Nov 28, 2011 at 9:19 PM, Phil Dobbin wrote: On 29/11/11 02:08, "Jason Pruim" 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...

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

On Mon, Nov 28, 2011 at 9:19 PM, Phil Dobbin wrote: > On 29/11/11 02:08, "Jason Pruim" 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. P

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

On 29/11/11 02:08, "Jason Pruim" 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 but

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

Jason Pruim [email protected] On Nov 28, 2011, at 8:58 PM, Phil Dobbin wrote: > On 29/11/11 01:38, "Jason Pruim" wrote: > >> Given the following 2 queries: >> >> "SELECT DISTINCT areacode FROM main WHERE state = '{$query_exploded[0]}'"; >> >> "SELECT DISTINCT areacode FROM main"; >> >> The

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

On 29/11/11 01:38, "Jason Pruim" 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 tho

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

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 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 have don

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

> 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 n

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

On 13 June 2011 13:26, C0mf0rtably Numb <[email protected]> wrote: > Okay. I tried using that too. If I run this: > $link = mysql_connect('localhost', 'root', > > 'Password123'); > if (!$link) { >    die('Could not connect: ' . mysql_error()); > } > echo 'Connected successfully'; > mysql_close($

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

Okay. I tried using that too. If I run this: I get the error: *Fatal error*: Call to undefined function mysql_connect() in *C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\a.php* on line *2 *I think there is something wrong with my configuration. On Mon, Jun 13, 2011 at 6:00 PM, mr

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

Your error message is about class not found.That means there is no class named "MySQLi".Please use a textbook with online manual http://www.php.net/manual/en/ref.mysql.php On 06/13/2011 02:08 PM, C0mf0rtably Numb wrote: > Hello everyone, > > I am in the process of learning php and I was trying to

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

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 manua

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

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 http://bugs.php

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

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 "de

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

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 = $dbh->pre

Re: [PHP-DB] Problem with PDO exceptions

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 wrote: > yup, I have set the |

Re: [PHP-DB] Problem with PDO exceptions

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

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

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 wrote: Hello, I have MySQL 5.1 and PHP 5.2. For some reason PDO is not throwi

Re: [PHP-DB] Problem after moving servers

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. >>>

Re: [PHP-DB] Problem after moving servers

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

Re: [PHP-DB] Problem after moving servers

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 > referen

Re: [PHP-DB] Problem after moving servers

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

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

Re: [PHP-DB] Problem after moving servers

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

Re: [PHP-DB] Problem after moving servers

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 y

Re: [PHP-DB] Problem after moving servers

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

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 (http://www.

Re: [PHP-DB] Problem after moving servers

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=1&start=30,2). When you retrieve start, e.g. $_GET['star

Re: [PHP-DB] Problem after moving servers

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 Profil

Re: [PHP-DB] Problem after moving servers

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 sou

Re: [PHP-DB] Problem after moving servers

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 $count;

Re: [PHP-DB] Problem after moving servers

> $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 with updating MySQL table

> Putting commands into input containers in HTML is deprecated in the > XHTML specification. You should use this instead in the input: Only if your doctype is XHTML, in which case you should also close every tag, including the input tag. If your doctype is HTML your code is fine. I use the HTML v

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

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 with updating MySQL table

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: to type="text" name="txtFName" READONLY> Read only fields still get passed with POST'ed info where as disabled does not. And yes I will be adding some p

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

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 t

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

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 v

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

On Aug 27, 2008, at 12:24 PM, Evert Lammerts wrote: Your index.php looks very strange: ?> 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 . It is a index.php page using the HERE

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

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 lookin

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

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 f

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

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, ho

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

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 era

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

Your index.php looks very strange: > > > > > > ?> 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 . Anyway, since you're using the $_POST variable, did you check if it contains any val

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

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 in creating the ibm_db2 extension

H Thirividi wrote: > > > 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

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

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 c

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

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

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

The mssql driver uses a dll that has a limitation on varchar fields of 255 characters. And the 30 chracter column name limit. And after SQL 2005, may not be supported at all. So that alt has been tried, and then adandoned. ""Jon L."" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]

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

(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 A

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

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 in

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

Hi, you should do it like this - 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 /?id=. The id-Value I want to process within the script but a echo $id shows me no value. The P

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

Try this code $id=$_REQUEST['id']; echo $id; I find it working well. Santosh - Original Message - From: "Ruprecht Helms" <[EMAIL PROTECTED]> To: Sent: Monday, August 06, 2007 2:52 PM Subject: [PHP-DB] Problem with reading out value from urlline Hi, I have the problem that a ph

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

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: [PHP-DB] Problem with passing variable to mssql

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

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 th

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

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 Fi

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

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 genera

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

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 mo

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

Hi > 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 XML and RS

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

Niel Archer wrote: > Hi > >> ok by beginning the php-code with > 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 w

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

Hi > ok by beginning the php-code with 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 error it encounters. That'

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

Niel Archer wrote: > Hi > > the first line is badly formed > > > > Should be: > > ok by beginning the php-code with http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

Hi the first line is badly formed Should be: Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Problem with imagebuilding

$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

6 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 [email protected] cc Subject Re: [PHP-DB] Problem with ocilogon Brad Bonkoski schrieb: > Dominik Helle wrote: >>

Re: [PHP-DB] Problem with ocilogon

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() f

Re: [PHP-DB] Problem with ocilogon

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 somethi

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

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 PHP 4.4.4 and MSSQL in Centos

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 --wit

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

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 executing Oracle query for creating procedure

"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

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

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

Re: [PHP-DB] Problem with Oracle

[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

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 Oracle

"Chris" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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 (p

Re: [PHP-DB] Problem with Oracle

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" Whe

Re: [PHP-DB] Problem with pg_fetch_array

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 err

RE: [PHP-DB] Problem with pg_fetch_array

show relevant code around the query and attempt to loop thru resultset bastien From: Vignesh M P N <[EMAIL PROTECTED]> To: [email protected] 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 Oracle query

ot;Rosen" <[EMAIL PROTECTED]> > 13-Oct-2006 11:09 > > To > [email protected] > cc > > Subject > Re: [PHP-DB] Problem with Oracle query > > > > > > > > > <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] >> Try thi

Re: [PHP-DB] Problem with Oracle query

'%sometext%' ORDER BY m.id / Roy A. Jones "Rosen" <[EMAIL PROTECTED]> 13-Oct-2006 11:09 To [email protected] cc Subject Re: [PHP-DB] Problem with Oracle query <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Try this ... > >

Re: [PHP-DB] Problem with Oracle query

me so much rows as many are the appearance the 'sometext' in the Recs table > > > Roy A. Jones > > > > > "Rick" <[EMAIL PROTECTED]> > 13-Oct-2006 10:53 > > To > [email protected] > cc > > Subject > Re: [PHP-DB] Problem with O

Re: [PHP-DB] Problem with Oracle query

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 [email protected] cc Subject Re: [PHP-DB] Problem with

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 query. >> I have 2 tables : >> >> Table Main: >> --- >> id number >> text varchar2(100) >> >> >> Table Recs >> --- >> id number >> pos numb

Re: [PHP-DB] Problem with Oracle query

Rosen wrote: Hi, I have a problem with PHP and Oracle SQL query. I have 2 tables : Table Main: --- id number text varchar2(100) Table Recs --- id number pos number log varchar2(200) I need to make query to select a list from first table(Main), where somewhere in the second ta

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

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: [email protected] Subjec

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

mosts likely you have html output in the page somewhere, perhaps in the includes or it could be a blank space in one of the files that is above and outside the php tags Bastien From: [EMAIL PROTECTED] To: [email protected] Subject: [PHP-DB] problem with header() Date: Wed, 4 Oct 2006 07:4

  1   2   3   4   >