--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
My only love sprung from my only hate!
Too early seen unknown, and known too late!
-- William Shakespeare, Romeo and Juliet
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net
ULT_LINK;
#
The above is for reference only. Obviously you would need to change things to
suit your situation and needs.
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
Love is like the measles; we all have to go through it.
-- Jerome K
-05 21:17:04
time() in PHP is the number of seconds since the Unix Epoch.
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
But, officer, he's not drunk, I just saw his fingers twitch!
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net
libssl.so.1 is needed by php-4.0.6-9.7.0
libcrypto.so.1 is needed by php-imap-4.0.6-9.7.0
Have you followed the instructions given on the RH website? Most upgrades are
performed using:
rpm -Uvh xxx.rpm
or
rpm -Fvh xxx.rpm
--
Jason Wong - Gremlins Associates
This may be a stupid question but I am stuck Do I have to have the Oracle
Linux Client to connet to a remote Oracle Database or can I just have the
php --with-oci8 turned on and that be it? And I can't seem to find any
how-tos on just installing the client and I am not sure what prerequisites I
($row_new[0] . $row_new[1]);
echo($row_old[0] . $row_old[1] . br);
}
}
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
Sorry never means having your say to love.
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net
PDF, GIF, JPG. ZIP
and WORD documents, and a general icon for the rest of file extensions.
Anybody can point me into the right direction for evaluate this?
If you're using Linux there is a command called 'file' which does a good job
identifying what type a particular file is.
--
Jason Wong
On Friday 22 February 2002 16:51, [EMAIL PROTECTED] wrote:
Hello,
Thanks for your reply. I am not putting the \ slashes in the query, I
think php is. However, I am not sure how to remove them from the query that
is being sent to mysql.
Check out stripslashes().
--
Jason Wong - Gremlins
The function sendtohost:
[snip]
Is great for posting results to a regular http site. But
what I need to do is post to a secure site (https).
At that point, you'll want to look into using CURL extensions
to PHP.
http://www.php.net/manual/en/ref.curl.php
Jason
--
PHP Database Mailing
.
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
There's so much to say but your eyes keep interrupting me.
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
it up a bit. To answer a previous quesiton for another
post, no you wouldn't store the array in the session. That wouldn't be a
good idea unless you want to expose your data to the world.
--jason
- Original Message -
From: Dan Swensen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday
.clientID) WHERE ratings2.status = '2' AND ratings3.status = '3'
GROUP BY clients.clientname;
That should do the trick. Enjoy!!
Jason Cox
- Original Message -
From: John Hawkins [EMAIL PROTECTED]
To: php-db list [EMAIL PROTECTED]
Sent: Wednesday, February 13, 2002 7:11 PM
Subject: [PHP-DB
be a better way but it
doesn't.
Jason Cox
- Original Message -
From: John Hawkins [EMAIL PROTECTED]
To: Jason Cox [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, February 13, 2002 9:08 PM
Subject: Re: [PHP-DB] counting multiple columns based on different values
Oops. I spoke
that helps,
Jason Cox
- Original Message -
From: Dan Swensen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 12, 2002 5:30 PM
Subject: [PHP-DB] Flipping through database records
Hello,
I am attempting to put together a page whereby results from a database are
displayed
though eventually it
will be reused I believe.
Hope that helps.
Jason Cox
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
doesn't work too hot mean?
Does it work or not?
If it doesn't, what's wrong with it?
If it does work, why don't you like it?
If it makes you feel better, I feel lost as well :)
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
I'd love to go out with you, but I have to floss my cat
On Sunday 10 February 2002 00:21, Miles Thompson wrote:
Unless there has been a very recent development, MySQL doesn't support
transactions. Use PostgreSQL, DB, etc.
The v4 series of MySQL does support transactions.
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
Without love
, count(artist) FROM artist WHERE artist LIKE 'b%'
ORDER BY artist ASC;
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
Love is being stupid together.
-- Paul Valery
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net
a query directly on the db. Something like:
update mytable set myfield = LOWER(myfield) WHERE 1;
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
Distrust all those who love you extremely upon a very slight acquaintance
and without any visible reason.
-- Lord
file '/tmp/#sql451_86_0.frm' (Errcode: 28)
I have no clue how to solve this.
Can anybody give a hint?
Thanx for any help
Andy
You've probably run out of space in /tmp.
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
Love is in the offing.
-- The Homicidal
[keynameherewithquotes]
As you have discovered yourself :)
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
It is far better to be deceived than to be undeceived by those we love.
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net
$contact_list; }
else {
echo $msg;
}
?
p align=centera href=admin.htmfont face=Arial, Helvetica,
sans-serifGo
Back to Main Menu/font/a/P
/body
==
hth
--
Jason Wong - Gremlins Associates
On Wed, 6 Feb 2002, Todd Williamsen wrote:
that doesn't work
Bit terse? What do you get? Error? Nothing?
--
Jason Wong
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
that doesn't necessarily mean that your query returned any
*results*.
Insert some echos in your while loop to see whether you have any results.
--
Jason Wong
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
into session management probably... I have written
a system like that from scratch, but there may be easier ways...
Is php the right scripting language for this job?
DEFINITLY
Thank you for your time, it is greatly appreciated.
John George
[EMAIL PROTECTED]
-Jason Garber
IonZoft.com
--
PHP Database
if the sql states to insert the date it doesn't, or
does the date need to be manually added?
Use a field of the type Timestamp -- it updates automatically whenever the
record is updated.
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
The only difference in the game of love over
See the set_time_limit() function in the php manual.
-Jason Garber
IonZoft.com
At 10:22 AM 2/4/2002 +0800, J-E-N wrote:
hello all,
i'm trying to make a script where i can do a mass insert to database
(4,000 entries) and then send confirmation email to each of the entry's
email address
Query! statement.
what is wrong... anybody? Bueller?
Try using single quotes:
$sql = INSERT INTO Jobs (id, Industry, Other, JobTitle, Description,
Location, Date)
VALUES
('',
'$id', '$Industry', '$Other', '$JobTitle', '$Description',
'$Location', '$Date');
--
Jason Wong - Gremlins
On Tuesday 29 January 2002 21:15, Markus Lervik wrote:
On Monday 28 January 2002 18:42, Jason Wong wrote:
$page behaves just fine :
[snip]
page: 2 - yup, it's incrementing, all right...
nr_pages: 230
Whack! Doesn't work any more... It's starting to drive me mad.
Me too
=foodNext/a
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
A kiss is a course of procedure, cunningly devised, for the mutual
stoppage of speech at a moment when words are superfluous.
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED
would probably be something like this:
$q_orders_id2 = INSERT INTO orders(orders_datum, orders_sessid);
$q_orders_id2 .= VALUES ('$date', '$sid');
# for debugging, you may want to echo $q_order_id2
$r_orders_id2 = mysql_query($q_orders_id2);
$orders_id = mysql_insert_id();
hth
--
Jason
a bit and print it again,
it looks fine.
Change it a third time, and it suddenly gets the value it
had in the beginning.
Ideas as to how one would go about solving this little problem?
Could you post some code please?
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
The heart has
On Monday 28 January 2002 21:05, Markus Lervik wrote:
On Monday 28 January 2002 14:57, Jason Wong wrote:
Somehow when I print the value of $query, it looks fine.
Then, when I change $query a bit and print it again,
it looks fine.
Change it a third time, and it suddenly gets the value
the relevant code?
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
Distrust all those who love you extremely upon a very slight acquaintance
and without any visible reason.
-- Lord Chesterfield
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe
On Tuesday 29 January 2002 00:24, Markus Lervik wrote:
On Monday 28 January 2002 18:06, Jason Wong wrote:
$page behaves just fine :
[snip]
page: 2 - yup, it's incrementing, all right...
nr_pages: 230
Whack! Doesn't work any more... It's starting to drive me mad.
Me too. Post the full
that is true I would like that could be a security
problem.
let me know
Manual - Chapter - Safe Mode
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
I'd love to go out with you, but I've been scheduled for a karma transplant.
*/
--
PHP Database Mailing List (http://www.php.net
if you have a date column 'birthdate'
SELECT (birthdate + INTERVAL 7 MONTH) as birthdate FROM yourtable WHERE ...
Look at the date and time functions in the MySQL manual.
-Jason Garber
IonZoft.com
At 02:28 PM 1/27/2002 +, DL Neil wrote:
Hello Sander,
I want to add a variable numer
it to alias a column name:
SELECT a_column_with_a_very_long_name AS short_name FROM ...
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
Lonely is a man without love.
-- Englebert Humperdinck
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e
://sourceforge.net/projects/pc4p/). Its a class which
makes creating PDFs extremely easy.
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
MOUNT TAPE U1439 ON B3, NO RING
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional
the
nasty red Xs. Is there a way do some kind of IF statement. If the image url
is there, display image if not display No picture available or something
like that?
Yes.
if ($image) {
display_url(); }
else {
echo No image;
}
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
are tested (and
working!). If this is an exercise in learning how to write classes then good
luck :)
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
The perfect lover is one who turns into a pizza at 4:00 A.M.
-- Charles Pierce
*/
--
PHP Database Mailing List (http
a long time (more than 1 minute) with thousand record. I have
index within 2 table (name+surname, id). It did not have problem if I
check only id or name+surname.
This is a mysql question. Perhaps you should ask on the mysql list.
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
One
did you want it to do?
What is it doing now?
What error does it give, if any?
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
Always there remain portions of our heart into which no one is able to enter,
invite them as we may.
*/
--
PHP Database Mailing List (http
).
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
His heart was yours from the first moment that you met.
*/
--
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
reveals that the purported image dimensions are 0 x 0 pixels and Bits per
pixel is also 0.
Saving the thumbnail and loading into IrfanView gives an invalid header error.
I think you'll have to look at re-doing your thumbnails.
hth
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
I'd
Missed this error the first time round. It should be:
$sql .= description LIKE '%$word%' OR ; # note the $!!
hth
--
Jason Wong
--
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
,$connection)
or die(Couldn't execute query.);
hth
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
Why must you tell me all your secrets when it's hard enough to love
you knowing nothing?
-- Lloyd Cole and the Commotions
*/
--
PHP Database Mailing List (http://www.php.net
.
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
Sometime when you least expect it, Love will tap you on the shoulder...
and ask you to move out of the way because it still isn't your turn.
-- N.V. Plyter
*/
--
PHP Database Mailing List (http://www.php.net
On Thursday 17 January 2002 06:27, Jaime A. Chavarriaga L. wrote:
Jason
SELECT * FROM TABLE
WHERE sex = 1 OR country = 'CA';
Will select all users who are female as well as all users from Canada.
You may get duplicate records (for people who are female and from Canada)
so
you
= '
You're using single quotes to define the $message string thus no variable
expansion takes place. I suggest breaking up the assignment into several
chunks, for example:
$message = 'Hello ' . $name . ', how are you';
hth
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
Love
who are female as well as all users from Canada. You
may get duplicate records (for people who are female and from Canada) so you
may want to use DISTINCT as well.
hth
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
Yeah, there are more important things in life than money
the
designs and just using a get_num_rows and then only using the first 20?
Possibly, I don't know. BUT if query returns 8000 records as opposed to 20,
then it definitely uses up a bit more memory. This may be an issue if you
have loads of such queries happening simultaneously.
--
Jason Wong
variable indicating which page of
results to view, rather than an 'action' variable.
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
In real love you want the other person's good. In romantic love you
want the other person.
-- Margaret Anderson
*/
--
PHP Database
On Tuesday 15 January 2002 10:53, olinux wrote:
Is there a solution to this if you do not have edit
access to the php.ini file? [ie. a shared server]
A number of the settings in php.ini can be set/altered from within your
script. Check out ini_set() and friends.
--
Jason Wong - Gremlins
= DBfetch_array($monthly_result);
You've already used the first row of results (without processing it).
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
I'd love to go out with you, but I did my own thing and now I've got
to undo it.
*/
--
PHP Database Mailing List (http://www.php.net
instead of previous
inserts as expected
mysql_query($sql);
}
You don't say what error, if any, you're getting. My best guess is that you
probably need to use addslashes() to treat your data before inserting into
the database.
hth
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
a lot of the existing PHP applications. Either change
the php.ini settings to match those of an earlier version of PHP (eg 4.0.6)
or wait until the author of the apps in question upgrade them to make it
compatible with 4.1.1(!)
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
I don't
On Thursday 10 January 2002 21:53, HiM wrote:
Jason,
But after downgrade to 4.0.6, is there any new feature I can't use?
Nori Chan
If you're going to be using only PHPNuke and/or PHPGroupware and they haven't
been updated for 4.1.1 then they won't be using any of the new features
On Thursday 10 January 2002 22:15, HiM wrote:
Jason,
phpNuke problem fixed after downgrade to 4.0.6
Glad to hear.
Thanks !
You're welcome :)
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
Falling in love is a lot like dying. You never get to do it enough to
become
AS auth
FROM acl
WHERE username = '$username'
AND password = PASSWORD('$password');
Hopefully that should work ;-)
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
Love is the process of my leading you gently back to yourself
On Thursday 10 January 2002 06:56, Richard Stringer-Hye wrote:
Will someone please send me the correct unsubscribed sequence for this
list? Have tried from phpnet with no success.. Thanks.
Have you tried this?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail:
$country); OR
$country=;
should do the trick.
hth
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
I'd love to go out with you, but I'm converting my calendar watch from
Julian to Gregorian.
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL P
in:
$bits[0] =
$bits[1] = aaa
$bits[2] = ccc etc.
hth
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
Love conquers all things; let us too surrender to love.
-- Publius Vergilius Maro (Virgil)
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e
can spot where the problem is or know of a simpler/more effective
method of determining an expiry date, please let me know.
Thanks a TON!!
Jason.
-Original Message-
From: Jason Dulberg [mailto:[EMAIL PROTECTED]]
Sent: December 26, 2001 6:52 PM
To: [EMAIL PROTECTED]
Subject
.
__
Jason Dulberg
Extreme MTB
http://extreme.nas.net
--
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 PROTECTED]
?
value='XXX' only specifies what the value would be *if* the checkbox was
checked. To actually *set* the checkbox you need:
input type=checkbox name=firstvalue value='$result[32]' checked
hth
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
Always there remain portions of our heart
/to/search/*`;
$files would then contain the list of files in which search_string was
found.
hth
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
Absence is to love what wind is to fire. It extinguishes the small,
it enkindles the great.
*/
--
PHP Database Mailing List (http
On Monday 17 December 2001 15:52, Jason Wong wrote:
On Monday 17 December 2001 15:11, Sommai Fongnamthip wrote:
Hi,
How could search string (like full text search) in any text file (even
know or not known filename)?
One way of doing this if you're using a Linux/Unix system
] . br;
regards
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
Love is never asking why?
*/
--
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
index.html files correctly...(but is not
working with index.php)!
You should have a line similar to this:
DirectoryIndex index.html index.htm index.shtml index.php
hth
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
Give me chastity and continence, but not just now
in the
directory '/usr/local/lib/php' (and not in a sub-directory of
'/usr/local/lib/php')?
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
If Love Were Oil, I'd Be About A Quart Low
-- Book title by Lewis Grizzard
*/
--
PHP Database Mailing List (http://www.php.net
graphs.
regards
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
Under deadline pressure for the next week. If you want something, it can
wait.
Unless it's blind screaming paroxysmally hedonistic...
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail
\ttd$col_value/td\n;
}
print \t/tr\n;
}
print /table\n;
Read the manual for full details.
hth
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
Total strangers need love, too; and I'm stranger than most.
*/
--
PHP Database Mailing List (http://www.php.net
could get quite frustrating. So, let
me know what you come up with if you have the time.
-Jason Garber
IonZoft.com
At 10:29 AM 11/22/2001 +0100, [EMAIL PROTECTED] wrote:
Hi, out there
Has anybody found a way to pass variables between javascript and php?
Here's what I want to achieve:
1. I want
=UNIX_TIMESTAMP() where ID=12345;
-Jason Garber
IonZoft.com
At 02:45 PM 11/17/2001 +, Srinivasan Ranganathan wrote:
Hi
I need to store the date and time of sign-up and date
and time of last successful login in a mysql database
and calculate how long the user has been using a site.
how do i
wildcard character.
hth
--
Jason Wong
Gremlins Associates
www.gremlins.com.hk
--
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 PROTECTED]
=\$value);
return $output;
}
I still don't understand what the fix should be or what is wrong.
You can just define that function as:
function hidden_field($name, $value) {
blah...
blah...
}
hth
--
Jason Wong
Gremlins Associates
www.gremlins.com.hk
--
PHP Database Mailing
the mail function to send it
UPDATE thelist SET sentdate=UNIX_TIMESTAMP() WHERE email_id=$email_id
then I use the sleep() or usleep() function to wait a second or so (so I
do not use too much bandwidth)
}
-Jason Garber
IonZoft.com
At 07:26 AM 11/2/2001 -0600, Rick Emery wrote:
Ops
. =)
Jason
Jason Wong [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]...
On Wednesday 31 October 2001 05:11 am, Jason wrote:
The date field is varchar. And I believe it is for daylight savings.
I am trying out a couple of things on a test date field so I will get
back with you guys after
Here is my problem once again... =P I am wondering if I should change the
date table to something other than date... maybe something like date_1?
Would doing that resolve my issue, because of the fact that the date
variable in php is function? Thanks in advance...
Jason
/* Form to supply
with the form
$value = $HTTP_GET_VARS[$sName];
Regards,
-Jason Garber
IonZoft.com
At 09:10 AM 10/30/2001 +0100, * RzE: wrote:
Original message
From: LeTortorec, Jean-Louis [EMAIL PROTECTED]
Date: Mon, Oct 29, 2001 at 04:03:45PM -0500
Message-ID: 615315231286D21182E40008C7B1EED23C6E76
On Wednesday 31 October 2001 01:31 am, Jason wrote:
Here is my problem once again... =P I am wondering if I should change
the date table to something other than date... maybe something like
date_1? Would doing that resolve my issue, because of the fact that
the date variable in php
.
According to the docs, date is *not* a reserved word in MySQL, so he
should be OK.
--
Jason Wong
Gremlins Associates
www.gremlins.com.hk
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact
s:[EMAIL PROTECTED]...
Isn't date a reserved word that should not be used as a field name? It
appeared that what was asked was if he should change the name of his field
from date to date_1. It should definitely be changed if it is now called
date.
Jason Wong [EMAIL PROTECTED] said:
On Wedn
of information
would maybe sum up the problem in the date field. I have been reading up on
the date function in the MySQL book I have but somethings it just doesn't
cover. So please excuse my being vague. Thanks,
Jason
Rick Emery [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL P
ry
Sent: Tuesday, October 30, 2001 2:09 PM
To: 'Jason'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] PHP query on date field
Jason,
date(H) converts to a 24-hour clock. That is, 00 is 12 mid-night, 01 is
1
AM, 13 is 1 PM, 14 is 2 PM, 23 is 11 PM, etc.
I do not understand the reasons for your com
On Wednesday 31 October 2001 04:34 am, Jason wrote:
This portion of the site was done by a previous employee and well
you know the expression.. If its not broke don't fix it. Well now
that I cannot query the db by the date it is now broke and I am still
figuring out how MySQL is taking
The date field is varchar. And I believe it is for daylight savings. I am
trying out a couple of things on a test date field so I will get back with
you guys after I try your suggestions. And by the way I sincerely appriciate
all the help you and Rick are giving me. Thanks again,
jason
Jason Wong
On Wednesday 31 October 2001 05:11 am, Jason wrote:
The date field is varchar. And I believe it is for daylight savings.
I am trying out a couple of things on a test date field so I will get
back with you guys after I try your suggestions. And by the way I
sincerely appriciate all the help
-update_time, $row-room_num);
These should be:
printf(%s, %s, %sbr, .);
regards
--
Jason Wong
Gremlins Associates
www.gremlins.com.hk
--
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
.
If you used the Redhat RPMs to install PHP then install the PHP-MySQL
rpm (possibly php-mysql-4.0.4pl1-9.i386.rpm).
So that you won't be mislead, this error has nothing to do with
PHP-Nuke.
regards
--
Jason Wong
Gremlins Associates
www.gremlins.com.hk
--
PHP Database Mailing List (http
, $var4=some
I'm doing this for a search script. Want it to take the input, and
search a mysql db for each of the keywords... Please e-mail a
response to [EMAIL PROTECTED]
Checkout the explode() function.
--
Jason Wong
Gremlins Associates
www.gremlins.com.hk
--
PHP Database Mailing List (http
so
I can update my own. Thanks again eveyone!!
jason
enj0i.com
?php
#
# phpMySearch v. 0.1.3 - MySQL DB Search Form
#
# Author: Jason Gerfen
# Email: [EMAIL PROTECTED]
# Site: http://enj0i.com
# Date: 10.26.2001
the Grant statement in my php
page and not on Telnet.
All the grants and access info are stored in the mysql database. You
can manipulate it directly to grant whatever you want. For the details
look in the manual.
regards
--
Jason Wong
Gremlins Associates
www.gremlins.com.hk
--
PHP Database
that I've got no idea =)
--
Jason Wood
Chief Technology Officer
Expressive Tek, Inc.
407 Kehrs Mill Road
Ballwin, MO 63011
Phone 636.256.1362
www.expressivetek.com
Benny [EMAIL PROTECTED] wrote in message
001501c15c1d$7f2f5560$0b01a8c0@ISKAT">news:001501c15c1d$7f2f5560$0b01a8c0@ISKAT...
I have exhausted my resources.
Jason [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I am having a hard time setting up a form for users to enter a date in the
format of 00/00/ (of course they would use an actual date). My form
is
as follows...
f
You read the mysql manual.
www.mysql.com
Look up alter table.
ALTER TABLE mytable ADD KEY keyname (keyfield1, keyfield2);
-Jason Garber
At 08:33 PM 10/23/2001 -0700, søren eriksen wrote:
How do I set up secondary keys in mysql?
--
PHP Database Mailing List (http://www.php.net
Tell me the results. W'ell go from there...
rick
-Original Message-
From: Jason [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 23, 2001 12:37 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Re: PHP and MySQL queries...
As of yet I have tried all sorts for date formating for the sear
))
{
$count ++;
do
{
print BName: /B.$row['fname, lname'].BR\n;
if (mysql_num_rows($results) )
{
while( $row = mysql_fetch_array($result) )
{
}
}
else
{
print No rows found;
}
}
}
Let me know if it works!!
--
Jason Wood
Chief Technology Officer
this seach page but they do not
cover using a form to pass a variable to a php script for use withing a
select statement against a database. If anyone has any ideas, suggestions
or otherwise please let me know because I would love to get this script
finished and posted somewhere. Thanks again.
Jason
701 - 800 of 891 matches
Mail list logo