Hi Jule !!!
This can be a socket error.
Sometimes when installing PHP/Mysql as binary dist PHP
does not know where mysql socket is.
The default is (AFAIK) /tmp/mysql.sock
Make a test:
Try to connect with mysql console with exactly
the same info as You use in Your PHP script.
shell# mysql
Wait a second
Is this a typo or what...
$link_glob = mysql_connect('$host_glob', '$un_glob', '$pw_glob');
The qoutes around mysql_connect statement makes
it to a string, nothing else but a STRING !!
So it will never get executed !!
And '$link_glob' is either a link recource its just
Hi !!
uhh, this sounds really stupid to be honest :-)
My first thought is, If they are so deep in MS junk
why should they port to PHP/MySQL in the first place ??
I think it's definitely easier to give then a quick-course
in PHP than writing these kind of workarounds...
You could maybe write
Hi !!
You could maybe buffer the data in Your application
and then run inserts later... like this.
struct oneRow{
double timestamp;
double data;
etc, etc
}
struct oneRow rows[num_of_rows];
for (int i = 1; i num_of_rows; i++)
{
// collect data
rows[i].timestamp = (double) i;
Hi Jakob !!
If I install MySQL on the same server as Apache Php and only use
MySQL in Php, do I then have to install the MySQL client?
Technically, you don't need it. But when I am debugging PHP,
I often turn to
mysql client just for a sanity check on a query. If your
Hi Bruno !!
Nope, the query OK is NOT skipped but the query has not
been executed at all !!
And this is not a bug !!!
The backslash in Your query escapes the following single quote
and the query will not be terminated by ; .
You should propably escape the backslash instead like this
mysql
Hi !
You said anything about connecting to mysql.
You need to go through 2 steps before mysql_query().
These are
mysql_connect()
mysql_select_db()
please check the URL below, everything is explained very clearly.
http://www.php.net/manual/en/function.mysql-query.php
You could also tell us
Well... This seems to be a typical tricky-goute-on-qoute thing...
I recommend you to test your query in mysql client directly
(if you havn't already done that).
And THEN take the battle with perls quoting mechanism...
Another tip is to just print the query before executing
so You can see
If You're using VC++ so I recommend You to test run
Your app within VC++ IDE.
Then You can step through your code , line by line and
check for variables if they are what You think they are.
A very easy and effective way to find errors !!
---
=d0Mi= ,
It would be nice to know what You're actually trying to do...
How do You want the get Your query back.. eh... parsed... ???
Or do You simply want to errocheck Your queries... ??
In this case You could run an EXPLAIN your query Query.
And then check for errors if any...
=d0Mi=
DCS.net
I have a Where clause like:
select count(*) from table where LIMIT 100
Unfortunately the Count(*) ignores the LIMIT clause entirely. Why?
Because the query returns only ONE row and LIMIT limits rows, not values.
See ex. below:
SELECT count(login) FROM accounts WHERE
Hi Again... !!
It is used to set up the navigator bar buttons for the grid on the web
page
(PHP) so it says Page 1 of 18 with buttons on either
side
of it.
I'm a bit confused now...
You are building a pager to a webpage, right ??
But, if You select with LIMIT 100 then I assume
Hi !
I've made a quite simple program in C using
libmysqlclient. The program runs as daemon
in Solaris 8 (sparc) and checks some values
in the database every 5 minutes.
I have only ONE malloc/realloc call in my code
and this code is called only when needed (when DB check
is signaling it to do
in libmysqlclient.
dOMi writes:
However, after only a week the memory usage ocf this process
has been grown to 40 - 50 MB so there's have to leakage somewhere.
What you *may* be seeing is standard memory fragmentation that many
Unix' systems have with the standard allocator.. You don't mention
what
Hi all !!
This is just great ! Sometimes things seem to be
more complicated than they actually are.
I needed (and still do) a similar solution to check
if an IP adress exist in a table. And sometimes the
argument in the query is a whole subnet like 192.168.0.%
I guess this will do the job for
15 matches
Mail list logo