[PHP-DB] Re: PHP and MySQL queries...

2001-10-23 Thread Jason Wood
I'm not positive, but try switching the day and month fields. ie: 28/04/1981 for April 28th, 1981 instead of 04/28/1981 Could work... I know alot of programs, etc, use this format, and I cant remember offhand right now. Let me know if it works for you!! -- Jason Wood Chief Technology

[PHP-DB] Re: Formating TimeStamp

2001-10-18 Thread Jason L. West
Thanks for all of the input. Here is the solution that I finally went: DATE_FORMAT(v_date, '%b %e, %Y') AS v_date v_date being the column name. -- Jason L. West, Sr. Web Architect SalesTek Inc. Jason [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... DATE_FORMAT is a MySQL

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] 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] Check Boxes/UPDATE

2001-10-03 Thread Jason Wong
-Original Message- From: Jason G. [mailto:[EMAIL PROTECTED]] Sent: 03 October 2001 12:12 To: Matt C; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Check Boxes/UPDATE Matt, Assuming that you have a variable number of records being displayed out of the database: As you write out the HTML

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

[PHP-DB] Cybercash? or Who?

2001-10-02 Thread Jason Caldwell
if it was a better deal than CashRegister... not that it matters anymore :-) I'm basically looking to not get raped with Merchant and Monthly fees... but still get a good, quick and reliable processing package. Thanks. Jason [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net

[PHP-DB] HTML or PHP?

2001-10-02 Thread Jason Caldwell
I have a problem that seems like it should be a snap to fix, but leaves me feeling frustrated to no end... I have a table (HTML) -- 2 Columns. In the right-hand column I store a URL (ie. http://someonesdomainname.com/path/anotherpath/file.html) The problem is -- when I pull the URL in -- it

[PHP-DB] PayFlowPro?

2001-10-02 Thread Jason Caldwell
How can I get Versign's PayFlowPro to work with PHP? I'm using Win2k version. Thanks. Jason [EMAIL PROTECTED] -- 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

Re: [PHP-DB] Check Boxes/UPDATE

2001-10-02 Thread Jason G.
set the authstat= 0 $authstatus = (isset($$sCheckName) ? 1 : 0); //Update the database mysql_query(UPDATE table SET authstatus=$authstatus WHERE id=$oRow-id); } ? -Jason Garber www.IonZoft.com At 03:22 AM 10/3/2001 +0100, Matt C wrote: I have

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] problem with WHILE loop

2001-09-30 Thread Jason G.
); } ? -Jason Garber www.ionzoft.com * I prefer mysql_fetch_object() personally... Replace the code with this: ?php $dbResult = mysql_query(select id,title from table1); $nRowCount = mysql_num_rows($dbResult); for($i=0; $i

[PHP-DB] Re: username/password db query

2001-09-30 Thread Jason
you may want to try this if ((strcmp($username,$myrow[0])==0) (strcmp($password,$myrow[2])==0)) instead of if ($username==$myrow[0] $password==$myrow[2]) You may also want to change your select query: $query = SELECT Password FROM userinfo WHERE Username='$username'; then change your

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

2001-09-27 Thread Jason G.
as much as possible. Any questions, please ask me. -Jason Garber Lead Programmer - www.pulseaday.com [EMAIL PROTECTED] At 12:48 PM 9/27/2001 +0800, you wrote: System: PHP4.06 + Mysql3.23.41 Win32 + Apache 1.3.20 Win32 + Win98 When PHP is running at the line: $arr=mysql_fetch_array($res); The IE

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] 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

[PHP-DB] HTTP_SESSION_VARS Question

2001-09-24 Thread Jason Caldwell
to just the var it works fine. $s_myvar = 1; Thanks. Jason -- 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]

[PHP-DB] Solved! -- Buuuuttt.

2001-09-24 Thread Jason Caldwell
In the PHP.INI file I had to set REGISTER_GLOBALS = off The Vars are registering -- but not with an INCLUDE file or FUNCTION plus, my INPUT tag data (vars) aren't coming over... What the #%#^ is go'in? Very frustrating any help would be greatly appreciated. Thanks Jason Jason

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] INSERT prob

2001-09-22 Thread Jason Wong
. In fact putting *anything* between the square brackets produces the same result!! */ Are you able to help me out any further here? Many thanks for your efforts thus far Jason. Russ Russ, sorry I got my $key and $val mixed up in my original reply. Here's some tried and tested code: $user[0][Name

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] How to make it case sensitive?

2001-09-21 Thread Jason Stechschulte
) binary -- Jason Stechschulte [EMAIL PROTECTED] -- I think it's a new feature. Don't tell anyone it was an accident. :-) -- Larry Wall on s/foo/bar/eieio in [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

Re: [PHP-DB] MySQL Update Logging ???

2001-09-20 Thread Jason G.
Check out for MySQL mailing lists http://www.mysql.com/documentation/lists.html -JAson Garber At 03:42 PM 9/20/2001 -0500, Christopher Raymond wrote: NOTES: I know this is a PHP list, but I also know that many of you are experienced MySQL admins. In addition, I was unable to find a MySQL

Re: [PHP-DB] Searching/keywords

2001-09-20 Thread Jason G.
for more info... -Jason Garber Lead Programmer - pulseaday.com At 12:25 AM 9/21/2001 +0100, Matt C wrote: I have summaries of episodes stored in a database. How on earth do I go about highlighting keywords? I mean I have done a search and it gives a list of urls: episodes.php?id=4highlight

Re: [PHP-DB] Renaming a database name...

2001-09-19 Thread Jason Stechschulte
the old database to the new database. -- Jason Stechschulte [EMAIL PROTECTED] -- Beauty? What's that? -- Larry Wall in [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED

[PHP-DB] Cookies ???

2001-09-17 Thread Jason Caldwell
store these in an Array, or can I create multiple cookies -- in other words, a cookie can only store one value, correct? So, I can use Serialize / Unserialize to store Array information in my cookies? Thanks. Jason -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail

[PHP-DB] Re: NEED HELP WITH ORACLE PHP PLZ.

2001-09-17 Thread Jason Holmberg
Brian, How did you configure PHP (ie what was your ./configure string?). I am having trouble even getting PHP set up to where it even recognizes the Oracle functions. When I try to execute a script similar to what you have written all I get is 'function undefined.' Thanks, Jason On 9/13/01

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] 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] 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

[PHP-DB] eregi and ereg??

2001-09-13 Thread Jason Caldwell
understand the format as displayed above, then I should be able to put multiple variables in the EREG(I) expression... like so; if(eregi(x, $string1 $string2 $string3, $regs) Is this correct? Or, do I have to specify an IF...THEN type of statement for each $STRING ?? Thanks Jason [EMAIL

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] 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

[PHP-DB] update low_priority

2001-09-10 Thread Jason Dulberg
I suppose this is more of a mysql question but if I have a lot of people viewing a page that the admin is in the process of updating, should I use UPDATE LOW_PRIORITY? Just wondering if that would rule out any potential problems. Thanks. __ Jason Dulberg Extreme MTB http

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] 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

[PHP-DB] Pleazzzzzz Help.

2001-08-29 Thread Jason Brashear
How do I creat a form that submits the collected information to a databas (MySQL) And email a template to the submitter with the collected information and to a few other parties based on seprate templates for the E-Mail? Please help... -Jason [EMAIL PROTECTED] -- PHP Database Mailing List

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] How to delete specific row in mysql table?

2001-08-28 Thread Jason Brooke
probably consult an SQL reference jason -- 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] Postgres and php shell scripting

2001-08-27 Thread Jason Brooke
, John you mightn't have compiled pgsql support into your php binary jason -- 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] PHP development with PostgreSQL

2001-08-24 Thread Jason Brooke
This seems more like a problem in database design like in the database itself. yves how come? -- 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] 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] 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] 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] 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] 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] 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] 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] delay script

2001-06-29 Thread Jason k Larson
Or perhaps it did. = ) Sorry - I guess CC-ing the message list doesn't work. -- 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] FW: strange numbers in link

2001-06-28 Thread Jason k Larson
Shawna, Feel free to change this value, it doesn't appear to bear any significance and is probably a typo. Jason k Larson [EMAIL PROTECTED] wrote in message BB6D932A42D6D211B4AC0090274EBB1D2EEE87@GLOBAL1">news:BB6D932A42D6D211B4AC0090274EBB1D2EEE87@GLOBAL1... Our website uses mysql

Re: [PHP-DB] How do I keep the values of objects when refreshing page?

2001-06-28 Thread Jason k Larson
Please be more specific. Hector M Banda [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi all, My page is getting the values and the submits itself displaying the information but the original selection is gone showing the objects with no info. Thanks,

Re: [PHP-DB] delay script

2001-06-28 Thread Jason k Larson
You may find that the HTML meta tag can help you there. -- 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] delay script

2001-06-28 Thread Jason k Larson
sorry so brief earlier .. anyway this is a working sample meta http-equiv=refresh content=5;url=http://www.php.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

Re: [PHP-DB] static or dynamic printer-friendly webpages?

