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

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

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

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

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

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

[PHP-DB] PHP form to search MySQL DB

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

[PHP-DB] PHP MySQL Queries...

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

[PHP-DB] PHP query on date field

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

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

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

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

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

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

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

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

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

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

. =) 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

[PHP-DB] MySQL/PHP Update

I'm trying to update my MySQL database, but it doesn't seem to be taking. my code is: mysql_query(update prod_list set prod_manu=$prod_man where sku='$prod'); where prod_manu is an int $prod_man is an int sku is a varchar $prod is text mysql_query() comes back successful, and

RE: [PHP-DB] MySQL/PHP Update

Actually... this turned out to be something totally unrelated. Thanks for all the interest tho. Missing little things like variable spelling is why you shouldn't code for 18 hours straight. Jason Cathcart Check Out My Site: http://www.biohazardous.org -Original Message- From: Rick

RE: [PHP-DB] retrieve enum values

= mysql_fetch_row($result)) { $enumVal = $row[0]; $name= $row[1]; Print option value=\$enumVal\$name/option; } ? /select Hope that speaks to your question. Jason -Original Message- From: mel list_php [mailto:[EMAIL PROTECTED] Sent: Thursday, April 14, 2005 5:54 AM To: php-db@lists.php.net Subject

Re: [PHP-DB] Limited connections to the database. .

Norland, Martin wrote: http://www.google.com/search?q=oracle+limit+client+connections http://www.oracle.com/technology/pub/articles/php_experts/scaling_oracle _and_php.html Summary - either you're not using persistent connections, or your site is just very busy. If it's just that the site is

Re: [PHP-DB] Limited connections to the database. .

Sorry, I should've replied to your post first, but, have you tried manually limiting the connections via PHP? Code used from Omega Engine (Copyright Omega Vortex): $ini_data = $engine-ini_data['file']; setup_errors(); if ($ini_data['DB']['connections'] 5) { $engine-error = There are too

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

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

Re: [PHP-DB] php/mysql

, 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] php, netscape and sybase

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] What is the life time of mysql connection if I use pconnect()

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

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

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

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

[PHP-DB] PHP Licencing vs Zend Licencing

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] mysql grant problem?

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

Re: [PHP-DB] SQL Select?

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] ALTER TABLE - code not working.

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.

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] Fatal error: Call to unsupported or undefined functi on mysql_connect()

"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] How to back up database..... ?

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

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

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

? 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] Need php page to upload files

, -- .--- .- ... --- -. / -- --- .-. . --- ..- ... . 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

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

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] mp3 upload????

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

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

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

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] Sql result loop problem !

= 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] Extracting enum/set values from database

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

Re: [PHP-DB] Variable Variables in PHP

. -- 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] Modify Query, or sift through results?

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

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

? 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

;; } = 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

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] Update info from form to MySQL. No error but no Update

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

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

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

(); 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!

. 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

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 development with PostgreSQL

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] Postgres and php shell scripting

, 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/mySQL and INSERT statements

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?

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]

[PHP-DB] Pleazzzzzz Help.

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] Use the User Input Critia as part of Query! (Mysql)

; 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

, 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...

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

[PHP-DB] update low_priority

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] order by question

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

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!

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!

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

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

) 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??

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] How to Replace the table data

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

[PHP-DB] Cookies ???

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.

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

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

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

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

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

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

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

, $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?

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

. 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

[PHP-DB] HTTP_SESSION_VARS Question

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.

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

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

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

/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

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

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_fetch_array() doesn't work

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] Re: mysql_fetch_array() doesn't work

'].\ 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

); } ? -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] Cybercash? or Who?

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?

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?

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

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

-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

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

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

-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

-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

, 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] keys in mysql

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

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

)) { $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

[PHP-DB] Re: Html email

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

  1   2   3   4   5   6   7   8   9   >