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) I check the table is exists,and the query should be correct.
*should* be correc
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 inserte
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
(
[1
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 image
Hi Jason Wong,
>> --
>> Warning: Invoke() failed: Exception occurred. Source: Microsoft JET
>> Database Engine Description: Syntax error in FROM clause.
>> -
>
> The error is q
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 ca
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 selec
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 "" . $id . ": " . $flu
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 yo
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 [ ] option
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] "LIM
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 q
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 s
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 PROTECTED]">news:
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 sp
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,
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 interfa
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]> wr
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 id,LE
$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
}
--
Sincerel
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 = NewADOConnection('mysql'
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 in
[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 be 2 nights as the 21st would be
> the checkout date.
I guess this will work:
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 ab
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 ad
Hi there everyone,
OK here is a final date question. It's complex (Atleast to me :-( but i'm totally
stumped. Here's what I need to do. Say September is Summer and October is winter,
now getting the dates for each month is easy.
Now, say in September each day is worth $50 but in October each
[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 th
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 pr
[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
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.
:)
Lu
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 wr
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 = NewADOCon
41 matches
Mail list logo