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

fer both Dynamite and Exan in one query to their > respective tables? (One 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 nie

Re: [PHP-DB] PDO Exceptions

it does nothing except set the error code and message. See http://uk3.php.net/manual/en/pdo.error-handling.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

e a separate 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 (h

Re: [PHP-DB] Activating the mysql_clear_password plugin

? > > Regards, > > Pierre-Gildas MILLON > pg.mil...@gmail.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 Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

$row['pd_description'] = nl2br($row['pd_description']); > > if ($row['pd_image']) { > $row['pd_image'] = PRODUCT_IMAGE_DIR . $row['pd_image']; > } else { > $row['pd_image'] = WEB_ROOT . 'images/no-image-logo.png'; > } > > $row['cart_url'] = WEB_ROOT."cart.php?action=add&p=".$pdId.""; > > 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 Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

$rs_duplicates = mysql_query("select id from users where > user_email='$_POST[email]'"); You should test $rs_duplicates !== false to be sure you have a valid resource. Have you tried retrieving the supposed row(s) and var_dump-ing them to see what it thinks they are? M

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

-- Niel Archer niel.archer (at) blueyonder.co.uk > Hello phpers and sqlheads, > If you have a moment, I have a question. > > INTRO: > I am trying to set up categories for a web site. > Each item can belong to more than one category. > > IE: Mens, T-Shirts, Long

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

. $row->name . ''; > } > > $db->close(); > ?> > > I get the error: *Fatal error*: Class 'MySQLi' not found in *C:\Program > Files\Apache Software Foundation\Apache2.2\htdocs\a.php* on line *2 > > *Please guide me as to how can I get rid o

Re: [PHP-DB] mysql_query

gt; echo ""; > while($row = mysql_fetch_assoc($result)) { >if($firstRow == 1) { > echo ""; > > foreach($row as $key => $value) { > echo "" . $key . ""; > } > echo ""; > $fir

Re: [PHP-DB] Can't find sqlite_open

re, and a older version, which would provide sqlite_open. Is > that correct? 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 Mai

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

P to display the definitions in random order? OR Is there a > way do this in mySQL that would mix and match results from different rows? > This is the query gives me the 5 results > > SELECT `reference` , `word` , `explanation` > FROM `Bible_dictionary` > WHERE `live` =1 > ORDER BY RAND( ) > LIMIT 5 > > Ron > > The Verse of the Day > “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...

Don > > -- > PHP Database Mailing List (http://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

Re: [PHP-DB] If condition in query

e, but not necessarily all, of the parameters and be > able to output the results. > > Advice and help please. > > Thanks in advance. > > Ethan First you need to protect your input from injection and other attacks. http://en.wikipedia.org/wiki/SQL_injection for the problem y

Re: [PHP-DB] query help

VALUES (col1Value1, col2value1, colNvalue1), (col1Value2, col2value2, colNvalue2), ... -- 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] Parsing Tab Delimited file

> 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] Stuck in apostrophe hell

ly needs a double backslash for O'Brien. One to escape the apostrophe and one to escape the backslash escaping the apostrophe. ;-) This would be because you're not using mysql_real_escape_string() on the third parameter. Try this (not tested): $sql_insert_registration = sprintf("INSERT INTO Registrations ( Class_ID, prid, Registrant, Company, Phone, Email ) 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 (at) blueyonder.co.uk -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Broken query

BY RAND() > LIMIT 1 Try changing: "AND NOT `Bible_trivia_category_reference` = ( SELECT ..." to "AND `Bible_trivia_category_reference` != ( SELECT ..." > > -- > 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

> On Tue, May 18, 2010 at 2:51 PM, Niel Archer wrote: > >> > Is there a different syntax to the mysql delete statement when the > >> > "WHERE" > >> > clause points only to half of the primary key? > >> > > >> >

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

gt; > > 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:/

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

rom the query too. See if that helps > Error is a 1064 syntax error. > > 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.

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

situation? > > All the best, > Lawrance. > > "Any intelligent fool can make things bigger and more complex... > It takes a touch of genius - and a lot of courage to move in the > opposite direction." - Albert Einstein > > > -- > 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] PDOException: could not find driver (postgres)

ooks like > $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 L

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

f but > it is ignoring the .htaccess file. > > I've even tried putting the php.ini with specific settings 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. > > &

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

UNION two SELECTs http://dev.mysql.com/doc/refman/5.0/en/union.html (SELECT col1, col2, col4 FROM table1 WHERE ... ORDER BY ...) UNION (SELECT col1, col2, col4 FROM table2 WHERE ... ORDER BY ...) > --Aaron > > > -- > 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] Help for a beginner

e but that does not seem to have helped. > I have tried enabling: only mysql, mysql AND mysqli, and only mysqli. None of > this seems to have done anything to change my situation. > > Again, I apologize for the lengthy message, I hope I have accurately > described my issue in the right amount of detail. > > Thank You! > Adam Sonzogni > > > > > > > -- > 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] Does PHP5 support querying an MS Access MDE file?

ember/RQuadling > >> > > > > > > > > You've got odbc, but probably not a driver for MS Access. > > You need both. > > I can't seem to find a unix driver for MSAccess. > > Converting to a different DB would help (mysql, sqlite). I had a

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

e second option will prevent older clients connecting, including the mysql extension (but not mysqli) if it is not using the mysqlnd 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

Re: [PHP-DB] scheduler

several scripts like this scheduled to do 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

is persistent, so while the resource IS saved, the connection to which it refers no longer exists. > > -- > 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] 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?

