Re: [PHP-DB] Session variables

2001-08-14 Thread Jason Wong
? session_start(); ... ... ? would not work because there is a blank line between the beginning of the file and the place where you actually set the cookie -- session_start();. This of course applies to any included files as well. regards -- Jason Wong Gremlins Associates www.gremlins.com.hk

Re: [PHP-DB] includes and filenames

2001-08-15 Thread Jason Wong
;; } = I hope the above comes out OK. I'm writing this using Outlook Express spit and it has a tendency to think it knows better and keeps removing the s around http://www.domain.com;. regards -- Jason Wong Gremlins

Re: [PHP-DB] Getting info from Cookie

2001-08-15 Thread Jason Wong
and in your case you want the first element. $parts = explode(+, $HTTP_COOKIE_VARS[TestCookie]); echo $parts[0] 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

Re: [PHP-DB] using is_uploaded_file($userfile1)??

2001-08-16 Thread Jason Wong
whether the file is actually uploaded? Could it be that the directory for uploaded files is different between the two servers? 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

Re: [PHP-DB] Update info from form to MySQL. No error but no Update

2001-08-16 Thread Jason Wong
is less typing and, IMHO, clearer. PHP statements end on a semi-colon (;) and not at a newline so you are free to break up your statements into multiple lines to aid readability. regards -- Jason Wong Gremlins Associates www.gremlins.com.hk -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] E-Commerce - Integrating Sessions With Charging Processes That rePOST

2001-08-20 Thread Jason Wong
the session-id in the return URL. 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 administrators, e-mail: [EMAIL

Re: [PHP-DB] E-Commerce - Integrating Sessions With Charging Processes That rePOST

2001-08-21 Thread Jason Wong
- Original Message - From: Fotwun [EMAIL PROTECTED] To: Jason Wong [EMAIL PROTECTED]; Fotwun [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, August 21, 2001 4:24 AM Subject: RE: [PHP-DB] E-Commerce - Integrating Sessions With Charging Processes That rePOST How, code wise do I

Re: [PHP-DB] Query construction (again)

2001-08-22 Thread Jason Wong
(); Depending on how the date is stored (date + time, or just date) you may have to modify the output of now() to match. 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

Re: [PHP-DB] MySQL DB CleanUp Help!

2001-08-23 Thread Jason Wong
. Here's one way to do it: Create a php page which when accessed will do deletions you require. Create a cron job which uses wget to access that page. regards -- Jason Wong Gremlins Associates www.gremlins.com.hk -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL

Re: [PHP-DB] variable if statement

2001-08-23 Thread Jason Wong
using if (eval($string)) but that just gave me errors. $string = (($a == 1) OR ($b == 2)); 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

Re: [PHP-DB] PHP/mySQL and INSERT statements

2001-08-28 Thread Jason Wong
no idea why. Can someone give me some direction here? I would be eternally grateful for it. Try this: $query = INSERT INTO rants VALUES (NULL, '$date', '$type', '$title', '$text'); You shouldn't specify a value for a field if it is auto-increment. hth -- Jason Wong Gremlins Associates

Re: [PHP-DB] Use the User Input Critia as part of Query! (Mysql)

2001-09-03 Thread Jason Wong
; hth -- Jason Wong Gremlins Associates www.gremlins.com.hk Tel: +852-2573-5033 Fax: +852-2573-5851 -- 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

Re: [PHP-DB] newbie having problem

2001-09-03 Thread Jason Wong
, mysql_password) or die (Could not connect); print (Connected successfully); mysql_select_db (my_database) or die (Could not select database); to ensure that you *are* able to connect to the server and also *select* the database? hth -- Jason Wong Gremlins Associates

Re: [PHP-DB] Table creation problems...

2001-09-09 Thread Jason Wong
as the name of another table? try CREATE TABLE '$groupid' ... hth -- Jason Wong Gremlins Associates www.gremlins.com.hk Tel: +852-2573-5033 Fax: +852-2573-5851 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL

Re: [PHP-DB] order by question

2001-09-11 Thread Jason Wong
DESC for ascending and descending. regards -- Jason Wong Gremlins Associates www.gremlins.com.hk Tel: +852-2573-5033 Fax: +852-2573-5851 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact

Re: [PHP-DB] USA Attacks

2001-09-12 Thread Jason Wong
sigh http://www.nostradamus-repository.org/cityofgod.html - Original Message - From: Lars B. Jensen [EMAIL PROTECTED] To: Danny N. [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, September 13, 2001 12:59 AM Subject: RE: [PHP-DB] USA Attacks Nostradamus died in 1566... I

Re: [PHP-DB] Table display Driving me Crazy!

2001-09-13 Thread Jason Wong
be rewritten as: ? $numcols = 5; ? ? for ($l = 1; $l = $numcols; ++$l): ? td width=139 class=ModNo bordercolor=#00 ? echo $db-f(product_sku); ? /td ? endfor; ? hth -- Jason Wong Gremlins Associates www.gremlins.com.hk Tel: +852-2573-5033 Fax: +852-2573-5851 -- PHP

Re: [PHP-DB] Table display Driving me Crazy!

2001-09-13 Thread Jason Wong
having to escape all the s) :) regards -- Jason Wong Gremlins Associates www.gremlins.com.hk Tel: +852-2573-5033 Fax: +852-2573-5851 -- 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

