Re: [PHP-DB] CURL and process not finishing

Hi Are you running this as CLI or from your web-server? If the latter, use phpinfo() and check the max_execution_time isn't causing you problems. Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Syntax Error

Hi is the syntax error reported for the php or the SQL? Better yet, supply the actual error message, so we can see for ourselves Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Newbie alert: supplied argument is not a valid MySQL result resource

: ' . mysql_error()); $sid = mysql_fetch_array($query) if ($sid === false) die ('Could not fetch from database: ' . mysql_error()); -- Niel Archer -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] PHP/MySQL UTF-8 SNAFU

Hi What functions are you using? Many of PHP's functions are not multibyte aware and default to ASCII. I had this problems myself end of last year. -- Niel Archer -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] PHP MySQL Issue!

Hi Give us a clue? What's the error(s) you get returned? -- Niel Archer -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] PHP + PostgreSQL: invalid byte sequence for encoding UTF8

to be converted from some other character set. I had similar problems getting PHP to work with UTF-8 and MySQL. Many of PHP's function are not multibyte aware and assume a Latin character set. What, if any, output buffering are you using? What is your default_charset set to? -- Niel Archer -- PHP

Re: [PHP-DB] PHP + PostgreSQL: invalid byte sequence for encoding UTF8

correctly. You did not answer the most important question. What, if any, output buffering are you using? Are you using the mbstring module? If so, is it set to overload the old string functions? -- Niel Archer -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] PHP + PostgreSQL: invalid byte sequence for encoding UTF8

problems. The other thing to be wary of, is output to the console. Some OSes do not support unicode in the console. So unless you're certain yours does, I wouldn't use it as a test. -- Niel Archer -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] mysql different server different EXPLAIN result

log for details of what was altered, to see if it's relevant. -- Niel Archer -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Store more than 1 piece of information in a single variable

indexes, so it will have $row[0] and $row['user_id'] in it. It has an optional second parameter to indicate associative, numerical or both, defaulting to both. mysql_fetch_row only fetches numerically indexed arrays -- Niel Archer -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

Re: [PHP-DB] Interbase Problem

Hi We are running Firebird 0.94 SS on RedHat 7.1 Compaq Server Hope this rings a bell?? Niel Jorge Alvarez [EMAIL PROTECTED] wrote in message 9h90ja$1a8$[EMAIL PROTECTED]">news:9h90ja$1a8$[EMAIL PROTECTED]... What OS is running in the InterBase machine? Are you running IB

Re: [PHP-DB] SELECT with ibase_prepare/ibase_execute possible?

Hi Yes it is possible I'm using it currentlyon some of my major qry's You'd prepare the qry and the instead of using the ibase_query just use the ibase_execute in the same way Niel Arne Borkowski (borko.net) [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... Hi, I can use

[PHP-DB] Passing XML

using for eg. fopen( http://url.com/xml.php?xml=xml_string_document , 'r' ) Any help would be VERY helpfull thanks Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list

Re: [PHP-DB] Unicode error with PostgreSQL

Hi Tony You can use the multibyte aware string functions for processing. There is also a way to make it use UTF-8 encoding, but I forget how just now. I had the same problem with a MySQL db a while back. Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] moving a selection of records from one table to another (identical in structure) table?

Hi Easiest way would be to have MySQL to do it, using an INSERT ... SELECT statement Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] moving a selection of records from one table to another (identical in structure) table?

Hi Easiest way would be to have MySQL to do it, using an INSERT ... SELECT statement ... and if you're moving (not just copying) deleting the selected records after of course. Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: moving a selection of records from one table to another (identical in structure) table?

insert as it is made, but that should not be a major problem. Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Search engine

, you might start by looking at the Service_Google package on PEAR. At the very least, it should allow you to have Google search your pages for you. Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Search engine

[2]) of corresponding link text, but only for a basic link, without additional attributes Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Array

, strtolower, and explode functions. Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] user directory from a form

? Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] user directory from a form

Hi I would like to extract the path from the users machine Yes, I got that, but you still haven't explained whether you're just not getting the path or don't know how to isolate it Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] How to stop the server timing out

the efficiency of your SQL statement (or the db's structure) so it can execute and return faster. But if you're processing a lot of data that may not be enough Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] mysql_error function

function. This is incorrect. mysql_error() retreives the error message from the last mysql function (excluding itself or mysql_errno) executed, not the last connection. Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Php 5 and Mysql on Windows

