Tho, when you think about it, most PHP developers COULD use a dating
service. :)
Seriously tho, this is a good idea. Thanks for the info Jay.
~ Chris
D.O.D
-Original Message-
From: Jay Blanchard [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 12, 2002 12:24 PM
To: [EMAIL PROTECTED]; [EMAI
There is an ODBC driver for MySQL that will allow you to link to it and you can do
whatever you want from there. :-)
<>< Ryan
-Original Message-
From: Alex Shi [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 12, 2002 4:36 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] convert mysql table to E
Can MySQL table be converted to Access or Excell format?
Alex
--
---
TrafficBuilder Network:
http://www.bestadv.net/index.cfm?ref=7029
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I'm amazed at how many seasoned developers think that doing a select with no order by
clause will always return the records in the order they went into the database. That
is an absolute no-no. The problem is, it usually will, but try restoring a backup or
bulk loading and see what happens. Even
MySQL has no obligations when it comes to sorting result sets. If you want it sorted
a certain way, it'd be in your best interest to declare it with ORDER BY item_id ASC,
if that's your flavor.
Martin Clifford
Homepage: http://www.completesource.net
Developer's Forums: http://www.completesourc
Blaine,
Are you adding/deleting records? Check that your MySQL tables are defined
as type MyISAM; if they are regular ISAM table the autoincrement numbers
are reused. That was a surprise!
That may not be the problem, but I see you don't have an "ORDER BY" clause
in your SQL. Add one, "ORDER BY
Check manual for stripslashes (and addslashes)
Here's the URL: http://www.php.net/manual/en/function.stripslashes.php
Miles
At 12:10 PM 7/12/2002 -0400, Blaine D. Dinsmore wrote:
>I was wondering if anyone knew a good method for handling data pulled from a
>MySQL database to the browser as well as
On Saturday 13 July 2002 00:34, Blaine D. Dinsmore wrote:
> I'm using MySQL and I have noticed that my primary key which are
> autoincrementing numbers do not sort properly when pulling the results to
> the browser. They are showing consecutively all the way until 150 then they
> start going backw
Would using sort($result); solve the problem? I believe the default sort
order is ascending. Try using sort($result) before your while($myrow =
mysql_fetch_array($result)) statement and see if that fixes things.
I also noticed that you don't use an ORDER BY clause in your sql statement,
but if th
I'm using MySQL and I have noticed that my primary key which are
autoincrementing numbers do not sort properly when pulling the results to
the browser. They are showing consecutively all the way until 150 then they
start going backwards for example:
157
156
155
154
159
160
161
162
163
When I do a
I was wondering if anyone knew a good method for handling data pulled from a
MySQL database to the browser as well as grabbing the same data using ODBC
in crystal reports. I would like the data to appear in the output for both
browser and crystal without slashes that are placed before quotes.
Tha
No, it's not a dating service :)
Want to meet other PHP developers in your area? Check out:
http://php.meetup.com/
Pretty nifty idea... especially given the lack of user groups in the U.S.
[/snip]
I thought for others who had not seen this I would post this. There is
probably already a user
Figured it out. The SQL Service account was a domain account and did not have
administrator privilege on the server it ran on. Strangely enough the procedure needs
some kind of special local permissions.
<>< Ryan
-Original Message-
From: Ryan Jameson (USA)
Sent: Friday, July 12, 2002
exec master.dbo.xp_sqlagent_proxy_account N'GET'
Anyone ever had the above give you "Access is denied." When you run it as 'sa' ???
<>< Ryan
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Well, it's not Java, PHP, or Mysql, but if you want a challenging
project then have a look at libmcal
http://sourceforge.net/projects/libmcal/
It's meant to provide calendar services and includes the beginnings of
an icap server - which is to a calendar what IMAP is to email. There is
also a PHP
Hi,
Please read the rest of this email if you're interested in helping final
year
Computer Science student (yes, that's me...) by giving him some ideas on his
final
year project very possible involving PHP and SQL...
I will start next autumn my third year of Computer Science studies. I have
to
Hi everyone .
I recently upgraded apache to 1.3.26 and I configured it with php 4.0.5
and now every page that I write get cached on the client. I have tried to
insert the code to prevent that in different formats in the section
of my page however no luck. I am thinking it is somthing to
Hello,
my unixODBC-2.2.2 installation works fine. I tested the configuration with a
local and a remote ressource to a Sybase Adaptive Server Anywhere database with
isql (a testing tool of unixODBC). Thus the settings in the odbc.ini and
odbcinst.ini should be correct. But when I'm using PHP-4.
Can someone please give me any kind of advice on what it is I need to do in
order to configure a Linux box to talk to a MSSQL 2000 box. I have found
various sets of directions, none of which resemble each other, and none of
which work.
I would greatly appreciate if any one could lend me a hand w
Hi,
I have problems with mssql_get_last_message(). This function doesen't
return the whole error message, it only returns "Die Anweisung wurde
beendet" and not the specific error message. Now I use something like
this to workaround the problem:
... snip ...
$this->errno = mssql_result(@$this-
20 matches
Mail list logo