Re: [PHP-DB] How to Replace the table data

2001-09-13 Thread Jason Wong
-- Jason Wong Gremlins Associates www.gremlins.com.hk Tel: +852-2573-5033 Fax: +852-2573-5851 -- 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

Re: [PHP-DB] How to Replace the table data

2001-09-13 Thread Jason Wong
) the update query should be: UPDATE table SET url='http://something.com/target' WHERE url='http://www.something.com/' regards -- Jason Wong Gremlins Associates www.gremlins.com.hk Tel: +852-2573-5033 Fax: +852-2573-5851 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL

Re: [PHP-DB] How to Replace the table data

2001-09-14 Thread Jason Wong
query using the mysql client? I use this : UPDATE posts SET post_text='IMG SRC=IMG SRC=/serv2/big/forum/images/smiles' WHERE post_text='IMG SRC=/gmns/BB/images/smiles' FYI : posts_text = text field (NOT NULL=YES) -- Jason Wong Gremlins Associates www.gremlins.com.hk Tel: +852-2573-5033 Fax

Re: [PHP-DB] How to Replace the table data

2001-09-14 Thread Jason Wong
of MySql to see whether they will help: http://www.mysql.com/doc/S/t/String_functions.html regards -- Jason Wong Gremlins Associates www.gremlins.com.hk Tel: +852-2573-5033 Fax: +852-2573-5851 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED

Re: [PHP-DB] NEWBIE - Needs Assistance with Joins

2001-09-17 Thread Jason Wong
: $CDList = mysql_query(SELECT artist_name, album_title FROM artists, album_titles WHERE artist_id = 'aid' ); hth -- Jason Wong

RE: [PHP-DB] INSERT prob

2001-09-21 Thread Jason Wong
, $connection) or die(mysql_error()); } } NB code is untested, use with caution :) hth -- Jason Wong Gremlins Associates www.gremlins.com.hk Tel: +852-2573-5033 Fax: +852-2573-5851 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

RE: [PHP-DB] INSERT prob

2001-09-22 Thread Jason Wong
] = Betty; $user[0][Age] = 5; $user[0][Course] = Starters; $user[1][Name] = Alan; $user[1][Age] = 29; $user[1][Course] = Main; while(list($key, $val) = each($user)) { echo $val[Name]br; echo $val[Age]br; echo $val[Course]br; } regards -- Jason Wong Gremlins Associates

RE: [PHP-DB] Grant statement

2001-09-24 Thread Jason Wong
only able to use the GRANT *if* your host/provider has given you permission to do so using your current username/password. Basically, if you're able to access your database right now, then there's nothing you need to do. regards -- Jason Wong Gremlins Associates www.gremlins.com.hk Tel: +852-2573

RE: [PHP-DB] MySQL Hash Function