on setting up IIS and where to put the php5isapi.dll so it is found Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] mysql_error function

, or to close the first connection and retry the second after so it is the only connection. Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] SELECT date query

a digit in range 0-6. 0 = Sunday, 6 = Saturday function DayOfWeek($Year, $Month, $Day) { $t = array(0, 3, 2, 5, 0, 3, 5, 1, 4, 6, 2, 4); $Year -= $Month 3; return ($Year + ($Year / 4) - ($Year / 100) + ($Year / 400) + $t[$Month - 1] + $Day) % 7; } Niel -- PHP Database Mailing List

Re: [PHP-DB] SELECT date query

Hi You can make this easier with date('w'). Doh, that'll teach me to code at 5 am. I knew there was a better way, but couldn't think of it, the sound of my bed calling was too distracting. Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

Re: [PHP-DB] ECHO $variable

Hi Where's the DB question? Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: ECHO $variable

: ?echo $saved_message_title;? with: ?echo htmlentities($saved_message_title);? Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] mysql databases

Hi Bob Your question isn't very clear. Do you want to remove the oldest entry, newest, or is there some other criteria to diceide? Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] mysql databases

entry, not the oldest, hence I stopped guessing and asked. Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Verifying syntax executed correctly

Hi All of the MySQL functions you used, return FALSE on failure. Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MySQL SQL Query Help

Hi Try: SELECT fkid, MAX(foo), bar FROM table GROUP BY fkid ORDER BY bar DESC Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Installation Problem

Hi If you're on a windows platform, this will be because MySQL support is built in on v4.1 but not on 5.x. As the others have suggested, uncomment the php_mysql.dll entry in the modules to add it. Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] Special Character

Hi Is it really a hyphen, or is it an en- or em-dash. The latter two could mess up in in some character sets. Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Special Character

some of Window's/Word's behaviour (to be using UTF-8 for example). Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Special Character

Hi David off the top of my head, the best I can suggest is using PHP's MB functions (lookup mb_string) to allow recognition and then convert them to hyphens. Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Special Character

Hi Doh... that's 'mbstring' Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Moving phpNuke to phpBB

to convert the stored passwords? Nuke uses a 40 char hash, while phpBB only 32. Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Any hints lantin1 utf-8

all the data before making the change, or it WILL be corrupted. If you primarily use non-latin character sets, I'd recommend making UTF-8 the default database character set Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Any hints lantin1 utf-8

, and enter it into your new UTF-8 ones Without knowing more about your configuration (local/remote, versions, etc.) I can't suggest much else. Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] CSV import to mySql

Hi Your example data does have an invalid field count The first row has has 7 fields, the other 6. So if you took them from your actual data that's your problem Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Invoking database php file with hyperlink

Hi button/hyperlink, no difference. It's the page that is target that does the work Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Limited number of database results

Hi use a LIMIT clause in your SQL. Something like: $query=SELECT * FROM WHERE hello = '$hello' LIMIT . ($page - 1) * $rows . , $rows; then you only need specify the logic to set the page, row and limitations Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

Re: [PHP-DB] search result error message

result, index.htm please try again ./div /div; } You'll probably need to polish this some, because I quickly cut/pasted it before I go down the pub. Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] CURL and process not finishing

Hi Are you running this as CLI or from your web-server? If the latter, use phpinfo() and check the max_execution_time isn't causing you problems. Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Syntax Error

Hi is the syntax error reported for the php or the SQL? Better yet, supply the actual error message, so we can see for ourselves Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] CURL and process not finishing

. Please see the set_time_limit() function for more details. Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] mysql rereading result set (fetch_assoc)

no additional memory but be slower. It also might require you to duplicate code. Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Formatting MySQL Queries

Hi SELECT * FROM table INTO OUTFILE 'file_name' FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] What effects MySQL connection's character set

Hi all How is the character set of returned data effected? I have a DB using UTF-8 encoding., PHP is set to use UTF-8 internally. However the MySQL connection returns Latin1 data. How can I get it to return UTF-8 data instead. TIA Niel -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] Am I missing something?

Hi Alright, I did that. I now get : INSERT INTO domains ( picture, thumbnail ) values( '', '') and no data entered. Then for some reason your variables are empty. Make sure they have data on entry to the function. If they don't keep backtracking until you find where it's lost. Niel

Re: [PHP-DB] can u help me in PHP

