Re: [PHP-DB] Why the sudden dis-interest?

2012-09-23 Thread Govinda
to be the lone odd public case, AND not have to figure how to do it myself. Just a guess. -Govinda -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] convert special characters.

2012-08-09 Thread Govinda
webserver you are using) is set to serve that charset. -Govinda -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] convert special characters.

2012-08-09 Thread Govinda
notice there are also these if you end up needing them: iconv_set_encoding() iconv() http://us.php.net/manual/en/function.iconv-set-encoding.php http://us.php.net/manual/en/function.iconv.php -Govinda -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] convert special characters.

2012-08-09 Thread Govinda
/table/connection are all of a charset that can handle the characters you are asking it to save into the db. I have a UTF-8 db that saves content in dozens of languages... and it works fine.. and none of the data has been messed with at all from what the language-specific user input. -Govinda

Re: [PHP-DB] Session and Access Privilages.

2012-03-29 Thread Govinda
redirect to your login page, or whatever you want to do to the intruders. HTH -Govinda -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Multiple Access to Database - The Answer

2012-02-05 Thread Govinda
. And anyway if the referenced place in the manual already spells it out.. then why should someone re-type all that (or copy and paste all that)??! -Govinda -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] COUNT() returns 0 if there were no matching rows. .... really?!

2009-08-06 Thread Govinda
thanks, -Govinda -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: COUNT() returns 0 if there were no matching rows. .... really?!

2009-08-06 Thread Govinda
none exists?? (You still have my OP on this?.. to see the code and var_dump for that array I build from the iterating results of the original query?) John Butler (Govinda) govinda.webdnat...@gmail.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit

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

2009-08-05 Thread Govinda
Just one other tiny point of style here: having given the expression date(solarAWDateTime) the alias uniqueDate, you should probably use that alias to refer to the same thing elsewhere in your query, such as in the GROUP BY column. So: ... That's how I'd write it, anyway. I like to know

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

2009-08-05 Thread Govinda
the UNION ALLs? -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?

2009-08-04 Thread Govinda
Butler (Govinda) govinda.webdnat...@gmail.com -- 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?

2009-08-04 Thread Govinda
books once I get them here. Meanwhile thanks to all who make time to help! -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?

2009-08-04 Thread Govinda
returned. In relation to that definition, I don't know what I am looking at in the results I got above. Can you 'splain me? John Butler (Govinda) govinda.webdnat...@gmail.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

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

2009-08-04 Thread Govinda
Chris, and all. John Butler (Govinda) govinda.webdnat...@gmail.com -- 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?

2009-08-03 Thread Govinda
before asking for more detailed help; I am just now asking if you think I am on the right track with my thinking - as I just mentioned in the sentence above this one? Thanks everyone! -Govinda -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

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

2009-08-03 Thread Govinda
.. so my thought is to want to do nested query(ies), where: *within* the while loop of the first recordset (which is now successfully returning just rows with unique dates), I do other query(ies) which will (in their own code block) find all rows of the date we are iterating.. so I can, for

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

2009-08-02 Thread Govinda
:06 2009-07-27 17:35:52 2009-07-27 17:24:21 2009-07-27 17:23:03 ..then my while { loop would only fire 3 times. I do my RTFM; can someone just give me a good point in the right direction. Thanks! John Butler/(Govinda) govinda.webdnat...@gmail.com -- PHP Database Mailing List (http

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

2009-08-02 Thread Govinda
: .mysql_error()); -Govinda

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

2009-08-02 Thread Govinda
BY solarLandingDateTime DESC LIMIT $Maxrecs2Show) or die(query failed: .mysql_error()); -Govinda try foundTrackingRows=mysql_query(SELECT DISTINCT DATE_FORMAT('%Y-%m,%d',solarLandingDateTime) solarLandingIP, solarLandingDir, solarLandingDateTime FROM . $whichTable. ORDER BY solarLandingDateTime

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

2009-08-02 Thread Govinda
What does the resultset look like? I am getting every record in the table back

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

2009-08-02 Thread Govinda
in the 'solarLandingDir' column (TINYTEXT): diysolar solar_hm (null) but I still get all the records back, with each distinct 'solarLandingDir' column value represented several times. So something really basic is missing in my understanding/code. Can you see what it is? -Govinda -- PHP Database

Re: [PHP-DB] html input element rendering html entities

2009-07-16 Thread Govinda
to use the mysql_real_escape_string to no avail. Anyone have experience with this kind of thing? PHP Version 5.1.6*MySQL 5.0.19* Govinda govinda.webdnat...@gmail.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] html input element rendering html entities

