Re: [PHP-DB] One query, different tables?

table is named exan and the other dynamite.) Thank you very much for your help. I have been searching google but can't find anything about this question. Karl -- Niel Archer niel.archer (at) blueyonder.co.uk -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] PDO Exceptions

into a try block? Thanks, -KJW Proverbs 3:5-6 Are you aware that there is a setting to control whether PDO objects throw exceptions, warnings, or nothing? By default it does nothing except set the error code and message. See http://uk3.php.net/manual/en/pdo.error-handling.php -- Niel Archer

Re: [PHP-DB] Activating the mysql_clear_password plugin

Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- 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] Activating the mysql_clear_password plugin

configuration file for this setting the client to use the plugin (enable-cleartext-plugin) then: mysqli_options(MYSQLI_READ_DEFAULT_FILE,'myother.cnf'); to use those settings on the connection. -- Niel Archer niel.archer (at) blueyonder.co.uk -- PHP Database Mailing List (http://www.php.net

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

.; return $row; } TIA Karl DeSaulniers Design Drumm http://designdrumm.com -- 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 -- PHP Database

Re: [PHP-DB] Receiving Error- Error: user account already exists..

use an array inside a double-quoted string like that, change it to be wrapped in braces like: $rs_duplicates = mysql_query(select id from users where user_email=' {$_POST[email]}'); -- Niel Archer niel.archer (at) blueyonder.co.uk -- PHP Database Mailing List (http://www.php.net

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

Software Foundation\Apache2.2\htdocs\a.php* on line *2 *Please guide me as to how can I get rid of this error? Regards, Kushal -- 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_query

After your mysql_select_db() there is a closing brace without matching open. This will be causing an error in that php block. -- 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] Can't find sqlite_open

is not a PDO statement. It belongs to the PECL SQLite extension. This extension is quite old and is superseded by the SQLite3 extension and/or PDO. Thanks! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Niel Archer niel.archer

Re: [PHP-DB] Re: Word Activity Application

“Encouragement from God’s Word” http://www.TheVerseOfTheDay.info -- 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] Re: [PHP] Strange Query Error...

://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Could you show the actual code, not just the query. The way you are setting up the query could be affecting it. i.e. using single quotes when assigning to a variable would not work with your query. -- Niel Archer niel.archer

Re: [PHP-DB] If condition in query

A simple example would be: $where ' '; if (isset($ste)) { $where .= site = '$ste'; } if (isset($wgt)) { $where .= , Weight = '$wgt'; } $sql .= WHERE $where; -- Niel Archer niel.archer (at) blueyonder.co.uk -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] query help

a look at http://dev.mysql.com/doc/refman/5.0/en/insert.html Specifically you can use your idea to build an INSERT/VALUE version of the syntax INSERT INTO table (col1, col2, .colN.) VALUES (col1Value1, col2value1, colNvalue1), (col1Value2, col2value2, colNvalue2), ... -- Niel Archer niel.archer

Re: [PHP-DB] Parsing Tab Delimited file

command. It can be done, IF the MySQL server allows you to do it.. Check the servers configuration. How do I do it? Code samples, please. Thanks. Ethan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Niel Archer

Re: [PHP-DB] Stuck in apostrophe hell

) VALUES (%s, %s, '%s', '%s', '%s', '%s'), $_POST[Class_ID], $_POST[prid], mysql_real_escape_string(parseNull($_POST['Company'])), mysql_real_escape_string($_POST[Phone]), mysql_real_escape_string($_POST[Email]), mysql_real_escape_string($_POST['Registrant'])); -- Niel Archer niel.archer

Re: [PHP-DB] Broken query

... to AND `Bible_trivia_category_reference` != ( SELECT ... -- 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

Re: [PHP-DB] deleting rows with composite primary key

is appreciated. Eli -- 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] deleting rows with composite primary key

. And try var_dump()ing the complete query to make sure it looks as you would expect. Any help is appreciated. Eli -- 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] deleting rows with composite primary key

On Tue, May 18, 2010 at 2:51 PM, Niel Archer n...@chance.now wrote: Is there a different syntax to the mysql delete statement when the WHERE clause points only to half of the primary key? The structure is as follows: CREATE TABLE IF NOT EXISTS ` table1` (   `id1` int(10

Re: [PHP-DB] PDO + The Role of PHP + SQLite - Am I missing something?

/) To unsubscribe, visit: http://www.php.net/unsub.php -- 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] PDOException: could not find driver (postgres)

$pdo = new PDO('pgsql:host=localhost;port=5432;dbname=mydb', 'dbuser', 'dbpass'); (I think - I've yet to be able to debug it down to a single line) -- Niel Archer niel.archer (at) blueyonder.co.uk -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

Re: [PHP-DB] include_path in appache.conf

in the /home/virtual/site#/root directory to no avail. Any ideas how to make this work or even a better set up? Thanks in advance. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Niel Archer niel.archer

Re: [PHP-DB] PDO include table name prefixes in FETCH_ASSOC

://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- 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] Help for a beginner

, visit: http://www.php.net/unsub.php -- 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] Does PHP5 support querying an MS Access MDE file?

/unsub.php -- 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] Very old question: Mysql and old authentication

driver. More information can be found in the MySQL manual on upgrading from v4.0 to v4.1 http://dev.mysql.com/doc/refman/4.1/en/upgrading-from-previous-series.html http://dev.mysql.com/doc/refman/4.1/en/old-client.html -- Niel Archer niel.archer (at) blueyonder.co.uk -- PHP Database Mailing List

Re: [PHP-DB] scheduler

basic maintenance work or carry out automated tasks. Thanks, Vinay -- 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] losing MySQL resource

(http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- 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] Invalid library (maybe not a PHP library) : Error while loading pdo-ext.

Hi you would do better to raise these issues on the internals lists, either intern...@lists.php.net or internals-...@lists.php.net -- 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] 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

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

the returned data instead of the entire 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, Bastien, thanks for your efforts

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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] 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] __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] 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] 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] 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] 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] 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] Re: record pointer

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

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

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

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

  1   2   >