Ho there...I really wonder what's wrong with this script. The error is in
this line below:
if((count($info) != 1) ($folder == $info[2])) echo tabletrtda
href= . $info[1] . . $info[0] . /abr/td/tr/table;
The condition ($folder == $info[2]) is not working!
I hope you can help me!
Here's the code:
Hi,
the most probable reason is that the file you're reading from was saved in a
different filesystem and the $info[2] has some newline characters at the
end.
You can use the trim() function to remove it. Than your expression will look
something like this
if(count($info) != 1 $folder ==
Hello all,
I'm working with 2 different systems ( php/mysql in Winnt and php/mysql
in linux machine), and I would like from WinNt machine consult
information in linux machine !!!
When I make connection i got no problem(since in linux machine had
created an user to acess a database like username@%
Miguel:
1). Are you trying to connect an MS Access database to a MySQL database?
2). Are the databases and servers both/individually remote or local?
See if: http://gertrude.anglia.ac.uk/webteam/tips/php_sql/odbc.htm helps you any.
Good luck.
Russ
On Tue, 20 Nov 2001 12:35:29 + Miguel
To: [EMAIL PROTECTED]
From: ()
Subject: Fw: Your Info Has Arrived
Below is the result of your feedback form. It was submitted by
() on Tuesday, November 20, 2001 at 08:20:21
---
message:
Real Networker Leads, Real
1. He's not trying to connect MS Access to mySQL. He's trying TO ACCESS a
mySQL database on a Win-NT machine.
2. Both mySQL servers are remote.
-Original Message-
From: Russ Michell [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 20, 2001 6:39 AM
To: Miguel Loureiro
Cc: [EMAIL
In which case you're best off helping him as I have no idea!
Russ
On Tue, 20 Nov 2001 08:10:02 -0600 Rick Emery [EMAIL PROTECTED] wrote:
1. He's not trying to connect MS Access to mySQL. He's trying TO ACCESS a
mySQL database on a Win-NT machine.
2. Both mySQL servers are remote.
Right then:
* You have 2 remote MySQL DB's on different O/S's
* You want one to 'talk' to the other one?
errr (whirrr grind..etc)
I'm sorry if you've already stated this in your first email, but could you not just
query both DB's
separatley using mysql_select_db() Using separate DB
Exactly what I just suggested - hey do we have telepathic abilities or what?? :-)
Russ
On Tue, 20 Nov 2001 08:21:24 -0600 Rick Emery [EMAIL PROTECTED] wrote:
Hey Russ,
I'm wondering. Maybe this might work. What do you think?:
$server1 = mysql_connect(server_1,user1,password1);
Hi there...I have a db filled with various HTML code examples, tags, etc...
how would I format it so that it would appear like A href='index.php'Link
One/a. I was using the strip_tags() function and quickly found out that
this wasn't the best way to do it :)
Cheers, Joe:)
--
PHP Database
* You could cheat and wrap anchor tags around the DB content you want to display as a
hyperlink
* If you know which variable from the DB you wish to be displayed as a link then:
$variable = a href=\yourpage.php\$variable/a;
HTH :-)
Russ
On Tue, 20 Nov 2001 11:54:25 -0400 Joe Van Meer [EMAIL
Try htmlentities() or htmlspecialchars(), which is what I use.
At 07:54 AM 11/20/2001, Joe Van Meer wrote:
Hi there...I have a db filled with various HTML code examples, tags, etc...
how would I format it so that it would appear like A href='index.php'Link
One/a. I was using the strip_tags()
Am Mon, 19 Nov 2001 schrieb John Lim:
Are you using ODBC? We recently had similar problems, and it turned out that
we
had SQL tracing enabled, and every single ODBC function call was being
written
to SQL.LOG
And added, such a traced logfile can grow up to some megabyte of data.
I know
Thx guys for your suggestions. My question probably wasn't worded as good as
it could be. Here's the situation,
I have a small php app that I'm building to display, insert, edit, etc...
various types of code snipits (asp, php, html, etc...) in a db. I also have
a download option that creates a
Ruprecht,
SQLServer from Linux is pretty straightfoward.
If you want full SQLServer2000 support, you will want to use ODBC.
There is a HOWTO at www.iodbc.org for linking PHP --with-iodbc.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Tomas V.V.Cox [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]...
On Tuesday 20 November 2001 07:41, Manuel Lemos wrote:
Hi Manuel,
I don't have the time or motivation to develop things for PEAR just
because it is funny to cooperate. I am no longer a college student so
I don't
please review my script
I have already had it said that the script is fine, please check. IF
it is then I have a set up proiblem which I would also like help to
solve. BUT mysql outside of apache works fine.
I started with an already set up apache so I don't know if mysql was
installed in
Is it possible to migrate data into a table in MS Excel to MySQL?
Thanks in advance.
Daniel Berwig
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail:
Is it possible to migrate data into a table in MS Excel to MySQL?
Export to csv from excel and the mysqlimport command is your friend
Regards
Jon
--
Jon Farmer
Systems Programmer, Entanet www.enta.net
Tel 01952 428969 Mob 07763 620378
PGP Key available, send email with subject: Send PGP Key
I am sure there are several ways of doing this.
What I do, is just save the excel file as a tab-separated txt file...
Then in mysql you call the LOAD DATA local infile /tmp/test.txt into
tabel tablename (columnname1, columnname2) ;
I have made a little upload script for this..
If you want it I
I think you can get this error when you sql query fails.
Try copy and pasting the $sql query to the mysql command line and see what
response you get (it looks as though this would work though unless you
haven't got a table called test).
I guess it might be that you are not successfully logging on
I agree with mr. Torrent here...
you are not logged on to your mysql server when you issue the query!
Check your password/username...
-Opprinnelig melding-
Fra: torrentUK [mailto:[EMAIL PROTECTED]]
Sendt: 20. november 2001 18:35
Til: [EMAIL PROTECTED]
Emne: [PHP-DB] Re: php/mysql
seems to be a permission problem... you have to
give GRANT rights in your database to your winnt IP address
Valter Santos
- Original Message -
From: Miguel Loureiro [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, November 20, 2001 12:35 PM
Subject: [PHP-DB] consult different
Okay, this is beginning to bug. I have an application that uses several
databases, and it restarts daily - anywhere from 1-8 times per day. This is
not supposed to happen at all unless we manually restart the server. But I'm
beginning to experience frequent problems with it just restarting out of
You have the wrong list.
http://www.mysql.com/documentation/lists.html
-Original Message-
From: Jonathan Hilgeman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 20, 2001 2:56 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL Restarting A LOT
Okay, this is beginning to bug. I
Nope - I've already tried there. Nobody answers the door. Now I'm trying
here because it's a PHP application, there may be a possibility of someone
else experiencing or that has experienced the problem and fixed it. Thanks
for the link, anyway. I'm already a subscriber. :)
- Jonathan
Hi
I came from ASP and I'm sort of a newbie. I'm sure you'll see
that after my question :-)
I'm looking for a way to insert data in an mysql db but not with an
insert into statement. Is there any way i can do some sort of:
mydb.myfieldname = $myvalue
??
(same as in asp with recordsets:
No, but SQL is your friend, and is actually easier than messing around with
recordsets, once you get the hang of it.
The exact form of your INSERT statement will depend a bit on the database
are you using, but the following is typical. This is MySQL syntax, I
believe PostgresSQL is similar.
Howdy--I have a question about persistent connections and their behavior:
Apache 1.3.2 / PHP 4.0.6 - as a module
Win2k
I call the following function:
odbc_pconnect(dsn, user, pass);
At the end of the script I do NOT call odbc_close($dbConn);
I was doing some testing and ran into a:
Maximum
Thanks, but I think you already sent me that link. Or maybe it was a
different Chris. Either way, I couldn't get any viable answers from there.
- Jonathan
-Original Message-
From: Boget, Chris [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 13, 2001 1:30 PM
To: 'Jonathan Hilgeman';
Greetings once again,
Today I hope to have a challenge for you. :)
I've created a query which returns 1 record. This is confirmed when testing
it in MySQL itself.
Now PHP sees that there is 1 record in the result, but is completely
unwilling to show the information.
The css responsible for that
What does adding the (int) do to this statement:
$poll_sum = (int)mysql_result($poll_result, 0, SUM);
I do not find anything about the SUM either.
Thanks
Dave
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL
Take out the while statement--
i.e. simply use:
$row = mysql_fetch_array($result);
the way you have things constructed now, the while statement evaluates true on the
first iteration and $row equals the result row from the query. Because the while
returned true, it is evaluated a second time,
the lack of proper close html code will cause a no show in Netscape, but will show in
Ie
|table
|tr
|td width=\50\/td
|td width=\125\CO:td
|tda href=\$email\$co/a/td
|/tr
|
(int)
forces (casts) result as integer--
see
http://www.php.net/manual/en/language.types.type-juggling.php#language.types.typecasting
SUM would be the field name
-ib
[EMAIL PROTECTED] wrote:
What does adding the (int) do to this statement:
$poll_sum = (int)mysql_result($poll_result, 0,
35 matches
Mail list logo