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?

gt; clause to use the aliased column data: > >> ORDER BY solarLandingDate DESC > >> this will only use 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

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] Store more than 1 piece of information in a single variable

h associative and numerical 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

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

cords Not if that's what has changed between versions. Check the change 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"

al 'UTF-8' (hyphen between letters and number) in case it's causing 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 -

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

hey are "not equal". As I said before. Many of PHP's functions (the string one's for comparing for example) are NOT multi-byte aware, so are NOT guaranteed to work correctly. You did not answer the most important question. What, if any, output buffering are you using?

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

aracter set. What, if any, output buffering are you using? What is your default_charset set to? -- 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/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] Newbie alert: supplied argument is not a valid MySQL result resource

d and write cookies $query = mysql_query("SELECT MAX(SID) FROM Sessions"); if ($query === false) die ('Could not query database: ' . 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] Newbie alert: supplied argument is not a valid MySQL result resource

#x27; . mysql_error()); If that's not the problem, I haven't got a clue until after sleep and coffee. Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: record pointer

| FLK | | 45 | FLK | | 46 | FLK | | 47 | FLK | | 48 | FLK | | 49 | FLK | | 50 | FLK | | 51 | FLK | +-+--+ Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: record pointer

able to scroll up and down 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, visi

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

or the method: $prep_users->execute(); as that is where the error is occurring, and possibly 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

ill 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] Problem with rss-feed generation

t XML and RSS specifications. This isn't a PHP or Db problem so doesn't belong on this list. 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

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

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

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

th LIMIT to pull out a page's 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

u assign it. This tells that function to access that variable from the global scope. You will need to have this variable available at the global scope. Creating it inside another function will not do, you must return that from the function to the global scope too e.g. Niel -- PHP Dat

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

any method 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.

Re: [PHP-DB] Inheritance question

$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 List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

, such as: $query = "SELECT DISTINCT ip, day, month, year FROM tracker WHERE page = 'index' ORDER BY `tracker`.`year` DESC , `tracker`.`month` DESC , `tracker`.`day` DESC LIMIT 0, 20"; Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

#x27;index' ORDER BY date DESC LIMIT 0,20 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

only 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 compu

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

i = 2; $i < count($array); ++$i) { $txt.= "=" . $array[$i] . "\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

iable into an array, then process it using foreach as before 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

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

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

but not PHP itself. I suspect the problem is with php itself or the mysqli extension, which was my original thought and reason for my post. Anyone have any ideas? 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

ing it out today. Fingers crossed! 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

ch version it was introduced 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

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

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

riables are only interpreted inside double quoted strings. Within single quotes, everything is taken exactly as it appears. 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/) To

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)

ly use 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] CURL and process not finishing

operations etc. 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

  1   2   >