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 erosenb...@hygeiabiomedical.com 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

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 robert.vanderh...@umassmed.edu 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

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 erosenb...@hygeiabiomedical.com 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

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 mjpelm...@gmail.com 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,

Re: [PHP-DB] Error Checking

2013-01-08 Thread tamouse mailing lists
On Tue, Jan 8, 2013 at 11:54 AM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com 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?

Re: [PHP-DB] Programs not running

2013-01-06 Thread tamouse mailing lists
On Sun, Jan 6, 2013 at 1:21 AM, Karl DeSaulniers k...@designdrumm.com 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

Re: [PHP-DB] Programs not running

2013-01-06 Thread tamouse mailing lists
On Sun, Jan 6, 2013 at 2:14 PM, Karl DeSaulniers k...@designdrumm.com 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

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 jim.gi...@albanyhandball.com 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);

Re: [PHP-DB] Programs not running

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

Re: [PHP-DB] Programs not running

2013-01-04 Thread tamouse mailing lists
On Fri, Jan 4, 2013 at 12:37 AM, Matt Pelmear mjpelm...@gmail.com 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

Re: [PHP-DB] Programs not running

2013-01-04 Thread tamouse mailing lists
On Fri, Jan 4, 2013 at 6:09 PM, Matt Pelmear mjpelm...@gmail.com 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 through php -l. Saves

[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 k...@designdrumm.com 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

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 jim.gi...@albanyhandball.com 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

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 erosenb...@hygeiabiomedical.com wrote: Dear List - Here is some code: $sql13 = SELECT * FROM Intake3 WHERE MedRec = ?; $stmt = mysqli_stmt_init($cxn); mysqli_stmt_prepare( $stmt, $sql13 );

Re: [PHP-DB] CSV storage InnoDB?

2012-11-26 Thread tamouse mailing lists
On Mon, Nov 26, 2012 at 8:10 PM, Karl DeSaulniers k...@designdrumm.com 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 k...@designdrumm.com wrote: Hello all, Quick

Re: [PHP-DB] Re: Formatting

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

Re: [PHP-DB] Debugger

2012-10-25 Thread tamouse mailing lists
On Wed, Oct 24, 2012 at 7:20 PM, Christopher Jones christopher.jo...@oracle.com 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

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

Re: [PHP-DB] Re: Program Dies

2012-10-16 Thread tamouse mailing lists
On Mon, Oct 15, 2012 at 11:14 AM, Jim Giner jim.gi...@albanyhandball.com 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

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 erosenb...@hygeiabiomedical.com wrote: snip form 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

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

2012-09-26 Thread tamouse mailing lists
On Tue, Sep 25, 2012 at 3:20 PM, Daniel Brown danbr...@php.net 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

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

2012-09-26 Thread tamouse mailing lists
On Wed, Sep 26, 2012 at 1:18 AM, Dr Vijay Kumar vaibhavinformat...@gmail.com 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

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

Re: [PHP-DB] Unsubscribe me please

2012-09-20 Thread tamouse mailing lists
On Thu, Sep 20, 2012 at 3:37 AM, whe...@eircom.ie 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

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 jim.gi...@albanyhandball.com 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

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

2012-09-03 Thread tamouse mailing lists
On Sun, Sep 2, 2012 at 10:24 PM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com 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

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 jim.gi...@albanyhandball.com wrote: On 9/3/2012 2:44 AM, tamouse mailing lists wrote: On Sun, Sep 2, 2012 at 10:24 PM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: mysqli_stmt_bind_result(): Number of bind variables doesn't match number

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 da...@dmcentral.net 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

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 assignment

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 da...@dmcentral.net 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]',

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 da...@dmcentral.net 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]',

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: 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 tamouse.li...@gmail.com wrote: Brad, do take a look at http://pastie.org/4340383 It does work. -- PHP Database Mailing List (http

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 tamouse.li...@gmail.com wrote: With one change to the data file to make the indexing work correctly and read all

Re: [PHP-DB] Re: Database Problems

2012-06-25 Thread tamouse mailing lists
On Mon, Jun 25, 2012 at 7:57 AM, Peter Beckman beck...@angryox.com 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

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 tamouse.li...@gmail.com wrote: On Mon, Jun 25, 2012 at 7:57 AM, Peter Beckman beck...@angryox.com 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