ain a FROM clause, so MySQL tells you there is no column called 'solarLandingDateTime' because you have no table. This same problem applies to each part of your unions. > > John Butler (Govinda) > govinda.webdnat...@gmail.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 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?

; So something really basic is missing in my understanding/code. > > Can you see what it is? > > > > -Govinda > > > > > > > > -- > > 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?

ndingDir, solarLandingDateTime > FROM ".$whichTable. > " ORDER BY solarLandingDateTime DESC > LIMIT $Maxrecs2Show") or die("query failed: " . mysql_error());> Oops, forgot to mention that with the alias you can change the ORDER BY clause to use t

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

mysql_query("SELECT DISTINCT DATE(solarLandingDateTime) AS solarLandingDate, solarLandingIP, solarLandingDir, solarLandingDateTime FROM ".$whichTable. " ORDER BY solarLandingDateTime DESC LIMIT $Maxrecs2Show") or die("query failed: " . mysql_error());> If you are al

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

if my 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 L

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

ute minimum you should be doing with any data you do not supply yourself > $query = mysql_query("INSERT INTO customers (`cust_first`,`cust_last`) > VALUES ('$firstName','$lastName')"); > > > > Ben Miller BTW ereg functions are deprecated in PHP 5.3, so now

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

e to start looking. You are mixing up several different methodologies in the example you show. More generally for MySQLi start here: http://uk.php.net/manual/en/book.mysqli.php It has links to the appropriate function references for the MySQL Improved interface. > > -- > PHP Datab

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

ano Boragina _ >// 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] Re: [PHP] A prepared statements question

> daniel.br...@parasane.net || danbr...@php.net > 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 (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

he last 'id' column generated, which you can then use to insert data into the secondary tables. > > I’m 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

Re: [PHP-DB] mysqli error

single time I loop through. Is there any way that I > can run these statements error-free without having to close the select > statement ($sth1) every single time I want to execute my update statement > ($sth2)? You do not initialise your statement object. I would guess this is a large part of the problem, although I'm not that familiar with prepared statements in MySQLi. See the documentation for mysqli::stmt_init[1] and the example for mysqli_stmt::prepare[2] in the php documentation. [1] http://docs.php.net/manual/en/mysqli.stmt-init.php [2] http://docs.php.net/manual/en/mysqli-stmt.prepare.php > Thanks, > Kevin -- 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

Kamil Walas Check the file containing the first link again. '%5c%22' is the characters '\"'. Seems you have escaped 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

these accordingly. You may need to add an extra 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

COUNT returns the number of rows. I think 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)

ou should be checking the mysql_query call for success and output the error if it fails. Something like: mysql_query($sql) or die('Insert failed: ' . mysql_error()); You'll now why it's failing then. Make sure you have error reporting enabled. > 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 D