2001-09-25 Thread Jason Wong
type functions in MySQL are reversible. What this means is that instead of sending a user their 'lost' password you have create a new (random) one for them, email it to them and ask them to change it pronto. hth -- Jason Wong Gremlins Associates www.gremlins.com.hk Tel: +852-2573-5033 Fax: +852

RE: [PHP-DB] Error on connecting to mysql database

2001-09-25 Thread Jason Wong
/public_html/test01.php on line 6 what's wrong? thx Most likely your php was not compiled with mysql support. Use ? phpinfo(); ? to find out. If you don't see a mysql section then you need to recompile your php. regards -- Jason Wong Gremlins Associates www.gremlins.com.hk Tel: +852-2573-5033 Fax

RE: [PHP-DB] Can't connect Mysql using php

2001-09-26 Thread Jason Wong
n line 6 what's wrong? thx Run ? phpinfo(); ? and tell us the output of the 3rd row of the first table, ie the Configure Command. -- Jason Wong Gremlins Associates www.gremlins.com.hk Tel: +852-2573-5033 Fax: +852-2573-5851 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail

RE: [PHP-DB] Problem with session function: URL Parameter

2001-09-26 Thread Jason Wong
the string ?=SID? were displayed! Thank you!!! bye That's because you're using ? ? when you're already inside a php block. Try: admin/admin.phtml?php=SID instead. hth -- Jason Wong Gremlins Associates www.gremlins.com.hk Tel: +852-2573-5033 Fax: +852-2573-5851 -- PHP Database Mailing List

RE: [PHP-DB] Re: mysql_fetch_array() doesn't work

2001-09-30 Thread Jason Wong
'].\ target='_top'; then IE showed no error any longer. So I have to let all $arr['key'] out of the quotes, then the scripts are Ok. Regards Mike No need for quotes anyway: $arr[key] works just fine :) regards -- Jason Wong Gremlins Associates www.gremlins.com.hk Tel: +852-2573-5033 Fax: +852

RE: [PHP-DB] Check Boxes/UPDATE

2001-10-03 Thread Jason Wong
$chkAuthStatus to find out whether it is checked or not. regards -- Jason Wong Gremlins Associates www.gremlins.com.hk Tel: +852-2573-5033 Fax: +852-2573-5851 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED

RE: [PHP-DB] Check Boxes/UPDATE

2001-10-03 Thread Jason Wong
understand -- the setting up of the form, or retrieving the info from the form? -- Jason Wong Gremlins Associates www.gremlins.com.hk Tel: +852-2573-5033 Fax: +852-2573-5851 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail

RE: [PHP-DB] MYSQL Problems Please help

2001-10-04 Thread Jason Wong
-- Jason Wong Gremlins Associates www.gremlins.com.hk Tel: +852-2573-5033 Fax: +852-2573-5851 -- 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]

RE: [PHP-DB] MYSQL Problems Please help

2001-10-04 Thread Jason Wong
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 04 October 2001 17:11 To: Jason Wong Subject: Re: [PHP-DB] MYSQL Problems Please help Jason, Mysql is running, so thats not the problem. I tired to run your updatedb to no avail. my directory for mysql is /var

Re: [PHP-DB] newbie - problems with Select and timestamp(14) calculation

2001-10-18 Thread Jason Wong
-15 23:50:26' mysql select NOW() + 0; - 19971215235026 As you can see what it returns is clearly unsuitable for what you have in mind. Your best bet is probably to use UNIX_TIMESTAMP(). regards -- Jason Wong Gremlins Associates www.gremlins.com.hk -- PHP Database Mailing List (http

Re: [PHP-DB] newbie - problems with Select and timestamp(14) calculation

2001-10-18 Thread Jason Wong
, lookup UNIX_TIMESTAMP(), it should do what you want. rgds -- 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

Re: [PHP-DB] New users on mysql using php

2001-10-25 Thread Jason Wong
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

Re: [PHP-DB] Did you use PHP-Nuke? Need help.

2001-10-29 Thread Jason Wong
. 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

Re: [PHP-DB] PHP Getting Variables from String