2001-06-28 Thread Jason k Larson
the proper plug-ins for their browsers (a bit of a headache, if you asked me, but can none the less be done). Good Luck! Jason k Larson -- 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 errors .... or php errors ????

2001-06-28 Thread Jason k Larson
). One might decide to resolve these errors once and for all by applying single or double quotes on all named Array indexes. For the short term you may look into error_reporting() in php. Jason k Larson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL

Re: [PHP-DB] Modify Query, or sift through results?

2001-06-28 Thread Jason Stechschulte
will be returned. -- Jason Stechschulte [EMAIL PROTECTED] -- If you're going to define a shortcut, then make it the base [sic] darn shortcut you can. -- Larry Wall in [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED

Re: [PHP-DB] MySQL Error???

2001-06-28 Thread Jason Stechschulte
negative numbers in the column. This can be done easily from the mysql client: alter table your_table modify your_column smallint unsigned; -- Jason Stechschulte [EMAIL PROTECTED] -- /* This bit of chicanery makes a unary function followed by a parenthesis into a function with one argument, highest

Re: [PHP-DB] Extracting enum/set values from database

2001-06-27 Thread Jason Stechschulte
, , $table[Type])); } elseif($table[Field] == $column $columnType == set) { return explode(,, preg_replace(/^set\(|'|\)/i, , $table[Type])); } } } ? -- Jason

Re: [PHP-DB] Variable Variables in PHP

2001-06-27 Thread Jason Stechschulte
. -- Jason Stechschulte [EMAIL PROTECTED] -- It's the Magic that counts. -- Larry Wall on Perl's apparent ugliness -- 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] Sql result loop problem !

2001-05-18 Thread Jason Stechschulte
= mysql_fetch_array($result)) { if($p[s_bereich_name] != $oldBereichName) { echo $p[s_bereich_name].br\n; $oldBereichName = $p[s_bereich_name]; } echo $p[s_news_text]. - .$p[s_users_real_name].br\n; } ? -- Jason Stechschulte [EMAIL PROTECTED] -- If I allowed next $label then I'd also have

Re: [PHP-DB] php - MSSQL

2001-05-14 Thread Jason Stechschulte
On Mon, May 14, 2001 at 12:11:17PM +0200, Dragan Dinic wrote: Hi there. Hi. Is there any possible way to connect PHP (running on apache 1.3.12 on Red Hat Linux 7) with Microsoft SQL server (running on Windows 2000) ? Yes -- Jason Stechschulte [EMAIL PROTECTED] -- Perl itself is usually

Re: [PHP-DB] Cookie effect

2001-05-12 Thread Jason Brooke
David problem is, the cookie only comes into effect after I've clicked thru to another page from login.php...any ideas on this? Sure - it's because of the way the http protocol works. If you've just set a value in a cookie, why do you need to read the cookie back in order to check the

Re: [PHP-DB] Backup Database

2001-05-11 Thread Jason Stechschulte
On Fri, May 11, 2001 at 10:02:41AM +0800, Jennifer Arcino Demeterio wrote: what will i do to have a realtime backup of my database? It would help to know which database you are using. -- Jason Stechschulte [EMAIL PROTECTED] -- Your csh still thinks true is false. Write to your vendor today

Re: [PHP-DB] mp3 upload????

2001-05-04 Thread Jason Stechschulte
is not the format type What should I do? Please help. I will be very appreciate. Print out $imgfile_type to see what it is. -- Jason Stechschulte [EMAIL PROTECTED] -- No, I'm not going to explain it. If you can't figure it out, you didn't want to know anyway... :-) -- Larry Wall

Re: [PHP-DB] newbie: showing records from SQL

2001-05-01 Thread Jason Stechschulte
of information, and refer to the other website for more information... Have you even tried looking yourself?? The page below has many links to examples, tutorials, and many other useful things. http://www.php.net/links.php -- Jason Stechschulte [EMAIL PROTECTED] -- The way these things go

Re: [PHP-DB] Need php page to upload files

2001-04-23 Thread Jason Morehouse
, -- .--- .- ... --- -. / -- --- .-. . --- ..- ... . Jason Morehouse [EMAIL PROTECTED] Netconcepts LTD Auckland, New Zealand -- 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

[PHP-DB] Filemaker w/PHP on Linux?

2001-04-22 Thread Jason Lam
? I have such a hard time finding this driver Does it exist? Do I even need a driver on Linux since FM on Mac has ODBC driver? Jason Lam -- 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] MySQL Question

2001-04-18 Thread Jason Stechschulte
searched the archives @ http://www.mysql.com/documentation/searchlists.html As well as simply looking on the site @ http://www.mysql.com -- Jason Stechschulte [EMAIL PROTECTED] -- Randal said it would be tough to do in sed. He didn't say he didn't understand sed. Randal understands sed quite well

Re: [PHP-DB] How to back up database..... ?

2001-04-16 Thread Jason Stechschulte
On Mon, Apr 16, 2001 at 12:40:05AM +0800, E K L wrote: Hi all, Is there anyone can tell me how to back up Mysql database from one server to other server? Please advisethanks backup to zip: mysqldump --add-drop-table -u root -ppass database | gzip /dir/database.gz -- Jason

RE: [PHP-DB] Fatal error: Call to unsupported or undefined functi on mysql_connect()

2001-04-05 Thread Jason Vance
"Call to undefined function" means it doesn't know the name of the function you are calling. Hi there, i've had this error as well, using Redhat Linux 7.0. For me, i'm using the RPM's to install apache+PHP+MySQL, however, the php-mysql add-on module is unable to recognize the dependant module

Re: [PHP-DB] ALTER TABLE - code not working.

2001-03-29 Thread Jason Stechschulte
mysql is returning. This has helped me find something strange with what I was doing when I could have sworn there was nothing wrong with my code. -- Jason Stechschulte [EMAIL PROTECTED] -- As someone pointed out, you could have an attribute that says "optimize the heck out of this routine&

Re: [PHP-DB] ALTER TABLE - code not working.

2001-03-29 Thread Jason Stechschulte
be happening. -- Jason Stechschulte [EMAIL PROTECTED] -- But you have to allow a little for the desire to evangelize when you think you have good news. -- Larry Wall in [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED

Re: [PHP-DB] SQL Select?

2001-03-27 Thread Jason Stechschulte
t = mysql_query($sql, $db) or die("$sqlbr".mysql_error($db)); ? This allows you to see the sql that is actually being executed, and you also get to see the actual mysql error. -- Jason Stechschulte [EMAIL PROTECTED] -- It is, of course, written in Perl. Translation to C is left

Re: [PHP-DB] mysql grant problem?

2001-03-26 Thread Jason Stechschulte
a question that should have been posted to a Mysql list. [EMAIL PROTECTED] -- Jason Stechschulte [EMAIL PROTECTED] -- OOPS! You naughty creature! You didn't run Configure with sh! I will attempt to remedy the situation by running sh for you... -- Larry Wall in Configure from the perl di

[PHP-DB] PHP Licencing vs Zend Licencing

2001-03-23 Thread Jason Cathcart
works, is there some point along the way, since I made money on this deal, that Zend wants cashola? __ Jason Cathcart * Web Designer * Programmer ICQ : 44065553 www.biohazardous.org

Re: [PHP-DB] How do I test on number of fields ?

2001-03-20 Thread Jason Stechschulte
ysql_link); It will show you your error in your query. -- Jason Stechschulte [EMAIL PROTECTED] -- There are still some other things to do, so don't think if I didn't fix your favorite bug that your bug report is in the bit bucket. (It may be, but don't think it. :-) Larry Wall in [EMAIL P

Re: [PHP-DB] What is the life time of mysql connection if I use pconnect()

2001-03-15 Thread Jason Stechschulte
of that apache process. -- Jason Stechschulte [EMAIL PROTECTED] -- 'Course, I haven't weighed in yet. :-) -- Larry Wall in [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL

[PHP-DB] ph and sybase

2001-03-15 Thread Jason LeDuc
Can anyone tell me where to find the commands like sybase connect and other such commands I compiled php with sybase. It didn't complain or give any errors. However the php web page still shows that sybase is not installed. -- PHP Database Mailing List (http://www.php.net/) To

[PHP-DB] php, netscape and sybase

2001-03-08 Thread Jason Leduc
I would just like to thank all of you for your help I have completed the install of php with netscape and sybase database. It was a hard road but your help made it enjoyable. Thanks again. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For

Re: [PHP-DB] php/mysql

2001-02-22 Thread Jason Stechschulte
, you can use the keywords IF NOT EXISTS so that an error does not occur if the table already exists. http://www.mysql.com/doc/C/R/CREATE_TABLE.html -- Jason Stechschulte [EMAIL PROTECTED] -- The way these things go, there are probably 6 or 8 kludgey ways to do it, and a better way that involves

[PHP-DB] Autonomous Mass Mail List System (Broadcast Email)

2001-01-10 Thread Jason Beebe
Hey Everyone, I'm working a project for one of the company's websites. they have a subscription mailing list that the user signs up their email address to receies periodical emailings. The email addresses are stored in a flat txt file. 1 email per line. I could also convert it to a coma

<    4   5   6   7   8   9