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 < 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 "session"; //th

[PHP-DB] Problem with query

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"; //this has the proper values print_r($_SESSION); $sql10 = "select Balance, Payments, Charges, Date from Charges whe

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

[PHP-DB] Problem w/query - again

Dear list - This did not seem to post, so I am sending it again. If it did post, and I missed it, my apologies. Ethan Dear list - I have the following code: $query = "select * from Intake3 where 1"; $allowed_fields = array('Site', 'MedRec', 'Fname', 'Lname',

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 pru...@gmail.com 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: 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 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 pru...@gmail.com 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

[PHP-DB] Problem with mysql and php

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 working with a dataset of 89 million re

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 <08.kus...@gmail.com> 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

[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 In spite of doing the above when

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

[PHP-DB] Problem with pg_prepare - PostgresSQL

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... I already checked my configuration files and I have no more ideas about how to fix it. Any suggestions? T

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

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

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

[PHP-DB] Problem with PDO exceptions

Hello, I have MySQL 5.1 and PHP 5.2. For some reason PDO is not throwing exceptions when I give it a broken SQL query. For example: try { $stmt = $db->prepare("SELECT * FROM foobar WHERE 1"); } catch(PDOException $e) { error($e->getMessage()); } In this example there is no tab

[PHP-DB] problem oci_connect solved..thanks to those involved

I would have had no problem if I had: (1) used ZEND (2) installed php, apache, oracle XE, oci8,instant client I installed 11g1 Enterprise and that already had a client. Fedora already had php 5 and apache 2 FINALLY: The following works in the browser. hr/hr is automatically built in the 11g1 d

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

[PHP-DB] Problem after moving servers

Hi All, I moved a site across from one server to another, and now there is one thing no longer working properly that worked fine on the other. It may turn out to be a PHP4 to PHP5 problem, dont know as I cant access now what the other server had. Certain pages on the website were able to render a

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

TED]> To: php-db@lists.php.net Subject: [PHP-DB] Problem with updating MySQL table Hi Everyone, So I'm working on a project (Same one I sent the question about regarding the user access rights on monday) And now I am attempting to update the record... Here is some of my code: index.ph

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

gt; To: php-db@lists.php.net Subject: [PHP-DB] Problem with updating MySQL table Hi Everyone, So I'm working on a project (Same one I sent the question about regarding the user access rights on monday) And now I am attempting to update the record... Here is some of my code: index.php

[PHP-DB] Problem with updating MySQL table

Hi Everyone, So I'm working on a project (Same one I sent the question about regarding the user access rights on monday) And now I am attempting to update the record... Here is some of my code: index.php First Name/Last Namevalue="{$row['FName']}" $edit> value="{$row['LName']}" $edit> Em

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

[PHP-DB]problem in creating the ibm_db2 extension

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: PHP Api Version: 20041225

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

[PHP-DB] Problem when using SQL_CUR_USE_ODBC on connect

I'm using PHP with Apache. PHP code connects to MS SQL server using ODBC. I'm doing a query against a table that is very simple: one column of the real data type, one of the text data type. The text field is set to "testing 1,2,3". The real column is set to 10.015. When I use the default c

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

[PHP-DB] problem in recorset that seems temporary

Hi, I have a problem that confuse me a little bit. When I want to delete a picture by giving the id-value in the URL I get the following error: Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /opt/lampp/htdocs/pferdeservice_karle/galerie_delete.php on line

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,

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

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 Php-Surrounding is very secured. Formfields and variables that schould b

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

[PHP-DB] Problem with passing variable to mssql

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 sql string to the pag

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

[PHP-DB] Problem with rss-feed generation

Hi, I've a problem in creating a xml-file for a dynamic rss-feed. When I try to read the feed in my feedreader RSSowl I get an errormessage that the xml was not formated properly The feed should present boardentries in a short description. Because there are much articles the feed should show that

Re: [PHP-DB] Problem with imagebuilding

ginal Message - From: "Ruprecht Helms" <[EMAIL PROTECTED]> To: Sent: Friday, May 04, 2007 3:10 PM Subject: [PHP-DB] Problem with imagebuilding > Hi, > > I actually have a problem with a script that creates a picture from > database content. I the following error: > &

[PHP-DB] Problem with imagebuilding

Hi, I actually have a problem with a script that creates a picture from database content. I the following error: Warning: imagepng(): supplied argument is not a valid Image resource in /opt/lampp/htdocs/cycosmos_2/avatare/avatarbild.php on line 315 The other lines that copy and resize other con

[PHP-DB] Problem with Opera 9.0

Hello Everyone, Iam having a strange problem with Opera 9.0. I have a website where user can login to their admin panel. My site is working fine in all the browser but when i use Opera 9.0 and enter the username and password and click on submit, it niether goes to process page nor show me any

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 php-db@lists.php.net 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

[PHP-DB] Problem with ocilogon

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 something wrong with your sys

  1   2   3   4   5   6   7   >