Re: [PHP-DB] Select...

d to do a join between the two tables using the common column 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] 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 Datab

Re: [PHP-DB] Variables & Forms

which involves using the CR+LF+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 y

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

t; know why. Dynamically changing the fields, I'm 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] Inserting databasecontent within the same form

uld also process the City.name and City.vorwahl results for NULL 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] 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] Pages not fully loading

pt. Without seeing 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] Query syntax

If I understood you correctly (and I'm not sure I did), this should do it $query="SELECT * FROM table WHERE listing_type LIKE '%$listing_type%' AND listing_approved IN( '1' ,'2') ORDER BY name ASC"; -- Niel Archer -- PHP Database Mailing List (htt

Re: [PHP-DB] showing warnings

f there are > only 4 rows in the table. True, but if it was only ever going to have 4 entries 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] showing warnings

le. Assuming that 'Tune_Name' contains unique 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] __CYGWIN32__

kage to allow 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] Newbie alert: supplied argument is not a valid MySQL result resource

Hi On my way to bed so too tired too look closely, but at a guess I'd say it's a logic error. I would guess this: >$sid = mysql_fetch_array($query) || die ('Could not fetch from database: > ' . mysql_error()); // <--- line 49 isn't evaluating in the order you expect.. You're using a lo

Re: [PHP-DB] Re: record pointer

Hi > mysql> select id,cat from table where cat=(select cat from table where id=51); > +-+--+ > | id | cat | > +-+--+ > | 40 | FLK | > | 41 | FLK | > | 42 | FLK | > | 44 | FLK | > | 45 | FLK | > | 46 | FLK | > | 47 | FLK | > |

Re: [PHP-DB] Re: record pointer

Hi > O.K. the id column is primary key and it is auto_incerment .I think my > explanation was not clear enough : > > this is my query : SELECT * FROM table WHERE ID=$ID > this will find the record with the specified ID and I will be able to see > it, now I want to be able to scroll up and

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

Hi Seeing as no-one else has replied to this, I'll make a comment. First off let me state I don't use PDO so I am not familiar with it. It would appear to me that your "problem" line is NOT the problem. It is only where the error is reported from. That line is a call to an object method, so the

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 > Du you know a good tutorial for XML and RSS, possible relating with PHP. Not a tutorial, no. I got my information from the specification documents. You should consider changing your method. Instead of creating the RSS/XMl file manually, try using one of the PHP extensions that will genera

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

Hi > firefox tells me that it dislike the closing xml-tag. > In my quanta-editor it seems that can be difficulties with the tagend of > the opening xml-line of the second position of the questionmark. Because you missed the space in front of it. You really need to find out more about XML and RS

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

Hi > ok by beginning the php-code with Unfortunately my RSSowl tell me that there must be other errors in the > xml-formating. And I don't got a detailed information what RSSowl > dislike in the xml-file. Try opening it in a browser. Opera, for example, tells you what error it encounters. That'

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

Hi the first line is badly formed Should be: Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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 Mail

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

Hi > Imagine that you want to put some 2 historical photos On display in > your website , you use PHP and MySQL. > Preparing a photo album with 200 photos is no problem but for 2 photos! > would you do it in the same way? Yes, but I don't necessarily see the need for a db. If y

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

Hi, > > In the function to connect to and select the database, I make the mysql-link > resource a global value. It sounds like you've misunderstood 'global' variable. The global statement needs to go inside the function where you want to use the variable, not where you assign it. This tells th

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

Hi, see the docs for the date() function. 'I' returns 0 or 1 indicating Daylight Saving Time. However, it does this based on the settings for your installation. i.e. if your webserver is running on a host configured to U.S. time zone, it'll give U.S. DST results. Note that, any method will

Re: [PHP-DB] Inheritance question

