How about using 3 select menus:
* One for the day called 'dayselect'
* One for the month called 'monthselect;
* One for the year called 'yearselect'
When you get the values from the selects to perform query's upon, re-arrange the order
the dates
come in:
In your form they'll be in the order:
Try http://php.weblogs.com/adodb
This is a database wrapper library which is very similar to M'soft ADO. Very
fast and full featured.
"Mrbaseball34" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I know about mysql_fetch_array but how would I do it for
> each
Just thought this would be helpful...
I've found the occassional problem with trying to insert a script-generated
null value (rare but it does happen). If this becomes a problem, remember
that NULL is just another word for "nothing". MySQL will accept either of
the following:
INSERT INTO table
> NOTE: I didn't read the entire post below...it's too early in the morning to
> think about code.
haha I did that the other day when I tried (and failed) to help out someone else -
damn tired,
hadn't even had a whiff of beer...
Cheers for your help!
Russ
On Wed, 24 Oct 2001 09:10:59 -0400 Mik
I'm attempting to do basic authentication through PHP and am having little
success. I have a login screen which requests a username and password, and
I need to have that check against a Windows domain. IE:
Domain: ALPHA
Login: testusername
Password: TestPassword
Then PHP needs to check aga
>Is there anyway to do this without popping up a standard basic authentication form
>box?
Sure! Are you making use of a databsae for this? MySQL per chance?
If so I may be able to help you out..
* Simply query the fields: 'username' 'password' 'domain' from a DB table called:
'users'
* SELECT t
What is everyone's favorite abstraction layer?
--
Jacob Singh, [EMAIL PROTECTED] on 10/24/2001
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROT
Title: RE: [PHP-DEV] Re: [PHP-DB] PHP and MySQL queries...
In these days and times, conservation of a meg of disk
space is really not a consideration. Not the primary one anyway.
The data should be stored in a format such that the
storage itself and then retrieval can be executed with a
minimu
Yes, I had the right code just was missing the mysql_data_seek. Thanks for
the help.
> -Original Message-
> From: Rick Emery [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 23, 2001 1:09 PM
> To: 'Adam Douglas'; PHP-DB (mailing list) (E-mail)
> Subject: RE: [PHP-DB] Using A Query Res
I have my php script working correctly with IIS 5 and SQL 7 (2 seperate
machines) as long as the user is anonymous. (the page is running as
IUSR_XXX)
But if you require the user to login, and use a username... even
administrator, the php will return " can not connect to database"
Help please
Dua
how can i select records from mysql and store them in a text or
spreadsheet file format?
thanks for reply
php 4 on win32
gerald clerc
Do you mean via PHP or directly at the MySQL command line?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 24, 2001 10:12 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] export
how can i select records from mysql and store them in a text or
spr
Hello,
I'm building some database class, so i can reuse my code when using a not
mysql database system.
I'm implementing a free_result now;
some code of my class
class database
{
function free_result($result)
{
mysql_free_result($result);
return;
}
..
}
?>
some of the cod
Hello-
I've always had this type of mail statement work for me:
mail($to, $Subject, $Body, "From: $From\r\nContent-Type: text/html;
charset=iso-8859-1");
My guess is that Outlook doesnt know what to do with the header you're
sending it (maybe too much info for outlook??)...
Other than that..
Chances are that Outlook is just looking for some Outlook-only headers. I
wound up using the MIME::Lite Perl module when creating a program to send
HTML-enabled e-mail.
How about a vote: who else thinks that HTML e-mail just plain sucks?
At 08:56 AM 10/24/2001, Jason Wood wrote:
>My guess is
I have a small situation where it would be good to be able to embed a
perl routing in a php script. Is this possible? Or do I need to pass
control from php to a perl script and return?
A quick synopsis would be (in pseudo code)
Alternatively, is there a module that can take a pdf file and m
: There is a solution but I don't know how good is it?
I'm not sure but the name of the project is PHPerl or something about it.
--
Andrey Hristov
Web Developer
Icygen Corporation
BUILDING SOLUTIONS
http://www.icygen.com
On Wednesday 24 October 2001 12:05 pm, you wrote:
> I have a small si
I am using concat in my sql and it runs fine on mysql client. But when used
in php it gives me an error:
Supplied argument is not a valid MySQL result resource in
/var/www/html/scripts/cfg_code_delete.php on line <
$ssql="select concat(category, "-", code) as fill_column, code_id as
submit_colum
Try escaping the quotes:
$ssql="select concat(category, \"-\", code) as ..."
Either that, or try surrounding the - with single quotes, as in '-'.
What's probably happening is that the query is being rendered as "select
concat (category, ", which isn't a valid query.
At 10:15 AM 10/24/2001, y
Hi,
I have a php web page that query a paradox DB (via odbc) and show me the
information I need. It's running on Windows 2000 server with IIS 5.0 and PHP
4.0.6. Today morning I installed SevicePack 2 and hotfix
q300972_W2k_sp3_x86_br.exe and my php can't access the paradox DB. The error
is:
Warn
I have the following installed on RH 7.1
php-4.0.4pl1-9
php-ldap-4.0.4pl1-9
php-manual-4.0.4pl1-9
php-common-4.0.5-0.3
php-imap-4.0.4pl1-9
php-mysql-4.0.4pl1-9
ucd-snmp-devel-4.2-12
ucd-snmp-4.2-12
ucd-snmp-utils-4.2-12
and I cannot seem to use the PHP snmpget() commands
this is a sample php_tes
Someone asked me to benchmark PHPLib also.
Here is the revised benchmarks, with some minor speedups for
PEAR DB and Metabase.
Benchmark was to select 82 rows from the products table 200 times.
The tests were repeated 5 times. Connection times were excluded
from the benchmark. Lower values are bet
Is there anyone using ERWin 3.5.2 to design/maintain
data dictionaries/schema for MySQL db's?
I would like to hear from you what kinds of strategies
you are using...
Thanks
Luis
__
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http:
It´s very easy and to tell you the truth I descovered it by accident:
Lets say you have a variable with the dynamic variable name (ej. $var_name =
"game1";)
if you want to create this variable ($game1) then you can write:
$$var_name
And that´s it.
try it.
"Jmack" <[EMAIL PROTECTED]> escribió e
It looks like you need only one array, $date[begin] = $date[end].
Let's see, I think it'll work. I'll write it in your code then you try:
$i=0;
$result = mysql_query ("SELECT DISTINCT date FROM linktracker WHERE name
LIKE '$PHP_AUTH_USER' ORDER BY date");
if ($row = mysql_fetch_array($result)) {
- Original Message -
From: "Jim Lucas" <[EMAIL PROTECTED]>
To: "Bart Verbeek" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, October 24, 2001 12:42 PM
Subject: Re: [PHP-DB] array-problems
> Try this:
>
> <<< BEGIN:PHP-CODE >>>
>
> $result = mysql_query ("SELECT DISTINCT date
Ok, I found snippets that talk about using either exec() or backticks.
The problem is that it still doesn't call the perl script. Or at least
doesn't seem to.
exec("convert-pdf.pl Blank.gif",$out);
echo(implode("\n",$out));
$out = `convert-pdf.pl Blank.gif`;
echo
You have to put the actual command in the exec or backticks as you would
type it in your shell, not just the filename. So instead of
$out = `convert-pdf.pl Blank.gif`;
Try
$out = `perl convert-pdf.pl Blank.gif`;
Sheridan Saint-Michel
Website Administrator
FoxJet, an ITW Company
www.foxjet.com
Is there any way to tell when a TABLE in MySQL was last modified?
I don't want to add a timestamp field as there are thousands of rows,
and I just need to know when ANYTHING in the table was last modified.
I haven't been able to find anything on this, and thought I would ask before
kludging toge
MySQL command: show table status
This command returns multiple fields, including date/time of last update,
for each table in the selected database.
Call it with mysql_query("show table status")
Check the MySQL manual for more information
-Original Message-
From: Sheridan Saint-Michel [
I've installed PostgreSQL into /usr/local/pgsql, then I tried
to include into my PHP support for PostgreSQL and made next:
(I had pre-compiled support for mySQL before that)
make clean
./configure --with-apxs=/usr/local/apache/bin/apxs --enable-versioning
--enable-track-v
On Wednesday 24 October 2001 23:21, Alexey Prohorenko wrote:
> I've installed PostgreSQL into /usr/local/pgsql, then I tried
> to include into my PHP support for PostgreSQL and made next:
> (I had pre-compiled support for mySQL before that)
>
> make clean
> ./configure --with-apxs=/usr
carols - true, but to avoid confusion and problem sif your names get more
complex (i.e. i think $$some_name will go crazy, you should always do it
like this
$var_name = "game1";
${$var_name}
cheers guys
// -Original Message-
// From: Carlos Augusto Abarca [mailto:[EMAIL PROTECTED]]
//
Have you checked if all modules are being loaded (obviously, PHP is being loaded into
apache...but
is PHP loading mysql.so and pgsql.so?
Cheers,
Dan
Alexey Prohorenko wrote:
> I've installed PostgreSQL into /usr/local/pgsql, then I tried
> to include into my PHP support for Pos
Thanks for the help. I had all the code right just had to add the
mysql_data_seek. Wasn't aware it operated in this manner.
> -Original Message-
> From: Peter Lovatt [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 23, 2001 3:41 PM
> To: Adam Douglas; PHP-DB (mailing list) (E-mail); P
H, try not to set your encoding to base64. I think that Outlooks works
find and decodes the base64 stream but this stream is a normal text, so with
this in header you make obfuscating. You pass "fox jumps over a lazy dog" and
Outlook thinks that is base64, so it decodes to "blablaba..."
Hello,
Can anyone help me with this script I'm using?
I've saved dates in a database and want to make two select-lists of these
dates in a html-form.
I want to select each unique date one time (no doubles).
List 1 is used to set the begin-date of the query for the report, List 2
will
set the end-
On Tuesday 23 October 2001 20:47, Adam Douglas wrote:
> mysql_fetch_array function. At first I thought I could loop through my
> while loop and have it put the results from the query of each row in to
> a multidimensional array. But then how would I add to the array after
> the initial row?
whil
Why don't you let them enter it however they want in the form
mm-dd-
mm/dd/yy
then in the php script that processes it, convert it with regulat expressions
to a timstamp and enter it in your database as an int. That's how I do it.
I don't understand the point in using the mysql timedate fiel
Agreed. This is especially useful when you need to conserve every byte you
can; a timestamp of "10/24/2001" or something similar is going to take 10
bytes as a string and an indeterminate number of bytes for an actual
timestamp because of system variations, whereas an integer value of 10242001
wi
40 matches
Mail list logo