Doesn't seem to work, how would I print that out with PHP?
On Monday 19 March 2001 13:52, you wrote:
how about something like
select distinct
name,
date_format(time, "%W %D %M %Y") as login
from
users, user_logins
where
user_logins.user_id = users.id
order by
Can anyone give me any pointers on how I can execute queries in MS Access97
from PHP and get the results back using either ADO or ODBC?
Thanks in advance
Darren
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail:
Hi
Newbie here
I am running Apache/PHP/MySQL locally which emulates my server environment
online. I want to use it as a test environment.
I am running through Julie Meloni's 'PHP Fast Easy...' and have run up
against a problem.
Using the mysql_connect statement in a php page:
?
I get the following error returned in any browser:
Warning: MySQL Connection Failed: Can't connect to MySQL server on
'localhost' (10061) in c:\program files\apache
group\apache\htdocs\threezero\phptests\dbstuff\db_connect.php on line 2
could not connect
could be that mysqld isn't
Is there a way to jump out of one script and into another like with
cflocation() in CF. Does php have a similar function?
Miles Scruggs
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact
-Original Message-
From: Miles Scruggs [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 19, 2001 11:17 AM
To: PHP Mailing
Subject: FW: [PHP-DB] php/linux/mssql
Well from what I can tell php treats sybase and mssql the same. Am I
wrong on this, or how do I fix this?
That's
So I don't get an error until I try to select a db. I run tcpdump
at the same time just to make sure that it wasn't trying to
connect
to the remote server and there was no attempt to even make a
connection.
Have you tried running a 'make check' in your FreeTDS directory to run
the
http://mysql.com/documentation/mysql/bychapter/manual_Privilege_system.html#
Adding_users
Check out the docs here.
You need to add users this way:
shell mysql --user=root mysql
mysql GRANT ALL PRIVILEGES ON *.* TO monty@localhost
IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql
Newbie here.
How do I get line breaks in output from a database?
I have a list of things in a file, like: item1``item2``item3 (etc)
I want them displyed in a textarea as:
item1
item2
item3
Probably very simple, haven't got that far in my book yet.
Martin S.
--
PHP Database Mailing List
Hi,
I'm testing out the concept of offering free MySQL database hosting.
Feel free to create a database at
http://superid.dyndns.org:8080/freesql/index.php
There's no catch, or hidden agenda. I thought it might be fun to try
and offer this as a service to people who might be learning
check where you are getting "$mysql_link" that is the problem I usually associate with
the error you report.
if $mysql_link is undefined, MySQL can't perform the query.
Terry
On Tuesday, March 20, 2001, at 12:06 AM, Toke Herkild wrote:
$mysql_result = mysql_query($query,
Hello,
I use IB 6.01 with PHP 4.04 on Linux or/and Win
When I try to to change the character set of a connection I get an error
message:
php-code:
...
ibase_connect($Hostname,$Username,$Password,'DOS850');
...
error-message:
"Warning: InterBase: arithmetic exception, numeric overflow, or
Well you don't need PHP to do it, but you can replace the greater than and
less than signs with their html entities(lt; and gt;) which the browser
will parse, and it will display the appropriate chars. So...
?php
print "lt;font size=+2gt";
?
will print the html without parsing it.
Now if only
try:
?php
echo htmlentities("A HREF=home.phpHome/A");
?
""Osman Omar"" [EMAIL PROTECTED] wrote in message
00f901c0b0cf$c99e7da0$da604a2b@sony">news:00f901c0b0cf$c99e7da0$da604a2b@sony...
Hi,
Suppose I want to display HTML code eg "A HREF=home.phpHome/A"
How can I do that in php?
--
PHP
Better yet, use "br" for browsers.
Or use Jeff's method but use nl2br function to convert new line to br
echo nl2br($result);
""JJeffman"" [EMAIL PROTECTED] wrote in message
007f01c0b0d8$212e97a0$5bd4d7c8@jjeffman">news:007f01c0b0d8$212e97a0$5bd4d7c8@jjeffman...
Create a variable to
somebody please help!!! I've posted a number of messages about this with no
reply. Here are the findings from my research:
on windows 2000 under iis 5.0 this is breaking:
mail($to, '', '', substr($coverletter, 0, 3990));
while this works:
mail($to, $subject, '', substr($coverletter, 0,
I believe mail works completely different on unix. It probably doesn't
suffer the same problems, because it's a direct call to an external process.
Lookup "sendmail"
""Free Beachler"" [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Someone else has tested this
I am trying to get postgresql (pg) support for php working on my RH7 box. I
had a working binary installation of postgres 7.03. I thought I had read
that php4 had default support for pg, but my call to pg_connect() gave me a
"Call to undefined function" error.
So, next I tried to re
What kind of binary install did you do? An rpm? If so, simply also
install the rpm-devel package and it will compile nicely.
-Rasmus
On Tue, 20 Mar 2001, Gary Huntress wrote:
I am trying to get postgresql (pg) support for php working on my RH7 box. I
had a working binary installation of
The php below illustrates how to print database results from
mySQL in PHP. Apologies for the long post.
You should be able to extrapolate from here - ie this is
generic, you will want to keep track of the usernames and
only print them when they change. Dont forget to print the
last one if you do
Sorry, the query works fine, but how do I print it out to the browser so that
it looks like:
John
Dates go here
Bob
Dates go here
Gill
Dates go here
I hope that's clear,
Thanks,
Jord
On Monday 19 March 2001 14:44, you wrote:
works fine for me.
what error do you get.
-Original
On Mon, Mar 19, 2001 at 01:19:44PM +1030, Andrew Halliday wrote:
Can PHP for Oracle randomly access rows in a result set?
I have read documentation for both Oracle functions (ora_*) and Oracle 8
functions (OCI_*) but cant seem to find a way to randomly access rows in a
result set like you
Hi,
I've got a table like:
id user_id ip time
1 2 127.0.0.1 20010316105018
Etc, etc.
I do a join on the this table and the users table to get the coresponding
username to user_id like this:
SELECT users.name AS name, user_logins.ip AS ip,
how about something like
select distinct
name,
date_format(time, "%W %D %M %Y") as login
from
users, user_logins
where
user_logins.user_id = users.id
order by name,time
-Original Message-
From: Jordan Elver [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 19,
Doesn't seem to work, how would I print that out with PHP?
The results will come back sorted by name, then time. While processing each
row, you'll need to keep track of when the username changes, something like
this (this is just rough code, not quite valid PHP):
$username = '';
while
The OCIFetchStatement() function returns a resultset to PHP that is actually
a multi-dimensional array. You can randomly access this array however you
like.
-Original Message-
From: Thies C. Arntzen [mailto:[EMAIL PROTECTED]]
Sent: 19 March 2001 10:43
To: Andrew Halliday
Cc: [EMAIL
26 matches
Mail list logo