Re: [PHP-DB] Placing a form on a page

2013-05-05 Thread tamouse mailing lists
On Sun, May 5, 2013 at 11:22 PM, Ethan Rosenberg, PhD wrote: > Dear List - > I apologize if I offended some of you. I will see that it does not repeat. > I am trying to center a form on the top of a page. Here is the form: What you're asking about has nothing to do with PHP. You want help with H

Re: [PHP-DB] Undefined variables in update query

2013-03-26 Thread tamouse mailing lists
On Tue, Mar 26, 2013 at 10:57 AM, VanderHart, Robert wrote: > I appreciate the replies I've received already; thanks! Sorry for not > catching my simple errors before sending out that message. No worries, no one I have met yet begins life knowing this stuff! If you don't mind, Robert, I'd lik

Re: [PHP-DB] Query will not work - SOLVED

2013-02-02 Thread tamouse mailing lists
On Sat, Feb 2, 2013 at 8:08 PM, Ethan Rosenberg, PhD wrote: > I must be missing something fundamental!! Yes. > I was using the "worker@localhost", which did not have the Update privilege. > Added the privilege that, and everything worked. Please explain why you are not checking error returns f

Re: [PHP-DB] Error Checking

2013-01-08 Thread tamouse mailing lists
On Tue, Jan 8, 2013 at 11:54 AM, Ethan Rosenberg, PhD wrote: > Dear List - > > 1] What function(s) do you use for error checking? > 2] What are the settings for the parameter(s) in the functions? > 3] Do you have different php.ini files for development and production? This makes more sense answer

Re: [PHP-DB] Programs not running - Mystery SOLVED

2013-01-08 Thread tamouse mailing lists
On Tue, Jan 8, 2013 at 1:12 AM, Matt Pelmear wrote: > I personally *never* set the error reporting level in the code, and during > code reviews I reject code that does so. > It is much cleaner to manage this in php.ini. I tend to agree -- settings like this are environment (dev, test, stage, prod

Re: [PHP-DB] Re: Programs not Running - SOLVED

2013-01-06 Thread tamouse mailing lists
On Sun, Jan 6, 2013 at 6:32 PM, Jim Giner wrote: > On 1/6/2013 7:17 PM, Ethan Rosenberg, PhD wrote: >> >> The problem was in this piece of code: >> >> require '/var/www/pass.inc'; >> $db = "Store"; >> $cxn = mysqli_connect($host,$user,$password,$db); >> if ( !$c

Re: [PHP-DB] Programs not running

2013-01-06 Thread tamouse mailing lists
On Sun, Jan 6, 2013 at 2:14 PM, Karl DeSaulniers wrote: > Unfortunately, I am still working on an old G4 Powerbook trying to finish a > website of mine. > Adobe GoLive was the program I imprinted on and it stuck. Sadly it has gone > away now > and Dreamweaver is the replacement. I am not fond of D

Re: [PHP-DB] Programs not running

2013-01-06 Thread tamouse mailing lists
On Sun, Jan 6, 2013 at 1:21 AM, Karl DeSaulniers wrote: > I likey.. :) > > Thanks! > > Best, > Karl > > > On Jan 5, 2013, at 10:05 PM, Bastien wrote: > >> Get net beans. It's free and a great IDE with debuggers and other stuff >> >> Bastien Koert netbeans is pretty awesome; I haven't used it for

Re: [PHP-DB] Programs not running

2013-01-05 Thread tamouse mailing lists
On Sat, Jan 5, 2013 at 12:48 AM, Karl DeSaulniers wrote: > On Jan 4, 2013, at 8:00 PM, tamouse mailing lists wrote: >> On Fri, Jan 4, 2013 at 6:09 PM, Matt Pelmear wrote: >>> On 01/04/2013 01:40 PM, tamouse mailing lists wrote: >>>> One should be able to solve pars

Re: [PHP-DB] Programs not running

2013-01-04 Thread tamouse mailing lists
On Fri, Jan 4, 2013 at 6:09 PM, Matt Pelmear wrote: > On 01/04/2013 01:40 PM, tamouse mailing lists wrote: >> >> One should be able to solve parsing problems without resorting to using a >> web server. Every time I save a php file, I have my editor set to run it >> th

Re: [PHP-DB] Programs not running

2013-01-04 Thread tamouse mailing lists
On Fri, Jan 4, 2013 at 12:37 AM, Matt Pelmear wrote: > In my experience, the problem you are experiencing is caused by one of two > issues: > > 1) A major parsing problem (sometimes no error is displayed-- you just get > no output.) One should be able to solve parsing problems without resorting t

[PHP-DB] Re: [PHP] Shopping Cart Discount System

2012-12-31 Thread tamouse mailing lists
On Mon, Dec 31, 2012 at 2:31 AM, Karl DeSaulniers wrote: > Hello Everyone, > Hope all are well. Quick and hopefully painless question. > Is there any examples on how to build a discount system > into your shopping cart out there that anyone knows of? > I am using MySQL and PHP. I have built one of

Re: [PHP-DB] Re: Prepared Statements - Search

2012-12-03 Thread tamouse mailing lists
On Mon, Dec 3, 2012 at 3:34 PM, Jim Giner wrote: > On 12/3/2012 2:30 PM, Ethan Rosenberg, PhD wrote: >> $stmt = mysqli_stmt_init($cxn); >> mysqli_stmt_prepare( $stmt, $sql12 ); >> >> The search fails. So, you got us down to where you prepare the sql statement in

Re: [PHP-DB] CSV storage InnoDB?

2012-11-26 Thread tamouse mailing lists
On Mon, Nov 26, 2012 at 8:10 PM, Karl DeSaulniers wrote: > > On Nov 26, 2012, at 8:01 PM, Karl DeSaulniers wrote: > >> >> On Nov 26, 2012, at 7:29 PM, Bastien wrote: >> >>> >>> >>> Bastien Koert >>> >>> On 2012-11-26, at 7:43 PM, Karl DeSaulniers wrote: >>> Hello all, Quick question. >>

Re: [PHP-DB] mysqli_bind_result

2012-11-26 Thread tamouse mailing lists
On Mon, Nov 26, 2012 at 7:28 PM, Ethan Rosenberg, PhD wrote: > Dear List - > > Here is some code: > > $sql13 = "SELECT * FROM Intake3 WHERE MedRec = ?"; > $stmt = mysqli_stmt_init($cxn); > mysqli_stmt_prepare( $stmt, $sql13 ); > $_SESSION['stmt'] = $

Re: [PHP-DB] Re: Formatting

2012-11-25 Thread tamouse mailing lists
On Sun, Nov 25, 2012 at 4:40 PM, Karl DeSaulniers wrote: > Your also using a combination of and . I am thinking that you have > columns and that they lay next to each other. > Lose the and just use Hmm, well, no, it looks like the table header columns are in fact just table header columns, and

Re: [PHP-DB] Debugger

2012-10-25 Thread tamouse mailing lists
On Wed, Oct 24, 2012 at 7:20 PM, Christopher Jones wrote: > > > On 10/24/2012 05:02 PM, Ethan Rosenberg, PhD wrote: >> >> Dear list - >> >> A. Is anyone aware of a debugger that: >> >> 1] will step thru the code, >> 2] will stop at a point that input is requested [eg, form] and allow >> input? >>

Re: [PHP-DB] Need some opinions on solution

2012-10-17 Thread tamouse mailing lists
On Wed, Oct 17, 2012 at 10:53 PM, Bastien Koert wrote: > Hi All, > > Below is a situation I ran into recently. To me, the decision made > shows how to not solve a problem but merely compound the issue. > > Scenario: There is an app currently running on a highly loaded 4.11 > MySQL db. Customers ar

Re: [PHP-DB] Re: Program Dies

2012-10-16 Thread tamouse mailing lists
On Tue, Oct 16, 2012 at 9:53 PM, Ethan Rosenberg, PhD wrote: > > > > with an empty action= attribute simply calls the same URL as given. I > use this all the time for testing and for localhost one-page apps, but is a > Very Bad Idea ™ for a real on-the-internet application. > > > Thank

Re: [PHP-DB] Re: Program Dies

2012-10-16 Thread tamouse mailing lists
On Mon, Oct 15, 2012 at 11:14 AM, Jim Giner wrote: > On 10/14/2012 5:57 PM, Ethan Rosenberg, PhD wrote: >> >> Dear List - >> >> Thank you ever so much for all your help. >> >> I apologize in advance for dumping all this code on you. I cannot >> get any debugger to work for me [see my separate ema

Re: [PHP-DB] php code for sending SMS

2012-09-25 Thread tamouse mailing lists
On Wed, Sep 26, 2012 at 1:18 AM, Dr Vijay Kumar wrote: > I wish to send a SMS to a mobile no. thru PHP/HTML. Any suggestions Please? Try an email -> SMS gateway? http://en.wikipedia.org/wiki/List_of_SMS_gateways -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://w

[PHP-DB] Re: [PHP] Vulnerability Announced in phpMyAdmin

2012-09-25 Thread tamouse mailing lists
On Tue, Sep 25, 2012 at 3:20 PM, Daniel Brown wrote: > Just a three-list cross-post to bring it to everyone's attention > at once, in case you weren't already aware. It was announced today > that a compromised SourceForge mirror was distributing a malicious > file with the phpMyAdmin package

Re: [PHP-DB] Why the sudden dis-interest?

2012-09-21 Thread tamouse mailing lists
Some of them may not end up being PHP + DB programmers? Or joined under mistaken expectations? Or thought it might be a good idea at the time and ended up doing something else? Lots of possible reasons. Given the inability of the folk to figure out *how* to unsubscribe, I'd suspect rather limited u

Re: [PHP-DB] Unsubscribe me please

2012-09-20 Thread tamouse mailing lists
On Thu, Sep 20, 2012 at 3:37 AM, wrote: > > Me too (whe...@eircom.ie) > > > > > *** > The information contained in this e-mail and any files transmitted > with it is confidential and may be subject to legal professional > privilege. It i

Re: [PHP-DB] Re: Adding entry to /dev

2012-09-11 Thread tamouse mailing lists
On Mon, Sep 10, 2012 at 11:27 PM, Jim Giner wrote: > On 9/10/2012 7:41 PM, Ethan Rosenberg, PhD wrote: >> >> >> Dear list - >> >> How do I add a new entry to /dev; eg, /dev/sdb? >> >> Thanks, >> >> Ethan Rosenberg > > Ethan, > Sometimes google is great at answering this kind of stuff. Did you try

Re: [PHP-DB] Wow, this is weird

2012-09-03 Thread tamouse mailing lists
On Mon, Sep 3, 2012 at 7:58 PM, David McGlone wrote: > Why was the brackets necessary? I thought that was what the single quotes > were for. I'm thinking the brackets join ['image'] and ['name'] otherwise the > query views it as 2 seperate queries. Correct? or were the brackets use to > group it a

Re: [PHP-DB] Re: Prepared Statements Insert Problem

2012-09-03 Thread tamouse mailing lists
On Mon, Sep 3, 2012 at 7:45 AM, Jim Giner wrote: > On 9/3/2012 2:44 AM, tamouse mailing lists wrote: >> On Sun, Sep 2, 2012 at 10:24 PM, Ethan Rosenberg, PhD >> wrote: >>> >>> mysqli_stmt_bind_result(): Number of bind variables doesn't match number &

Re: [PHP-DB] Re: Prepared Statements Insert Problem

2012-09-02 Thread tamouse mailing lists
On Sun, Sep 2, 2012 at 10:24 PM, Ethan Rosenberg, PhD wrote: > mysqli_stmt_bind_result(): Number of bind variables doesn't match number of > fields in prepared statement What exactly is unclear about that? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.

Re: [PHP-DB] Re: Prepared Statements Insert Problem

2012-09-02 Thread tamouse mailing lists
> if($stmt = mysqli_stmt_prepare($stmt, "INSERT INTO Intake3 (Site, MedRec, > Fname, Lname, Phone, Height, Sex, Hx, Bday, Age) > VALUES(?,?,?,?,?,?,?,?,?,?")!=0) Let me break this into smaller chunks: if ($a = $b != 0) Precedence rules show that comparisons (!= in this case) come before assign

Re: [PHP-DB] Wow, this is weird

2012-08-29 Thread tamouse mailing lists
On Tue, Aug 28, 2012 at 6:12 AM, David McGlone wrote: > On Tuesday, August 28, 2012 12:41:19 AM you wrote: >> Here, in your original pastebin, at line 36: >> >> mysql_query ("INSERT INTO inventory(image, year, make, model, milage, price) >> VALUES('$_POST[image]', '$_POST[year]', '$_POST[make]', >

Re: [PHP-DB] Wow, this is weird

2012-08-27 Thread tamouse mailing lists
On Mon, Aug 27, 2012 at 8:03 PM, David McGlone wrote: > I got it. All I needed to do was change $_POST[image] to $image in my query > like so: > mysql_query ("INSERT INTO inventory(image, year, make, model, milage, price) > VALUES('$image', '$_POST[year]', '$_POST[make]', > '$_POST[model]', '$_P

Re: [PHP-DB] Re: No data?

2012-07-26 Thread tamouse mailing lists
argh forget that. simply put the id auto_increment field *last* in the create table defn, leave everything else as it was. On Thu, Jul 26, 2012 at 10:38 PM, tamouse mailing lists wrote: > With one change to the data file to make the indexing work correctly > and read all the fiel

Re: [PHP-DB] Re: No data?

2012-07-26 Thread tamouse mailing lists
in line 53 when creating the table: for ($i=0; $i < (count($fields)-1); $i++) { and that should do it. On Thu, Jul 26, 2012 at 10:20 PM, tamouse mailing lists wrote: > Brad, do take a look at http://pastie.org/4340383 > It does work. -- PHP Database Mailing List (http://www.php

Re: [PHP-DB] Re: No data?

2012-07-26 Thread tamouse mailing lists
Brad, do take a look at http://pastie.org/4340383 It does work. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: Database Problems

2012-06-25 Thread tamouse mailing lists
On Mon, Jun 25, 2012 at 9:46 PM, tamouse mailing lists wrote: > On Mon, Jun 25, 2012 at 7:57 AM, Peter Beckman wrote: >>  I'll save you some time, it's not the "where 1" part of the query: >> >>    mysql> select count(*) from numbers where 3 and n

Re: [PHP-DB] Re: Database Problems

2012-06-25 Thread tamouse mailing lists
On Mon, Jun 25, 2012 at 7:57 AM, Peter Beckman wrote: >  I'll save you some time, it's not the "where 1" part of the query: > >    mysql> select count(*) from numbers where 3 and num like '1212%'; The only time the where clause fails (rightly so) with a single number like what is when you do "whe

Re: [PHP-DB] Re: Database Problems

2012-06-17 Thread tamouse mailing lists
On Sun, Jun 17, 2012 at 8:22 PM, tamouse mailing lists wrote: > On Sun, Jun 17, 2012 at 5:55 PM, Ethan Rosenberg wrote: >> At 04:21 PM 6/17/2012, Jim Giner wrote: >> >>> "Ethan Rosenberg" wrote in message >>> news:0m5s00mgd2bh7...@mta1.srv.hcvlny.cv.ne

Re: [PHP-DB] Re: Database Problems

2012-06-17 Thread tamouse mailing lists
On Sun, Jun 17, 2012 at 5:55 PM, Ethan Rosenberg wrote: > At 04:21 PM 6/17/2012, Jim Giner wrote: > >> "Ethan Rosenberg" wrote in message >> news:0m5s00mgd2bh7...@mta1.srv.hcvlny.cv.net... >> > At 03:30 PM 6/17/2012, Jim Giner wrote: >> >>"Ethan Rosenberg" wrote in message >> >>news:0m5r005qyzrn

Re: [PHP-DB] School timetable in php

2012-04-21 Thread tamouse mailing lists
On Fri, Apr 20, 2012 at 7:00 AM, Vinay Kannan wrote: > I am trying to develop a school time table system in php mysql, anybody has > any headsup on the same, i was thinking about some existing scripts to take > a look at. Not entirely clear what is meant by "time table" -- do you mean schedule of

Re: [PHP-DB] Invitation from Multiply

2012-04-18 Thread tamouse mailing lists
2012/4/18 MA PROPOSISION ELMAZI (via Multiply) : > Check out my Multiply site oh i can hardly wait to see this... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Multiple result sets with a prepared statement in mysqli

2012-04-06 Thread tamouse mailing lists
On Fri, Apr 6, 2012 at 2:02 PM, tamouse mailing lists wrote: > On Fri, Apr 6, 2012 at 12:33 PM, Ken Keefe wrote: >> I am trying to use mysqli's prepared statements to execute a stored >> procedure that returns multiple result sets. I've been struggling with this >

Re: [PHP-DB] Multiple result sets with a prepared statement in mysqli

2012-04-06 Thread tamouse mailing lists
On Fri, Apr 6, 2012 at 12:33 PM, Ken Keefe wrote: > I am trying to use mysqli's prepared statements to execute a stored > procedure that returns multiple result sets. I've been struggling with this > for some time now. I have created a short example test script that > demonstrates the problem. The

Re: [PHP-DB] Storing multiple items in one MySQL field?

2012-01-12 Thread tamouse mailing lists
t;> though. >> There will be more than T-Shirts. Watches, book-covers, etc, etc. >> >> So I need to find a general logic to cover the items and attributes of >> each item? >> And this will make it scalable? >> >> Best, >> >> On Jan 11, 2012,

[PHP-DB] question about best practice for coding sql statements

2011-11-12 Thread tamouse mailing lists
I'm curious how others feel about this. When I'm creating an SQL string, either for a non-prepared or prepared execution, I build it in a variable and then pass the variable to the query or prepare function. This lets me easily add something to view the SQL statement, and also if there's an error,

Re: [PHP-DB] Need help with updating existing mysql records with something else

2011-11-12 Thread tamouse mailing lists
2011/11/11 Amit Tandon : > U can "update" the record with following > > === > $result = mysql_query("UPDATE  tax set mwool40_ > totqty = $res", $connection) or die("error > updating database"); Won't this update every row in the table? I think you'd want: $result = mysql_query("UPDATE ta

Re: [PHP-DB] Prepared Statements

2011-11-12 Thread tamouse mailing lists
On Fri, Nov 11, 2011 at 10:41 AM, Ron Piggott wrote: > > $dsh = 'mysql:host=localhost;dbname='.$database; > $dbh = new PDO($dsh, $username, $password); > > #query for the authorization code > > $query = "SELECT `authorization_code` FROM > `directory_listing_update_authorizations` WHERE NOW() BET

Re: [PHP-DB] Simple MySQL sample code runs out of memory

2011-10-28 Thread tamouse mailing lists
On Thu, Oct 27, 2011 at 10:04 PM, wrote: > Something more fundamental is going on. > > Here is simpler code which still reproduces the problem. > I get: > > PHP Fatal error:  Allowed memory size of 134217728 bytes exhausted (tried to > allocate 20 bytes) in xx3.php on line 26 > > What's up with

Re: [PHP-DB] Simple MySQL sample code runs out of memory

2011-10-27 Thread tamouse mailing lists
On Thu, Oct 27, 2011 at 9:36 PM, wrote: > On Thu, Oct 27, 2011 at 09:17:21PM -0500, tamouse mailing lists wrote: >> >> That said, I think there must be a way to do this in SQL. > > Absolutely, there's a way to do this in SQL; > > "select contract, sum

Re: [PHP-DB] Simple MySQL sample code runs out of memory

2011-10-27 Thread tamouse mailing lists
On Thu, Oct 27, 2011 at 8:56 PM, tamouse mailing lists wrote: > On Thu, Oct 27, 2011 at 6:59 PM,   wrote: >> Running PHP 5.3.5 on FreeBSD 8.2 connecting to a MySQL 5.1.55 >> server. >> >> Why does this code (below) run out of memory?  It queries >> test_table f

Re: [PHP-DB] Simple MySQL sample code runs out of memory

2011-10-27 Thread tamouse mailing lists
On Thu, Oct 27, 2011 at 6:59 PM, wrote: > Running PHP 5.3.5 on FreeBSD 8.2 connecting to a MySQL 5.1.55 > server. > > Why does this code (below) run out of memory?  It queries > test_table for all rows, all fields and sorts them by the numeric > 'contract' field.  It then iterates through the row

Re: [PHP-DB] SELECT

2011-10-21 Thread tamouse mailing lists
On Fri, Oct 21, 2011 at 2:09 AM, Ford, Mike wrote: >> -Original Message- >> From: tamouse mailing lists [mailto:tamouse.li...@gmail.com] >> Sent: 20 October 2011 21:37 >> >> On Tue, Oct 18, 2011 at 5:36 AM, Ford, Mike >> wrote: >> >> --

Re: [PHP-DB] SELECT

2011-10-20 Thread tamouse mailing lists
On Thu, Oct 20, 2011 at 3:36 PM, tamouse mailing lists wrote: > On Tue, Oct 18, 2011 at 5:36 AM, Ford, Mike wrote: >>> -Original Message- >>> From: Ron Piggott [mailto:ron.pigg...@actsministries.org] >>> Sent: 17 October 2011 18:38 >>> >>&

Re: [PHP-DB] SELECT

2011-10-20 Thread tamouse mailing lists
On Tue, Oct 18, 2011 at 5:36 AM, Ford, Mike wrote: >> -Original Message- >> From: Ron Piggott [mailto:ron.pigg...@actsministries.org] >> Sent: 17 October 2011 18:38 >> >> I need help creating a mySQL query that will select the correct >> introduction message for a website I am making.  The

Re: [PHP-DB] Re: SELECT

2011-10-20 Thread tamouse mailing lists
On Mon, Oct 17, 2011 at 12:58 PM, Jim Giner wrote: > I would do it this way: > > Where >  $sel_d = (the day # you want) >  $sel_m = (the month # you want) > > The "where" clause would be: > > Where  (start_month => $sel_m and start_day => $sel_d) and >     (end_month =< $sel_m and end_day =< $sel_

Re: [PHP-DB] Combing PDO with mysql_pconnect connections in one application -- will this degrade performance?

2009-12-10 Thread Andy Shellam (Mailing Lists)
> > One thing to be careful is if you are relying on 'transactions' to handle > anything. Obviously the transaction has to be in the same connection just to > work. Despite what others have said, the PDO connection will be different to > the generic mysql connection as it is a separate process

Re: [PHP-DB] Combing PDO with mysql_pconnect connections in one application -- will this degrade performance?

2009-12-09 Thread Andy Shellam (Mailing Lists)
> > As long as you test it (hopefully using some sort of automated tests) you > should be right. > > Since you're using persistent connections (make sure you set pdo to do the > same), I don't think you're really doubling the number of connections. Yeah, I think PDO uses the underlying mysql/

Re: [PHP-DB] Multiple instances of mysql_connect() in single PHP document.

2009-11-11 Thread Andy Shellam (Mailing Lists)
Hi, If the databases are in the same mysql server, then you could qualify the table select with the database name and simply re-use the connection select db_name.table_name.field from db_name.table_name [where] No offence, but if I saw this in an application's source code, I'd run a mile.

Re: [PHP-DB] losing MySQL resource

2009-11-09 Thread Andy Shellam (Mailing Lists)
ser. What have I missed? Thanks, Stan ""Andy Shellam (Mailing Lists)"" wrote in message news:fd8200b0-e18a-4afd-8ffc-f51080621...@networkmail.eu... Hi, I got around this by creating a database wrapper class which gets passed the credentials from the app's config file.

Re: [PHP-DB] losing MySQL resource

2009-11-09 Thread Andy Shellam (Mailing Lists)
Hi, I got around this by creating a database wrapper class which gets passed the credentials from the app's config file. An instance of the class is created and saved in the session, and every query to the database runs through the class's Query() wrapper method which checks if the conne

Re: [PHP-DB] Very old question: Mysql and old authentication

2009-10-29 Thread Andy Shellam (Mailing Lists)
-Remote Server "old_passwords" "ON" "version" "5.0.45" That's probably why - as I said in my previous e-mail, the mysqlng driver doesn't support the old authentication mechanism. If you cannot change the remote server, you need to re-compile PHP with the MySQL client library (libmysql)

Re: [PHP-DB] Very old question: Mysql and old authentication

2009-10-29 Thread Andy Shellam (Mailing Lists)
The mysqlnd driver doesn't support MySQL 4.1 or earlier - it looks like the server that you think is 5.0.45 is actually a lot older, or your user account on MySQL has been set up using the old authentication method. The solution would be to re-compile PHP 5.3 with the original MySQL clien

Re: [PHP-DB] DB interface problem

2009-10-27 Thread Andy Shellam (Mailing Lists)
orted any more and I should be using pg_execute instead... Thanks again. Giff On Tue, 2009-10-27 at 19:51 +, Andy Shellam (Mailing Lists) wrote: Hi Giff, No worries - I know the feeling well! At first glance this looks OK, however I notice that there is no "res" property defi

Re: [PHP-DB] DB interface problem

2009-10-27 Thread Andy Shellam (Mailing Lists)
Hi Chris, $this->res = @pg_execute($this->session, $query); PHP is therefore trying to assign a query result to a property that doesn't exist. I would have expected PHP to throw an error at this but it may have been obscured with your logging settings, I'm not sure. Close - the '@' bef

Re: [PHP-DB] DB interface problem

2009-10-27 Thread Andy Shellam (Mailing Lists)
y On 27 October2009, at 19:36, Giff Hammar wrote: Andy, Sometimes I'm too fast for my own good. I added .txt to the file and it should be visible as http://www.sv-phoenix.com/dbi_pgsql.txt. Just appending the .txt didn't work. Thanks for taking a look! Giff On Tue, 2009-10-27 at

Re: [PHP-DB] DB interface problem

2009-10-27 Thread Andy Shellam (Mailing Lists)
Hi Giff, I want to have a look at this for you, but you'll need to put the file on your server as plain-text because your server is parsing the PHP code and only sending us the output, not the source code. Append *.txt to your file on the server and we should be able to see it better! A

Re: [PHP-DB] $db=new mysqli fails while $db=mysqli_connect succeeds in PHP/MySQL 5

2007-08-28 Thread Linux NG/Lists
x27;--with-pear' '--with-pspell' '--enable-sockets' '--enable-track-vars' '--with-ttf' '--with-freetype-dir=/usr' '--enable-gd-native-ttf' '--with-zip' '--with-zlib' The 'mysqli_connect(...' call work

Re: [PHP-DB] $db=new mysqli fails while $db=mysqli_connect succeeds in PHP/MySQL 5

2007-08-27 Thread Linux NG/Lists
The book I'm working with (PHP & MySQL Web Dev, Welling/Thompson) specifically defines the 'new mysqli' syntax. So I'm guessing I don't have something configured right? If one works the other should too. Your code here looks fine according to the manual (http://www.php.net/manual/en/function.m

[PHP-DB] $db=new mysqli fails while $db=mysqli_connect succeeds in PHP/MySQL 5

2007-08-24 Thread Linux NG/Lists
From a php-general thread earlier: generates: Fatal error: Call to undefined function new mysqli() in index.php on line 24 while '; ?> generates success: conn good: Object id #1 :very good indeed The book I'm working with (PHP & MySQL Web Dev, Welling/Thompson) specifically d

[PHP-DB] mysql question.

2007-04-03 Thread Me2resh Lists
hi i need help regarding a sql query in my php app. the query is : $SQL = "SELECT DISTINCT(EMail) FROM mena_guests WHERE Voted = 'yes' LIMIT $startingID,$items_numbers_list"; i want to sort this query by the number of the repeated EMail counts. can anyone help me with that please ?

Re: [PHP-DB] Debian & mssql_init

2005-01-28 Thread PHPDiscuss - PHP Newsgroups and mailing lists
Robert Twitty wrote: > The problem is caused by the fact that the sybase extension was installed > instead of the mssql extension. The sybase extension supports some of the > mssql functions via aliasing. Unfortunately, mssql_init() is not supported > by the sybase ext. You basically have only 2

Re: [PHP-DB] Mozilla inserts twice, IE does OK... ?

2005-01-25 Thread PHPDiscuss - PHP Newsgroups and mailing lists
Another dimension to the problem --- I am running my code on two separate machines (Desk top & a laptop) the desktop (faster?) has this problem, notebook (slower?) doesn't. I have code that checks for duplicate inserts and warns user. Even this fails and the database ends up with two identical reco

[PHP-DB] Double Inserts

2005-01-25 Thread PHPDiscuss - PHP Newsgroups and mailing lists
Hi, I am new to the mailing list and to PHP / MySQL. I am facing an unususal problem. I am trying to insert some data into MySQL DB through via Web. The code is executed OK - no errors but the same record gets inserted TWICE. I have checked the code and simplified it as much as possible and tried t

[PHP-DB] Re: SQL statement syntaxis

2005-01-07 Thread PHPDiscuss - PHP Newsgroups and mailing lists
Hello everybody, I just want to thank you all for your help!! I got three emails helping me out. The problem was that I wasn't including the ' around the ". When I typed '".$_POST['CompanyName']."' it worked great! Thank you!! Jorge PHPDiscuss - PHP

[PHP-DB] SQL statement

2005-01-06 Thread PHPDiscuss - PHP Newsgroups and mailing lists
Hello everybody, I'm building a small application and I have trouble passing a POST variable form one page to another inside the SQL statement. The query displayed below works great without the ".$_POST['CompanyName']." $query_company_listing = "SELECT CompanyID, CompanyName, CompanyOrDepartment

[PHP-DB] SQL statement syntaxis

2005-01-06 Thread PHPDiscuss - PHP Newsgroups and mailing lists
Hello everybody, I'm building a small application and I have trouble passing a POST variable form one page to another inside the SQL statement. The query (displayed below) works great without the ".$_POST['CompanyName']." $query_company_listing = "SELECT CompanyID, CompanyName, CompanyOrDepartme

[PHP-DB] SQL statement syntaxis

2005-01-06 Thread PHPDiscuss - PHP Newsgroups and mailing lists
Hello everybody, I'm building a small application and I have trouble passing a POST variable form one page to another inside the SQL statement. The query (displayed below) works great without the ".$_POST['CompanyName']." $query_company_listing = "SELECT CompanyID, CompanyName, CompanyOrDepartme

[PHP-DB] MYSQL Maximum Time Exceeded

2004-12-15 Thread PHPDiscuss - PHP Newsgroups and mailing lists
Hi. I am running MySQL 4.0 and PHP 4.3.9 (MySQL Client Version 3.9.23) in Windows XP. I get this error when I try to connect to mysql: Fatal error: Maximum execution time of 60 seconds exceeded in c:\inetpub\wwwroot\index.php on line 4 My PHP script is: I also tried installing newer PHP

[PHP-DB] PHP-HTML-select deny

2004-12-01 Thread PHPDiscuss - PHP Newsgroups and mailing lists
Hi, what can i do, where users can't select and copy my text from web-page. Thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] backing up off of web host

2004-10-17 Thread lists
Matthew Perry wrote: The MySQL database on my web host has only non-sensitive information. How bad an idea is it to have a backup copy emailed to me at a designated time so I don't have to depend on myself and the host for backups? To qunatify how "bad of an idea" depends on how valuable your da

Re: [PHP-DB] PHP functions independant executions

2004-10-16 Thread lists
Matthew Perry wrote: How do I get my PHP funcitons to execute independantly based on what time of day it is and not on the user? This may not be how PHP was designed but I would like to do things like send out an email to someone based on suchandsuch criteria, backup DB on regular schedule etc.

Re: [PHP-DB] MySQL nested subqueries

2004-10-16 Thread lists
Matthew Perry wrote: Anyone know when there will be a version of MySQL that can handle nested subqueries? -Matt http://dev.mysql.com/doc/mysql/en/ANSI_diff_Subqueries.html v4.1, but it isn't the stable release at this time. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] Call to undefined function mysql_connect()

2004-08-01 Thread PHPDiscuss - PHP Newsgroups and mailing lists
I agree to you as my phpinfo does not show mysql at all. can you help me as in how do i get the mysql support for the same, im using PHP/MYSQL on windows 2000 Thanks Larry E . Ullman wrote: > > But i received "Call to undefined function mysql_connect() on line 5" > > > > Can anyone help me? >

[PHP-DB] writing to 2 tables

2004-07-19 Thread PHPDiscuss - PHP Newsgroups and mailing lists
Hi all, I am writing a PHP newsletter where users are able to write the news and for the information to be written to 2 tables in the database. I can do this for one table but it need it for 2. Obviously what needs to happen if that the two ids from t1 and t2 be linked together but how do i get t

[PHP-DB] Re: MySQL executes several times the same request

2004-06-29 Thread PHPDiscuss - PHP Newsgroups and mailing lists
Justin Patrin wrote: > Loïc moisy wrote: > > Hi Everyone ! > > > > I've coded a php site for a musical store. At the end of every page, before > > closing the connection, I send an UPDATE request to increment a statistical > > tool. Recently I saw weird results, so I tried to understand. Looking

[PHP-DB] MySql syntax error using PHPWiki

2004-06-10 Thread PHPDiscuss - PHP Newsgroups and mailing lists
Greetings, I'm trying to set up a PHPWiki using Apache 2.0.49, PHP 4.3.7, PEAR 4.1.0, and PHPWiki 1.3.10. I get this error when trying to load index.php: "C:\Program Files\Apache Group\Apache2\htdocs\lib\WikiDB\backend\PearDB.php:778: Fatal[256]: wikidb_backend_mysql: fatal database error DB Er

[PHP-DB] Re: Create subdomain using php in a linux machine

2004-05-31 Thread PHPDiscuss - PHP Newsgroups and mailing lists
Dhanya philip wrote: > Hi, > I like to know how to create subdomain using php in a linux machine. > Thank You > Dhanya > Yahoo! India Matrimony: Find your partner online. Did you ever find a solution for this problem?? I'm interested in doing the same. JG -- PHP Database Mailing List

[PHP-DB] Re: Slow php-mysql

2004-05-19 Thread PHPDiscuss - PHP Newsgroups and mailing lists
Hi Dez, I think I got exactly the same problem. I have W2003 Advanced Server running with IIS 6 and PHP 4.3.4. On a nother machine I have MySQL 4.1.0-alpha-nt. Now any connection from any other host in the network (e.g. running phpMyAdmin) to the DB works just fine (hosts running IIS or Apache). B

[PHP-DB] upload files into MySQL database

2004-05-11 Thread PHPDiscuss - PHP Newsgroups and mailing lists
Hello, I have problem for downloading files from MySQL database. Although I store and I see the filename and the extension in the database, when I try to download it, if there are blank spaces inside the filename, like "my book store.doc" I cannot open it and see it. Best regards Stelios Karapas

[PHP-DB] Dynamic Email Address in an HTML table

2004-05-09 Thread PHPDiscuss - PHP Newsgroups and mailing lists
Hello, I have a page displaying the results of a query from a mysql database. The final field displayed is an email address (in text datatype from the table). How can I create the email address in the field as a hyperlink to the email address? Since my query loops through the database and displayes

Re: [PHP-DB] Image / file uploader

2004-05-06 Thread PHPDiscuss - PHP Newsgroups and mailing lists
Try using the following: $_SERVER[PHP_SELF] Mainly, get rid of the quotes inside the brackets. Usually this error 'T_String' generally occurs when you have quotes (" or ') where they shouldn`t be. Give it a try if that thing still troubles you... Good luck Craig Hoffman wrote: > Sorry to be

[PHP-DB] PHP / mysql / opendb / Apache

2004-02-10 Thread PHPDiscuss - PHP Newsgroups and mailing lists
I am trying to get a functioning instance of these components working on my Solaris 2.8 box. Are there any comprehensive instructions out there to achieve this? Thanks Terry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Re: using

2003-10-22 Thread lists
BECOMES: > This works only if it's within an echo statement: echo ""; and you must make sure to either use single quotes around the href link, or else escape the double quotes with a backslash: echo ""; Alternatively, you can do it this way: "> (ie embed the echo within a regular HTML ta

[PHP-DB] send values i don´t know which 2 send?

2001-09-09 Thread AtK - php-lists
hi, problem: I list a couple of values in a row, and another row with possible entrys (like: and so on (look at the script on: http://analyze.at/prob1.phps ) so now i want to be able to send the values in the next script in a hidden field.. but how do i realize that if i don´t know what and