But I would like to do it the other way round. I mean for the solution
you have mentioned, I have to make the query on the whole record, then
compare the two dates and filter the right ones. I'd like to make the
query look like:
SELECT something FROM table WHERE datetime < "$form_date"
So I thin
I'm just upgrading Linux Server to RH7.3 and installed
Oracle9i(9.2.0) Client+PHP4.2.1+Apache1.3.26
Everything goes smoothly. However, when I access the
Oracle server by means of PHP, it gives the following error:
Warning: OCIStmtExecute: ORA-00909: invalid number of arguments
The line that cau
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] says...
> I was using phpMyAdmin to do an export from one machine to another and on
> import I got an error:
>
> > Error
> >=20
> > SQL-query=A0:=A0=20
> >=20
> > CREATE TABLE hospital (
> > id smallint(5) unsigned NOT NULL auto_increment,
> > he
Ahhh - good correction Adam, I forgot about that method :)
So I suppose if you already have an array and wanted to pass it in a
link/URL then you could do something like
foreach($array as $value) {
$qstring .= 'array[]=' . $value . '&';
}
echo 'link';
then on link.php you'd have the ar
$login = mysql_query("SELECT * FROM Users WHERE Username ='$User_Name'");
> -Original Message-
> From: Shiloh Madsen [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 10, 2002 4:48 PM
> To: php-db
> Subject: [PHP-DB] Select string.
>
>
> Yet another thing i need some quick help with.
Yet another thing i need some quick help with. What is the proper way to
generate a select string in php. I know if youre trying to select a
value from a column you need to enclose it in double quotes if youre
doing it directly in sql. in this case the value in question is being
passed as a va
Kirk,
I do lab samples. Currently I have a winery management system. Each time
they move wine they have to sample it. Larger wineries will have about
35 processes going at any time. We print sample masters that are affixed
to sample bottles. Depending on how they set up the Sample Masters. they
hey gabor
you have to define a DNS on your system. i assume that you know what DNS is
and how to create on windows. if not, say it!
afterwards check, if the odbc has been activated in your php.ini on
windows-directory!
the rest is easy:
the code looks like that:
if( !$con=odbc_connect($dns,$us
Thanks, Adam. All clear now.
Rich
-Original Message-
From: Adam Alkins [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 10, 2002 4:28 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] PHP Security and Code Design
> I understand that this applies to data put into a form to be submitted to
How can i get the information if a field on a database (in my case
Access2000) is primary key via a php-odbc-function?
or does i have to use sql for that?
thanx j.a.z.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
> I understand that this applies to data put into a form to be submitted to
a
> database (or another page, I guess), but does it also apply to
> variable/value pairs passed along the URL from a hyperlink ( href="foo/bar.php?thisVar=thisVal>Click here.)? I couldn't quite get
it
> from the explanati
OK, so I was really bored today and started reading through some PHP
security stuff starting with the php.ini-recommended and found the register
globals off stuff. So you don't have to find it yourself, here's a direct
lift from the file:
; This is the recommended, PHP 4-style version of the php.
I would think the better way to set the entire system up is to have the barcodes
scanned directly into a database (your choice), then just have PHP read the database
and display editing, deleting, etc.
I don't see any reason why the barcode has to go through PHP at all to make this a
viable ap
My apologies for these posts, I'm just not sure where to start
I'm asking for info more from the standpoint of finding someone who is using
php & mysql to accept the info from a scanner rather than wanting info about
scanners.
Thanks!
Kirk
--
PHP Database Mailing List (http://www.php.
I'm a grad student with a university medical research lab, and they have
thousands of samples coming through. They want to integrate a web-based
tracking system using barcodes and scanners to trace the samples through the
different processing points in the lab. And they don't want to pay for a
c
Hi,
No you should not report it to anyone. Reserved words can be used as column
names in MySQL (although you shouldn't) provided that they are surrounded by
backticks. When you do it in phpMyAdmin, phpMYAdmin is putting everything
inside backticks , so that this problem won't be encountered.
See:
Hi guys,
I have a problem sorting values comming out of a db. It is not as easy.
Here is the prob:
One table containing user points.
Other table containing reports with rankings
For each top 10 report (the 10 reports with the most ranking) there are 20
extra points granted
Now I would like to g
Twas 7/10/02 12:55 PM, when "Martin Clifford" <[EMAIL PROTECTED]> said:
> DESC is a reserved word in SQL, standing for Descending Order. That is why
> you can't use it as a table column name.
Ok, that makes sence - thanks!
Although I find it a bit curious that building the DB in phpMyAdmin let
hello.
we are still having no luck figuring out how to do this.
we downloaded the code for the calendar off of www.php.net and everything
works great except we can't get the newly approved items to go from mysql
into the backend.csv
we would be very appreciative if someone could help us
On Thursday 11 July 2002 01:00, Ryan Jameson (USA) wrote:
> Sorry, [desc] won't work either. :-(
Try `desc`.
But it's best not to use 'desc' at all, it will save you confusion in the long
run.
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
oh I see! There have been '' values in some columns.
Thanx
Andy
"Ryan Jameson" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
do both of the fields contain values and are they both numeric? It sure
seems strange to me. I actually created a test and it w
Sorry, [desc] won't work either. :-(
-Original Message-
From: Chip Atkinson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 10, 2002 10:54 AM
To: Michael Zornek
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Mysql syntax error - phpMyAdmin ??
I can't say for sure, but perhaps "desc" i
DESC is a reserved word in SQL, standing for Descending Order. That is why you can't
use it as a table column name.
HTH
Martin
>>> Michael Zornek <[EMAIL PROTECTED]> 07/10/02 12:49PM >>>
I was using phpMyAdmin to do an export from one machine to another and on
import I got an error:
> Error
I can't say for sure, but perhaps "desc" is a reserved word, short for
describe. What happens if you say something like "description"?
Chip
On Wed, 10 Jul 2002, Michael Zornek wrote:
> I was using phpMyAdmin to do an export from one machine to another and on
> import I got an error:
>
> > Error
Try [desc]
-Original Message-
From: Ryan Jameson (USA)
Sent: Wednesday, July 10, 2002 10:51 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Mysql syntax error - phpMyAdmin ??
desc is a key word. :-\
-Original Message-
From: Michael Zornek [mailto:[EMAIL PROTECTED]]
Sent: Wednes
desc is a key word. :-\
-Original Message-
From: Michael Zornek [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 10, 2002 10:50 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Mysql syntax error - phpMyAdmin ??
I was using phpMyAdmin to do an export from one machine to another and on
import
I was using phpMyAdmin to do an export from one machine to another and on
import I got an error:
> Error
>
> SQL-query :
>
> CREATE TABLE hospital (
> id smallint(5) unsigned NOT NULL auto_increment,
> heath_system_id smallint(5) unsigned default NULL,
> name_long tinytext NOT NULL,
> name_sh
do both of the fields contain values and are they both numeric? It sure seems strange
to me. I actually created a test and it worked fine, just copied your query.
<>< Ryan
-Original Message-
From: andy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 10, 2002 10:48 AM
To: [EMAIL PROTECTE
there is no error, it just does not pull out the right values. Just puts out
10 listings and the top10 column (as I named it by alias) contains no value.
I am using mysql.
maybe this has to do somehting with the alias?
"Ryan Jameson" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
[EMAIL PROTECTED]"
i assume you're using MySQL because of the Limit clause, but what error are you
receiving?
-Original Message-
From: andy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 10, 2002 10:34 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Calculating inside query?
Hi there,
I would like to find
Hi there,
I would like to find out the top 10 of some ratings. There are 2 columns.
One for the rating and one for the amount of ratings.
To find out the top 10 I would have to divide those 2 values and sort it.
Somehow this does not work. I do not have a clue why. Maybe someone of you
guys do s
I have used jpGraphs with tons of success. These are functions or classes
that you can call in your php code...
http://www.aditus.nu/jpgraph/
--
RAY HUNTER
- Original Message -
From: <[EMAIL PROTECTED]>
To: "PHP_DB" <[EMAIL PROTECTED]>
Sent: Wednesday, July 10, 2002 9:41 AM
Subject:
Greetings,
I built php 4.2.1 and am having database access troubles. The problem
shows up with either the php module for apache/stronghold or the
command line/standalone version of php, so I've been using the stand alone
version.
I believe that my syntax and test program is correct, because a s
Is there any application available that can take data from my mysql
database and draw graphs?
I am using mysql/php on FreeBSD.
--
Chip
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
This is how I do it:
date("m/d/Y",strtotime(odbc_result($rs,"ts")))
where $rs is the result set and "ts" is the name of the field containing the datetime.
<>< Ryan
-Original Message-
From: Gabor Niederlaender [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 10, 2002 8:21 AM
To: [EMAIL
I'm wondering how the mysql_pconnect() function is SUPPOSED to behave.
I have a script that gets hit fairly heavily (about 150K times a day), that uses
mysql. In order to save some time in execution, I have made it use mysql_pconnect()
rather than mysql_connect(). Persistent connections are ena
Hi all!
I have got a "datetime" field in a MS-SQL DB, and I have a "date
field" in my html-form with the format: DD/MM/.
I would like to compare the two, but I think the two formats are a bit
different and they do not really want to be compared:)
If I write a query to write out the "datetim
You may also want to try: EMS MySQL Manager. I've been using both of them and I like
the EMS GUI better. It seems to work better and has more features.
César_Aracena wrote:Hi all. I found in one of these DB lists a word about a tool
called
MySQL - Front so I went there, downloaded it and ran i
Just a correction you can use arrays with querystrings
page.php?var1[]=first&var1[]=second&var1[]=third
$var1
Array
(
[0] => first
[1] => second
[2] => third
)
OR
page.php?var1[]=first&var2[2]=second&var2[]=third
$var 1
Array
(
[0] => first
)
$var2
Array
(
[2] =
Hi to all,
I changed Linux from version 7.2 to 7.3 and now when I try to load data
using LOAD DATA LOCAL INFILE I got the following error:
The used command is not allowed with this MySQL version. I
enable --local-infile=1 But I'm still getting the same error.
Any help, is greatly appreciate it
T
"César aracena" <[EMAIL PROTECTED]> wrote:
> Hi all. I found in one of these DB lists a word about a tool called
> MySQL - Front so I went there, downloaded it and ran it today for the
> first time and well...
> ¡¡TWO THUMBS UP!!!
> It really seems like a great GUI app. I installed it over
Hi,
try
SELECT @@ERROR as errorcode
bye,
Adam Alkins schrieb:
>>Hi all!
>>
>>This is not a typical DB-Question, but I hope you give me some hints
>>either...
>>
>>If I insert a String instead of a date(f.Ex) into the DB, I get a
>>Warning:
>>
>>MS SQL message: Syntax error converting datetime
> Hi all!
>
> This is not a typical DB-Question, but I hope you give me some hints
> either...
>
> If I insert a String instead of a date(f.Ex) into the DB, I get a
> Warning:
>
> MS SQL message: Syntax error converting datetime from character
> string. (severity 16)
>
> How can I catch these
look at
http://www.php.net/manual/en/function.mssql-get-last-message.php
Peter
---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
[EMAIL PROTECTED]
tel. 0121-242-1473
--
Hi all. I found in one of these DB lists a word about a tool called
MySQL - Front so I went there, downloaded it and ran it today for the
first time and well...
¡¡TWO THUMBS UP!!!
It really seems like a great GUI app. I installed it over Win XP Pro and
had no troubles with it so far. It'
Hi all!
This is not a typical DB-Question, but I hope you give me some hints
either...
If I insert a String instead of a date(f.Ex) into the DB, I get a
Warning:
MS SQL message: Syntax error converting datetime from character
string. (severity 16)
How can I catch these warnings in PHP?
Best
"Fernando Gonzalez" <[EMAIL PROTECTED]> wrote
> Php Was installed when installing the Red Hat 7.0 .
> Mysql Was installed later from rpm.
>
> Any ideas of what can I do???
>
write this script
save and start it through your browser.
Check the following parts:
CONFIGURE COMMAND: Is "--with-mysq
This doesn't look like a database question to me...
Anyway, try $_POST['variable_name'] if the variable comes from a form with
the POST-method
$_GET['variable_name'] - Form using GET-method or passing variables in the
URI (mypage.php?variable_name=42)
Regards
Joakim Andersson
> -Original M
" .
mysql_error());
$row = mysql_fetch_array($result);
$query = "select referer,(count(referer) / {$row['num_rows']} * 100) as
total_in_percentage from tececo_stats group
by referer";
$result = mysql_query($query) or die("Query failed: $query" .
mysql_error());
?>
{$row['referer']}{$row['total
I *think* this is kind of database-related... forgive me if it's not.
I am hopefully going to be managing the authentication on an Apache
webserver using the Apache DBM module which is like a database-based version
of .htaccess. I want to manage this with PHP, but don't know how to handle
the DBM
hi,
i've tryed to install php 4.2.1 with apache 1.3.24
php works, but i can't pass any variables.
is it in php.ini that i have to change something ?
or is the installation of php not correct ??..
thanks in advance,
Richard Pijnenburg
The netherlands
--
PHP Database Mailing List (http://w
51 matches
Mail list logo