2009-07-16 Thread Govinda
the code stripping out tags and I tried to use the mysql_real_escape_string to no avail. Anyone have experience with this kind of thing? PHP Version 5.1.6*MySQL 5.0.19* Govinda govinda.webdnat...@gmail.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] html input element rendering html entities

2009-07-16 Thread Govinda
I've got a form that loads and saves product data to mysql. In some fields like the heading and subhead we use special characters like Omega, Registered Trademark, and Ampersand. When putting the data in I will encode them as Omega;, etc. Once saved, all is good, everything goes ok and will

[PHP-DB] general theory behind 'primary_key' 'auto_increment' flags, and ON DUPLICATE KEY UPDATE ?

2009-07-15 Thread Govinda
! -Govinda -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] general theory behind 'primary_key' 'auto_increment' flags, and ON DUPLICATE KEY UPDATE ?

2009-07-15 Thread Govinda
out the mysql/php code that will allow me to either create *or* edit a record, in one fell swoop. Thanks for any insight! -Govinda -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php If that is the goal use the REPLACE INTO sql syntax You

[PHP-DB] trying to dump out table info

2009-07-13 Thread Govinda
: -mysql_fetch_assoc -mysql_query -SHOW TABLES but do not see why this should be failing. Why isn't $result a ' valid MySQL result resource'? -G Govinda govinda.webdnat...@gmail.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

Re: [PHP-DB] trying to dump out table info

2009-07-13 Thread Govinda
On Jul 13, 2009, at 2:58 PM, Daniel Brown wrote: On Mon, Jul 13, 2009 at 16:53, Govindagovinda.webdnat...@gmail.com wrote: Hi all I am not sure why this is failing/giving error. I am quite new at PHP/Mysql, and apologize for what will undoubtedly end up being a trivial error on my part.

Re: [PHP-DB] trying to dump out table info

2009-07-13 Thread Govinda
On Jul 13, 2009, at 4:40 PM, Daniel Brown wrote: On Mon, Jul 13, 2009 at 17:24, Govindagovinda.webdnat...@gmail.com wrote: No database selected You're getting warmer How would you select a MySQL database in PHP? (Hint: there's a built-in function.) To try and follow your

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

2009-07-13 Thread Govinda
this: $q=mysqli_query($db_billing,'INSERT INTO billing (clientFname, clientLname) VALUES (?,?)', array($defaultsFormVars[clientFname], $defaultsFormVars[clientLname])); is giving Warning: mysqli::query() expects parameter 2 to be long, array given in

Re: [PHP-DB] trying to dump out table info

2009-07-13 Thread Govinda
On Jul 13, 2009, at 5:42 PM, Daniel Brown wrote: On Mon, Jul 13, 2009 at 19:28, Govindagovinda.webdnat...@gmail.com wrote: $db_billing=mysql_connect(localhost,metheuser,mypass,billing); if (!$db_billing) { die('Could not connect: ' . mysql_error()); }

[PHP-DB] Extensions on SuSE

2001-08-22 Thread Ridai Govinda Pombo
Does anyone know how to get the _binary_ extensions for PHP installed with SuSE 7.2 ? I think it needs to recompile... But I wanted a easier way to solve it... Thanks, Ridai Govinda -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional