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
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
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
/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
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
. 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
thanks,
-Govinda
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
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
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
the UNION ALLs?
-Govinda
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Butler (Govinda)
govinda.webdnat...@gmail.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
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
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
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
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
.. 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
: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
:
.mysql_error());
-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
What does the resultset look like?
I am getting every record in the table back
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
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
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
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
!
-Govinda
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
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
:
-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
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.
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
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
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()); }
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
32 matches
Mail list logo