Re: [PHP-DB] Re: Database Problems

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

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 tamouse.li...@gmail.com wrote: On Sun, Jun 17, 2012 at 5:55 PM, Ethan Rosenberg eth...@earthlink.net wrote: At 04:21 PM 6/17/2012, Jim Giner wrote: Ethan Rosenberg eth...@earthlink.net wrote in message news:0m5s00mgd2bh7...@mta1

Re: [PHP-DB] School timetable in php

2012-04-22 Thread tamouse mailing lists
On Fri, Apr 20, 2012 at 7:00 AM, Vinay Kannan viny...@gmail.com 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

Re: [PHP-DB] Invitation from Multiply

2012-04-18 Thread tamouse mailing lists
2012/4/18 MA PROPOSISION ELMAZI (via Multiply) multi...@multiply.com: 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 12:33 PM, Ken Keefe kjke...@illinois.edu 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

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 tamouse.li...@gmail.com wrote: On Fri, Apr 6, 2012 at 12:33 PM, Ken Keefe kjke...@illinois.edu wrote: I am trying to use mysqli's prepared statements to execute a stored procedure that returns multiple result sets. I've been struggling

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

2012-01-12 Thread tamouse mailing lists
-down before implementation 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, at 4:39 PM, tamouse mailing lists wrote: I am

Re: [PHP-DB] Prepared Statements

2011-11-12 Thread tamouse mailing lists
On Fri, Nov 11, 2011 at 10:41 AM, Ron Piggott ron.pigg...@actsministries.org wrote: ?php $dsh = 'mysql:host=localhost;dbname='.$database; $dbh = new PDO($dsh, $username, $password); #query for the authorization code $query = SELECT `authorization_code` FROM

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

[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] Simple MySQL sample code runs out of memory

2011-10-28 Thread tamouse mailing lists
On Thu, Oct 27, 2011 at 10:04 PM, p...@umpquanet.com 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

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, p...@umpquanet.com 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

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, p...@umpquanet.com 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(1) from test_table group by contract

Re: [PHP-DB] SELECT

2011-10-21 Thread tamouse mailing lists
On Fri, Oct 21, 2011 at 2:09 AM, Ford, Mike m.f...@leedsmet.ac.uk 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 m.f...@leedsmet.ac.uk wrote: -Original Message

Re: [PHP-DB] Re: SELECT

2011-10-20 Thread tamouse mailing lists
On Mon, Oct 17, 2011 at 12:58 PM, Jim Giner jim.gi...@albanyhandball.com 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

Re: [PHP-DB] SELECT

2011-10-20 Thread tamouse mailing lists
On Tue, Oct 18, 2011 at 5:36 AM, Ford, Mike m.f...@leedsmet.ac.uk 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

Re: [PHP-DB] SELECT

2011-10-20 Thread tamouse mailing lists
On Thu, Oct 20, 2011 at 3:36 PM, tamouse mailing lists tamouse.li...@gmail.com wrote: On Tue, Oct 18, 2011 at 5:36 AM, Ford, Mike m.f...@leedsmet.ac.uk wrote: -Original Message- From: Ron Piggott [mailto:ron.pigg...@actsministries.org] Sent: 17 October 2011 18:38 I need help creating

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

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

Re: [PHP-DB] losing MySQL resource

2009-11-09 Thread Andy Shellam (Mailing Lists)
I missed? Thanks, Stan Andy Shellam (Mailing Lists) andy-li...@networkmail.eu 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. An instance

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

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

Re: [PHP-DB] DB interface problem

2009-10-27 Thread Andy Shellam (Mailing Lists)
.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 17:49 +, Andy Shellam (Mailing Lists) wrote: Hi Giff, I want to have a look at this for you, but you'll need to put

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

Re: [PHP-DB] DB interface problem

2009-10-27 Thread Andy Shellam (Mailing Lists)
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 defined in the STH class

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

2007-08-28 Thread Linux NG/Lists
, right? Whil This will show a lot useful information about what your web server and your php can or cannot do. Linux NG/Lists wrote: 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

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

[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: ?php $db=new mysqli('localhost','whil','secret','test'); ? generates: Fatal error: Call to undefined function new mysqli() in index.php on line 24 while ?php $conn = mysqli_connect(localhost,whil,secret,test); echo 'conn good: '.$conn.'

[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

[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

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

[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 Newsgroups and mailing lists wrote: Hello

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

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

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

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,

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.

[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

[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 in my

[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

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

[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

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

[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: input type=checkbox name=$row[1] value=$row2[1] input type=checkbox name=$row[1] value=$row2[2] and so on (look at the script on: http://analyze.at/prob1.phps ) so now i want to be able to send the