Hi > For example (see below), lets say I would like to use "public $one" > property in a new class / method (such as class b)? What is the > best way to accomplish this? Any help and or suggestions are welcome. > > class a { > public $one; > > public function someMethod() { >

Re: [PHP-DB] Re: do not display dublicated entries

Hi > I have tried everything except of the one that forms the date in one field > and use the DISTINCT for ip and date. It works for me. I use it for essentially the same job, listing most recent visit to a location (not IP, but physical venue). Have you tried adapting it to your needs, such as

Re: [PHP-DB] do not display dublicated entries

Hi First, unless there is a compelling reason not to, I'd suggest you use a single date field, instead of separate year, month, day columns. It will be much more efficient on space and indexes. Then, based on your own query, use: SELECT DISTINCT ip, date FROM tracker WHERE page = 'index' ORDE

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

Hi I've only had MySQL 4.1 running on 64 bit windows and PHP 5.x, without any real problems when used locally. However, there seemed to be a problem using the MySQL server via TCP/IP, hence the upgrade to native 64 bit version (v5.0), which was not desired at the time but seemed to be the only fi

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

Hi sorry, I misunderstood your problem, it was not too clear to me as the code you list shouldn't produce the output you supplied. try this: $array = explode(',', $csv); print "= " . $array[0] . "\n"; print "= " . $array[1] . "\n"; for ($i = 2; $i < count($array); ++$i) { $txt.= "=" . $array[

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

hi > the problem i have is.. how about the csv is a var > DATA=== > $csv=" > A507257,3/2/2007,\"Hematologi Lengkap,Cholesterol Total,LDL > Cholesterol,Trigliserida,HDL Cholesterol,Asam Urat,Gula Darah Puasa,Gula > Darah 2 Jam PP,Kreatinin,Ureum,Bilirubin Total,A

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://www.

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

Hi all Finally identified the problem. Was pretty obvious in retrospect. The mysqli class (Improved MySQL extension OO style) defaults to latin1 as a character set, regardless of what PHP is using. Simple solution is to use the set_charset method (mysqli_set_charset for non OO) on the object

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

Hi > Thanks for this. That page didn't actually help, but one of the follow > ups did. Apparently, despite being setup as UTF-8 throughout the Db, > tables, and columns. The returned data still can default to Latin1. > I've forced my test server to return UTF-8 (I hope) and am trying it > ou

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

Hi Chris. Thanks for this. That page didn't actually help, but one of the follow ups did. Apparently, despite being setup as UTF-8 throughout the Db, tables, and columns. The returned data still can default to Latin1. I've forced my test server to return UTF-8 (I hope) and am trying it out t

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

Hi > I read ur reply on newsreader abou mysqli and if i can use it in PHP4 > > My question is where can i find a link to download the mysqli extension > separately without changing to PHP5 The MySQLi extension is available before PHP v5, but I couldn't tell exactly which version it was introdu

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] Am I missing something?

Hi you need to change this: > $insert = 'INSERT INTO domains ( picture, thumbnail ) values( "$picture", > "$thumbnail")'; to be: $insert = "INSERT INTO domains ( picture, thumbnail ) values( '$picture', '$thumbnail')"; variables are only interpreted inside double quoted strings. Within single

[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/) To un

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] mysql rereading result set (fetch_assoc)

Hi > Hi, I would ask which way is more efficient and save time? Save each row to > array or mysql_data_seek(0) ? That totally depends on which resources are more valuable to you. The array will likely use more memory but be faster to process. While mysql_data_seek(0) would probably use n

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

Hi > leaving me with the question: what does > max_execution_time relate to? is it more like a maximum time without > activity. max_execution_time is the time php gets to execute code. From the documentation: "The maximum execution time is not affected by system calls, stream operations etc. P

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] Error for registration mail.

Hi You have two functions between the if and else, the syntax you've used only allows one. Use braces. if(mysql_query($sql)) { mail ($email, "Thank you for registering!", $body, "From: [EMAIL PROTECTED]"); header("Location: thankYou.php"); } else { die("Error! Could not insert values".m

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

Hi > I'm running thru a result set using fetch_assoc. Now I want to run through > it again. > > How? Save each row into an array first time around, then reset the array pointer to the beginning, would be one way. Or assuming you're using the original MySQL functions, use mysql_data_seek(0

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

Hi, there's no 'logic' error at all that I can see. It's more a design error as it doesn't do the job the way that you describe it at all. What actually happens is that the starting HTML (heading and table start) is output before the database is even contacted, so there's no way for you to ta

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

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

  1   2   >