2001-10-29 Thread Jason Wong
, $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

Re: [PHP-DB] PHP query on date field

2001-10-30 Thread Jason Wong
%' AND phone LIKE '%$phone%' AND date = '$date' ); 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

Re: [PHP-DB] PHP query on date field

2001-10-30 Thread Jason Wong
. 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

Re: [PHP-DB] PHP query on date field

2001-10-30 Thread Jason Wong
)) ; #this date is used in the online database I am wondering if I should let the date be put into the db as 2001-15-10... Changing the format of your dates to standard DATE or DATETIME *would* be a sensible thing to do :) -- Jason Wong Gremlins Associates www.gremlins.com.hk -- PHP

Re: [PHP-DB] PHP query on date field

2001-10-30 Thread Jason Wong
that MySQL provides! 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 administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] very strange problem for mysql query

2001-10-30 Thread Jason Wong
-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

Re: [PHP-DB] Function Prolem parse error

2001-11-04 Thread Jason Wong
=\$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

Re: [PHP-DB] Problem with include()

2001-11-13 Thread Jason Wong
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]

Re: [PHP-DB] resource id #2, #3, #4......

2001-11-28 Thread Jason Wong
\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

Re: [PHP-DB] Fast template

2001-12-03 Thread Jason Wong
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

Re: [PHP-DB] Use php to plot graph.

2001-12-03 Thread Jason Wong
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

Re: [PHP-DB] Getting apache to recognizeindex.php....

2001-12-04 Thread Jason Wong
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

Re: [PHP-DB] Re: sorry...probably too easy

2001-12-05 Thread Jason Wong
] . 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

Re: [PHP-DB] undefined function: pg_connect()

2001-12-10 Thread Jason Wong
(); ? If pgsql support is compiled in then you will see a table titled pgsql. If you're pretty sure that you did compile in pgsql but do not see it listed then maybe you forgot to restart apache. hth -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* I never loved another person the way

Re: [PHP-DB] compile with pgsql support

2001-12-11 Thread Jason Wong
On Tuesday 11 December 2001 20:16, Michael Hanna wrote: How do I compile PHP to include postgreSQL support? Do I add a switch of some sort during 'configure'? I'm using unix(Darwin 5.1). Yes. ./configure --with-pgsql ... ... -- Jason Wong - Gremlins Associates - www.gremlins.com.hk

Re: [PHP-DB] search string in text file

2001-12-16 Thread Jason Wong
/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

Re: [PHP-DB] search string in text file

2001-12-16 Thread Jason Wong
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

Re: [PHP-DB] Checkboxes, PHP, and MySQL

2001-12-20 Thread Jason Wong
? 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

Re: [PHP-DB] How to insert to DB from txt??? Please help

2002-01-04 Thread Jason Wong
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

Re: [PHP-DB] Re: Array not supported for strings???

2002-01-05 Thread Jason Wong
$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

Re: [PHP-DB] unsub?

2002-01-09 Thread Jason Wong
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:

Re: [PHP-DB] Please help, On phpnuke and phpgroupware.

2002-01-10 Thread Jason Wong
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

Re: [PHP-DB] Please help, On phpnuke and phpgroupware.

2002-01-10 Thread Jason Wong
of 4.1.1. Read the changelog for 4.1.1 to see what's added and fixed. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* Let's not complicate our relationship by trying to communicate with each other. */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL

Re: [PHP-DB] Please help, On phpnuke and phpgroupware.

2002-01-10 Thread Jason Wong
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

Re: [PHP-DB] MySQL Result Resource

2002-01-10 Thread Jason Wong
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

Re: [PHP-DB] GROUP BY MONTH(DateBilled) misses an entry consistently

2002-01-11 Thread Jason Wong
= 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

Re: [PHP-DB] 2D array into mySQL DB

2002-01-11 Thread Jason Wong
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

Re: [PHP-DB] processing data from mysql queries with php

2002-01-11 Thread Jason Wong
must use some sort of a loop to process it, but I do not know if this is the correct solution or not. You need to use eval(), to evaluate a string as PHP code. hth -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* I'd love to go out with you, but there are important world issues

