On Wednesday 19 February 2003 10:09, pei_world wrote:
when I try to connection to the access file using Microsoft Jet Engine. it
come up with following error!
$result = $conn-Execute($query) error line
I check the table is exists,and the query should be correct.
*should* be correct or
On Tuesday 18 February 2003 20:35, Bruce Sommer wrote:
I'm attempting to takke information submitted from a web page through a
POST action, insert it into a MySQL database and upon success display the
information in a table for the submitter to see. For some reason empty
fields are inserted
Hi everybody,
i want to store some articles and images to them in MySQL
db. could you just give advice if it is better to store the image in BLOB
or if to save on server and in db just have it's URL.
Hi Milan
--
PHP Database Mailing List (http://www.php.net/)
hello,
i've got the next array:
Array
(
[testsubnet] = Array
(
[2690910720] = 255.255.255.0
)
[GLN-subnetsirangevoorgedelegeerddomein] = Array
(
[2886735616] = 255.255.255.0
)
[testsubnet2] = Array
(
Milan,
The only disadvantage i've had of storing images in DB instead of
Filesystem, is that when you use a PHP script to output the image to a
client browser, MSIE doesn't always accept a suggested filename so it
might try and save it as your-script.php?img=2.
Other then that, keeping images
Hi Jason Wong,
--
Warning: Invoke() failed: Exception occurred. Source: Microsoft JET
Database Engine Description: Syntax error in FROM clause.
-
The error is quite
Rokasa wrote:
Hi there,
I want to produce the report using the PHP but I don't know the PHP command.
Or is it any third party software that can be called by PHP to produce the
report? Is it anybody out there can help me.
gotta do it the old fashion way, by writing it yourself...
or you
Rajesh Fowkar wrote:
Hello,
There seems to be very few date manupulation functions in php.
In my php form I am displaying select combos for day, month and year.
Now while updating the form I want to retrieve the date and take out day,
month and year from that date and display the correct
I'm having a problem when I use mysql_fetch_array and extract() following a
left select query. As an example...
$query = SELECT id,LEFT(fluff,80) FROM sometable;
$result = mysql_query($query) or die('message');
while ($row = mysql_fetch_array($result){
extract($row);
echo P . $id . : . $fluff .
Hi,
How do you install pear db to work with PHP. having a problem with certain
applications needing pear. How and where do I get the program and installation
instructions.
Thank you all
Neil
Start here - http://pear.php.net/packages.php. I'm only just looking at it
myself, but the docs are on there too.
Good luck
Nick
-Original Message-
From: Neil [mailto:[EMAIL PROTECTED]]
Sent: 19 February 2003 11:09
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Pear with PHP
Hi,
How do
Sorry, should have been more specific with my last reply;
Base PEAR package - http://pear.php.net/package-info.php?pacid=14
Additional packages - http://pear.php.net/packages.php
Sorry about that.
Nick
-Original Message-
From: Neil [mailto:[EMAIL PROTECTED]]
Sent: 19 February 2003
I need some assistance here...
I am toying with a search form that will allow the user to select 3
options from a set of checkboxes to search by (eg.)
[[ Select any 3 type ]]
[ ] option1 [ ] option2 [ ] option3
[ ] option4 [ ] option5 [ ] option6
[ ] option7 [ ] option8 [ ]
I'm trying to split results into different pages and number the pages
accordingly. I've been able to build a fairly intelligent page numbering
system which knows which rows it should pull (at least by numbering each row
numerically) but I don't know how to construct a SQL query to pull 10
results
$start = 10;
$numbers_to_show = 25;
$sql = SELECT * FROM bla Limit $start, $numbers_to_show;
or just go to mysql.com and use the manual :)
-Original Message-
From: Noam Giladi [mailto:[EMAIL PROTECTED]]
Sent: woensdag 19 februari 2003 16:00
To: [EMAIL PROTECTED]
Subject: [PHP-DB] LIMIT
The title suggests MSSQL, which if I am correct doesn't support Limit
like MySQL.
I'm working on the same thing right now so I don't have a quick and
dirty working example, although it doesn't look to be too difficult to
use server side cursors in MSSQL.
Here is a related a link to a similar
On Wed, Feb 19, 2003 at 11:07:28AM +0200, Corne' Cornelius wrote:
The only disadvantage i've had of storing images in DB instead of
Filesystem, is that when you use a PHP script to output the image to a
client browser, MSIE doesn't always accept a suggested filename so it
might try and save
i assume this problem was solved in the past
i didn't found a ready solution.
i try to use FATCH .
and i have another link with ths same problem..
http://forums.devshed.com/showthread.php?threadid=33114
tnx noam
John Krewson [EMAIL PROTECTED] wrote in message
[EMAIL
Assuming your sorting by id, just do:
SELECT TOP 50 * FROM TABLE WHERE id $lastid
And just have lastid posting to the page every time
they hit next, and in lastid, put the last id of the results
on that page.
On Wed, 2003-02-19 at 09:59, Noam Giladi wrote:
I'm trying to
i'm not using a fixed sort
tnx noam
Adam Voigt [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Assuming your sorting by id, just do:
SELECT TOP 50 * FROM TABLE WHERE id $lastid
And just have lastid posting to the page every time
they hit next, and
In article 002001c29d40$007a5480$0533010a@hercules, [EMAIL PROTECTED] (Alejandro
Michelin Salomon \) wrote:
In this moment i need odbc for access sapdb Databases.
In php the development, is plan to have a sapdb extension ?
Why would you need that? Most databases expose a standardized interface
Well if you do, (sort by id) this will work.
On Wed, 2003-02-19 at 11:14, Noam Giladi wrote:
i'm not using a fixed sort
tnx noam
Adam Voigt [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]
Assuming your sorting by id, just do:
a solution offered i received from raydan
Untested:
Untested:
declare @num int
set @num = 20
EXEC ('select top 10 from myTable
where ID not in (select top ' + @num + ' from myTable order by ID)
order by ID')
But beware the dangers of dynamic SQL.
Mark Snijders [EMAIL PROTECTED] wrote
Try SELECT id,LEFT(fluff,80) as fluffy FROM sometable
Then extract() will have a value for fluffy
--- Baumgartner Jeffrey [EMAIL PROTECTED] wrote:
I'm having a problem when I use mysql_fetch_array and extract()
following a
left select query. As an example...
$query = SELECT
$conn = new COM(ADODB.Connection);
$conn-Open(Provider=Microsoft.Jet.OLEDB.4.0; Data Source=$database);
$query = SELECT * FROM user;
$result = $conn-Execute($query) or die(fail to connection to the
database!);
if ($result-RecordCount()!=-1){
//do something
}
--
Sincerely your;
Neil wrote:
Hi,
How do you install pear db to work with PHP. having a problem with certain applications needing pear. How and where do I get the program and installation instructions.
Thank you all
Neil
If ur Os is UNIX like then PEAR is intsalled by default With version PHP
ver 4.3.X
--
Hi there everyone,
I have the following 2 dates (FOr example):
19-02-2003
21-02-2003
How can I easily find out how many nights there are between the 2 dates? For example,
the above would be 2 nights as the 21st would be the checkout date.
I have the use the format about as that is how the
Hi there,
Thanks for your help, it is VERY appreciated :-)
Regards
Chris
[EMAIL PROTECTED] (Chris Payne) writes:
I have the following 2 dates (FOr example):
19-02-2003
21-02-2003
How can I easily find out how many nights there are between the 2
dates? For example, the above would
http://www.php.net/array_multisort is your answer.
Mark Snijders [EMAIL PROTECTED] wrote:
hello,
i've got the next array:
Array
(
[testsubnet] = Array
(
[2690910720] = 255.255.255.0
)
[GLN-subnetsirangevoorgedelegeerddomein] = Array
(
Do NOT store images in a DB, the overhead kills performance. If it's a tiny app
with very little traffic, the fine. Otherwise, store images in the filesystem.
[EMAIL PROTECTED] wrote:
Hi everybody,
i want to store some articles and images to them in MySQL
db. could you just give
[EMAIL PROTECTED] (Chris Payne) writes:
pardon les francais :-)
Les Français - the (pl) french (people) ? ;-)
I don't know how else to explain it so sorry if I confused you.
I don't know if anybody else might get this, but I have absolutely no
idea what you mean. If I'm to say anything, I
Hi there :-)
Basically what I mean is I have an orderform for rooms. THey can select the
date they arrive and the date they leave, but if they leave on a different
month when the price is higher, the last day or however many will be a
higher price, what I need is to not only calculate the flat
[EMAIL PROTECTED] (Chris Payne) writes:
Basically what I mean is I have an orderform for rooms. THey can select the
date they arrive and the date they leave, but if they leave on a different
month when the price is higher, the last day or however many will be a
higher price, what I need is to
Does anyone know of a program that can autp-generate HTML interfaces and PHP
Code to add to/update/delete from different tables in a mysql/postgresql
database?
Something similar to some of the RAD tools on the market for Microsoft
products etc...
I'm trying to quicken my development cycle.
:)
On Thursday 20 February 2003 23:49, Luke Woollard wrote:
Does anyone know of a program that can autp-generate HTML interfaces and
PHP Code to add to/update/delete from different tables in a
mysql/postgresql database?
Something similar to some of the RAD tools on the market for Microsoft
thanks dude.
-Original Message-
From: Jason Wong [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 20 February 2003 5:04 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Auto Generation of HTML Forms + SQL Code to update
My/Postgre SQL Database
On Thursday 20 February 2003 23:49, Luke Woollard
I have written PHP which runs 100% on Linux Postgresql. I have been
successful installing PHP4 on windows as an ISAPI MODULE. My PHP code
runs ok on Windows NT4 ok except:
(a) Session functions produce errors
(b) I am unable to connect to MSSQL (using ODBC). The System ODBC Driver
tests ok.
Any
I found the following code on the internet. I'd like to know that what I
need to do, if I want to use the actually Access file with out the DSN,
how
to use the Microsoft Jet?
thx
-- code
include(adodb.inc.php);
$db =
38 matches
Mail list logo