with. I'm pretty certain it's part of 4.1. However, this doesn't mean it is enabled. If I recall correctly, on a windows platform it is available as a dll, but needs to be enabled in the php.ini. With other platforms, I think it needs to be compiled in with an additional switch. Niel -- PHP

Re: [PHP-DB] How to tell if a field type is auto_increment

Hi Try using: SHOW COLUMNS FROM db.table LIKE 'field_name%' and from the returned row, check the 'Extra' column for 'auto_increment' Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] What effects MySQL connection's character set

ideas? Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] How to tell if a field type is auto_increment

Hi John, I'd suggest searching within the Extra field instead of testing for the value explicitly, as this field can theoretically hold several extra pieces of information. Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] What effects MySQL connection's character set

) on the object, which will change the connection parameter. Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Trying to add primary key to existing database.

Hi. I don't know cPanel, but I expect it can run SQL directly, most panels can. Use the ALTER TABLE ADD {INDEX|KEY} syntax to add indexes/primary keys. You can use multiple columns, which together form a unique value to create your primary key. Niel -- PHP Database Mailing List (http

Re: [PHP-DB] csv problem.. read csv from var

Fosfatase,SGOT,SGPT,Urine Lengkap,Feses Rutin,Darah Samar Faeces,VDRL,Anti - HBs,Total PSA,HBsAg,Anti - HCV Total\; what should i do to make the ouput like above. Use $arry = explode(',', $csv); to separate the variable into an array, then process it using foreach as before Niel -- PHP

Re: [PHP-DB] csv problem.. read csv from var

] . \n; } print $txt; Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Urgent! Installing PHP 4 on 64-bit machines

Hi I need urgent help. Have anyone successfully installed PHP 4 MySQL 4.0 on 64-bit Windows? Frankly, why would you want to? Neither are written for 64 bit. The only versions I could find for 64 bit were the 5.x versions in both. Which is what I run on my personal computer. Niel

Re: [PHP-DB] Urgent! Installing PHP 4 on 64-bit machines

fix we could find. Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Inheritance question

'; } } $object1 = new a; $object2 = new b($object1); $object1-someMethod(); $object2-someOtherMethod(); print $object2-a-one, $object2-two; There are more than likely other ways to go about this. Check the documentation for further examples of how to use classes in PHP. Niel -- PHP Database Mailing

Re: [PHP-DB] sunrise / sunsite / correcting for summer time

will only remain accurate until the goal posts are moved next. The U.S. for example changed their DST dates last year (end date moved back). Australia and other countries have also recently changed. In these cases, either your code or the language need to be updated after such changes. . Niel -- PHP

Re: [PHP-DB] problems with functions/included files/mysql resource

UseDb() { global $db; ... some more code ... } ? Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] 20K photos

worth of files and show the page. Back/Next tell the page what offset to use for the LIMIT clause. Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] tell mysql error

Hi mysql -h localhost -u root -p 123456 should be: mysql -h localhost -u root -p123456 notice no space after -p or it asks for the password. Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] tell mysql error

Hi Sounds like you do not have the required privileges with your user account.. I suggest you spend some time reading the MySQL documentation on privileges. Are you using the root account? Have you created other user accounts and given them the required privileges? Niel -- PHP Database

Re: [PHP-DB] tell me syntax

http://dev.mysql.com/doc/refman/5.1/en/grant.html Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

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

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

error it encounters. That's how I identified your initial error. Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

that will generate XML for you, like the PEAR XML_Query2XML package which converts SQL SELECT results into valid XML data. Or PECL's xmlwriter. Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] how to delete

Hi There is no DESTROYIMAGE() function. May be you mean imagedestroy(). If so this does NOT erase files, it destroys in memory images created using the Image functions. To erase files use the unlink function. For detail look here http://uk3.php.net/unlink Niel -- PHP Database Mailing List

Re: [PHP-DB] Catchable fatal error: Object of class stdClass could not be converted to string in filename on line line

the constructor and prepare methods also. Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: record pointer

to all the records that belong to the same cat(egory)! Assuming that is correct now, use a sub-query: SELECT id, name FROM table WHERE cat = (SELECT CAT FROM table WHERE id=$ID); Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: record pointer

| +-+--+ Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] __CYGWIN32__

a Unix-Like environment. You need a list like the developers one, where they're more knowledgeable with building PHP/MySQL -- Niel Archer -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] showing warnings