Re: [PHP-DB] LIMIT and get_num_rows

2002-01-14 Thread Jason Wong
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

Re: [PHP-DB] LIMIT and get_num_rows

2002-01-14 Thread 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

Re: [PHP-DB] Problem with mail function

2002-01-14 Thread Jason Wong
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

Re: [PHP-DB] passing variable through an html email

2002-01-15 Thread Jason Wong
= ' 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

Re: [PHP-DB] Logicproblem in WHERE statement

2002-01-15 Thread Jason Wong
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

Re: [PHP-DB] Logicproblem in WHERE statement

2002-01-16 Thread Jason Wong
may want to use DISTINCT as well. ok... you are right... but this error (duplicated rows) just can be possible if you are selecting several tables, the data rows are not unique, or you are making some kind of join Ah yes, I forgot we're only using a single table here sheepish grin -- Jason

Re: [PHP-DB] enter key?

2002-01-17 Thread Jason Wong
. -- 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

Re: [PHP-DB] enter key?

2002-01-17 Thread Jason Wong
on the value of the submit button your code wouldn't work. AFAIK Opera does the 'right' thing and sends everything when you press enter to submit the form. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* The sweeter the apple, the blacker the core -- Scratch a lover

Re: [PHP-DB] Variable search help still needed - sorry :-(

2002-01-18 Thread Jason Wong
,$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

Re: [PHP-DB] strange link problem to a database item

2002-01-19 Thread Jason Wong
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

Re: [PHP-DB] Variable search help still needed - sorry :-(

2002-01-19 Thread Jason Wong
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

Re: [PHP-DB] Mysql-class

2002-01-20 Thread Jason Wong
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

Re: [PHP-DB] Easy way to calculate difference between two dates

2002-01-20 Thread Jason Wong
). -- 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

Re: [PHP-DB] Mysql-class

2002-01-21 Thread Jason Wong
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

Re: [PHP-DB] query problem

2002-01-21 Thread Jason Wong
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

Re: [PHP-DB] displaying images

2002-01-23 Thread Jason Wong
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

[PHP-DB] Re: [PHP] Creating a pdf document

2002-01-24 Thread Jason Wong
://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

Re: [PHP-DB] Sum Columns

2002-01-25 Thread Jason Wong
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

Re: [PHP-DB] PHP safe mode

2002-01-27 Thread Jason Wong
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

Re: [PHP-DB] mysql_insert_id - link_identifier

2002-01-28 Thread Jason Wong
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

Re: [PHP-DB] session_registered variable problem

2002-01-28 Thread Jason Wong
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

Re: [PHP-DB] session_registered variable problem

2002-01-28 Thread Jason Wong
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

Re: [PHP-DB] session_registered variable problem

2002-01-28 Thread Jason Wong
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

Re: [PHP-DB] session_registered variable problem

2002-01-28 Thread Jason Wong
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

Re: [PHP-DB] session_registered variable problem

2002-01-29 Thread Jason Wong
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

Re: [PHP-DB] multiple pages for large result sets

2002-01-29 Thread Jason Wong
=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

Re: [PHP-DB] 2 Questions... INSERT and searching records....

2002-01-31 Thread Jason Wong
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

Re: [PHP-DB] Help needed on point system

2002-02-01 Thread Jason Wong
it would be to have a last_updated field. When user logs in, last_updated is checked, if it's earlier than today then update it and add 1000 points to the user. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* One expresses well the love he does not feel. -- J.A. Karr

Re: [PHP-DB] Automating Date in mySQL

2002-02-03 Thread Jason Wong
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

Re: [PHP-DB] Search results

2002-02-06 Thread Jason Wong
$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

Re: [PHP-DB] Search results

2002-02-06 Thread Jason Wong
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

RE: [PHP-DB] Search results

2002-02-06 Thread Jason Wong
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

Re: [PHP-DB] Converting upper case letters to lower case because of db??

2002-02-07 Thread Jason Wong
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

  1   2   3   4   5   6   7   >