entries for each row, I'd suggest you do the following as a minimum: ALTER TABLE Mobile_Tunes ADD PRIMARY KEY (Tune_Name); -- Niel Archer -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] showing warnings

in it I doubt he'd be using a Db at all. I'm assuming this is just a sample. -- Niel Archer -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Pages not fully loading

the code, No! -- Niel Archer -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Data not fetching in the textfield.

Your variable value is not being inserted because you have used single quotes for the echo, not double quotes as the nabble example does. Special characters and variables are only interpreted in double quotes, they are treated literally in single quotes. -- Niel Archer -- PHP Database Mailing

Re: [PHP-DB] Inserting databasecontent within the same form

results where `zipcode` does not exist in the City table. -- Niel Archer -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Inserting databasecontent within the same form

afraid I can't help. You would be better trying a list dedicated to ajax. -- Niel Archer -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Variables Forms

+white-space combination to indicate multiple line entries. Is it possible your e-mail header fields are doing this and your access to the headers does not take this possibility into account? Without your POP handling code it's impossible to say whether this is your problem or not. -- Niel Archer

Re: [PHP-DB] php maximum characters in text field

Hi Does anyone know how to look for a Curly quote or typographer's quotation mark. Do you mean the equivalent of the left and right double quote entities in HTML (or 66's and 99's as we called them at school)? -- Niel Archer -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] Select...

to make the connection. This should get you started SELECT * FROM Table1 RIGHT JOIN Table2 USING (idequipomed) WHERE Table1.idequipomed IS NULL -- Niel Archer -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Help to improve MySQL query

Hi You do not say how you identify the last call (there is no date/time field for example), so a complete answer is not really possible Do not use NOT LIKE 'Completed', it's an inefficient way of doing != 'Completed' -- Niel Archer -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] If( Query)

. Is this a compatability error? or is there a better way to write this? -- Niel Archer -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] solution reqd for summation of vertical columns in PHP

they're after SUM SELECT SUM(price) WHERE available = 1; would total the values in the returned row's price column -- Niel Archer -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Bulk Insert from text file

backslash to escape the backslash for phpMyAdmin, I do not remember how that works with phpMyAdmin. -- Niel Archer -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Not Valid URL

the double quotes in a single quoted string -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Niel Archer -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] mysqli error

-- Niel Archer niel.archer (at) blueyonder.co.uk -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] mysql_insert_id() and JOIN

not to do a link between tables in PHPMyAdmin? Thank you very... VERY... much! If you are using MySQL 4.1 or later you should use the mysqli extension and not the older mysql one. UNLESS you are relying on the older style passwords, which is a BAD idea. -- Niel Archer -- PHP Database

Re: [PHP-DB] Re: [PHP] A prepared statements question

http://www.parasane.net/ || http://www.pilotpig.net/ Check out our great hosting and dedicated server deals at http://twitter.com/pilotpig -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Niel Archer -- PHP Database Mailing List

Re: [PHP-DB] mysql_insert_id() and JOIN

_ // Diseño Comunicación // -- Niel Archer niel.archer (at) blueyonder.co.uk -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] simple INSERT statement with placeholders failing. I don't understand why.

here: http://uk.php.net/manual/en/book.mysqli.php It has links to the appropriate function references for the MySQL Improved interface. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Niel Archer niel.archer (at) blueyonder.co.uk

Re: [PHP-DB] Single Quotes in Form Inputs

reading of the documentation is correct. But as far as I can tell no escaping is performed on PDO::query or PDO::exec other than what you do yourself, so you have the same risks that need to be addressed. -- Niel Archer niel.archer (at) blueyonder.co.uk -- PHP Database Mailing List (http

Re: [PHP-DB] newbie: how to return one iteration *per unique date (DAY!)* in a timestamp column?

()); If you are aliasing a column it is better to use the optional AS keyword to avoid confusion. MySQL's DATE function returns dates formatted as '-MM-DD' so DATE_FORMAT is not needed here. -- Niel Archer niel.archer (at) blueyonder.co.uk -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] newbie: how to return one iteration *per unique date (DAY!)* in a timestamp column?

to use the optional AS keyword to avoid confusion. MySQL's DATE function returns dates formatted as '-MM-DD' so DATE_FORMAT is not needed here. -- Niel Archer niel.archer (at) blueyonder.co.uk -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

  1   2   >