Re: [PHP-DB] meta tag inside php / redirect / refresh

2001-03-16 Thread Marck D. Pearlstone
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Marc, On 16 March 2001 at 23:09:48 -0500 (which was 04:09 where I live) Marc Bragg wrote to [EMAIL PROTECTED] and made these points: MB Crazy after hours of syntax. How do you insert php code so that on MB different results, 1 or 0, a

Re: [PHP-DB] meta tag inside php / redirect / refresh

2001-03-16 Thread Paul Gardiner
Hi Marc, Try this - untested and I'm very sleepy, but should get you closer ;o) html head titleRefresh Test/title ?php if($check_num == 0) echo "META HTTP-EQUIV=\"REFRESH\" CONTENT=\"5;URL=http://www.chescolawyers.com/BB/index2.shtml\""; ? /head Regards, - Paul - -

[PHP-DB] Using strings

2001-03-16 Thread Vanstaen Laurent
Hi all do you know how to delete the 2 first characters of a string. I have to put a string year in a database (4 digits year) and somewhere else I need only the last two digits. How do I get them from my string "year" ? Laurent Vanstaen -- PHP Database Mailing List

Re: [PHP-DB] Website, Design, hosting and maintenance for only $999.00 per year

2001-03-16 Thread Norman Tan
Members of the list, I'd like to apologize for this and assure you that the email did NOT come from our domain nsmb.com. My headers are useless in tracking this person down, but if someone could please offer assistance off the list, please email me. Regards. [EMAIL PROTECTED] wrote:

RE: [PHP-DB] Using strings

2001-03-16 Thread Stewart Taylor
$year2 = substr($year,2,2) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 16 March 2001 09:06 To: [EMAIL PROTECTED] Subject: [PHP-DB] Using strings Hi all do you know how to delete the 2 first characters of a string. I have to put a string year in a

[PHP-DB] RE: syntax trouble

2001-03-16 Thread Rudolf Visagie
Publish first part of the php code so that we can see what's wrong in line 13 (or 12 sometimes). Rudolf Visagie [EMAIL PROTECTED] -Original Message- From: Marc S. Bragg [mailto:[EMAIL PROTECTED]] Sent: 15 March 2001 10:39 To: [EMAIL PROTECTED] Subject: syntax trouble What does this

Re: [PHP-DB] syntax trouble

2001-03-16 Thread Russ Michell
As far as I can see: What does this mean? Parse error: parse error, expecting `','' or `';'' in /http/www/b/bidattorney.com/public_html/user/stest.phtml on line 13 This means probably on line 12 you forgot a semi-colon... and so php goes on to parse the lines past where it expected a

[PHP-DB] Unix crypt

2001-03-16 Thread Vanstaen Laurent
Hi all, Do you know if the php "crypt" function really works like the unix one ?? I mean, when I compare my password on my system (crypted with unix crypt) and my password crypted with php crypt, it's not the same. And the php crypt doesn't send twice the same answer. Laurent Vanstaen --

[PHP-DB] Lost connection to MySQL server during query

2001-03-16 Thread Ireneusz Piasecki
Hi evryone ! I have folowing error during execute my php3 script. Warning: MySQL Connection Failed: Lost connection to MySQL server during query in /home/sw81/public_html/miss_wiosna_01/info.php3 on line 59 This happened somtimes. Can i do something with it ?? Ireneusz Piasecki webmaster

RE: [PHP-DB] Sessions in Functions

2001-03-16 Thread Allsebrook_Richard/askr
BDY.RTF -- 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] Unix crypt

2001-03-16 Thread omar cromwell mercado
Salt is the first two characters in a DES-encrypted password. It is used as a modifier to regularly-encrypted passwords to avoid the same encryptions for similar passwords. You must extract the salt first for your reference password, then use it as a salt to encrypt the password you want

[PHP-DB] If`s in MySQL.... Having some trouble here...

2001-03-16 Thread Trond Erling Hundal
Hi there... I want to query two tables in my db. One containing a list of numbers ranging from 1 - 10200, the other table is storing information that is relative to some of the numbers: Eks: Table1.record1: number=1 Table2.record1: number=1 name=John Now I want to query these to

Re: [PHP-DB] Unix crypt

2001-03-16 Thread fabrizio . ermini
On 16 Mar 2001, at 10:53, Vanstaen Laurent wrote: Hi all, Do you know if the php "crypt" function really works like the unix one ?? I mean, when I compare my password on my system (crypted with unix crypt) and my password crypted with php crypt, it's not the same. And the php crypt

Re: [PHP-DB] If`s in MySQL.... Having some trouble here...

2001-03-16 Thread CC Zona
In article [EMAIL PROTECTED], [EMAIL PROTECTED] ("Trond Erling Hundal") wrote: I want to query two tables in my db. One containing a list of numbers ranging from 1 - 10200, the other table is storing information that is relative to some of the numbers: Eks: Table1.record1:

Re: [PHP-DB] 2 while loops - 2 tables

2001-03-16 Thread David
It is a little hard to advise on this without knowing the table schema, but it is generally best to make the database do as much of the work as possible rather than use logic in your script because databases are specifically optimized for what they do. If I were trying to do what you are talking

[PHP-DB] dropdown menu

2001-03-16 Thread Liz Bander
Okay, maybe this is simple, but I'm at wit's end. I have a drop down menu (code follows) and I want it to show full name (i.e. John Doe) ordered by last name. Works fine under normal circumstances, but then I need it to write the email id associated with the full name to the database. It

RE: [PHP-DB] Login System with access levels

2001-03-16 Thread Ron Brogden
At 02:00 PM 3/16/2001 -0600, you wrote: First, I would NOT store passwords in a database. Rather, I'd store a hash based upon the password and username. Storing a password is dangerous as regards security. Just to be a little picky and *not* to start an argument (discussion yes), this really

Re: [PHP-DB] 2 while loops - 2 tables

2001-03-16 Thread olinux
Do you mean JOIN the tables and then SELECT? The best way to do this is to structure your SQL statement to grab both apartment and feature information into one recordset... this simplifies the code alot and makes it easier to use. Ryan Flynn Practical web development/design

[PHP-DB] dynamic columns

2001-03-16 Thread olinux
Greetings, I would like to put together a script that results similar to www.bestbuy.com 's compare feature. Basically if you are looking in an item category you can select check boxes for each item you would like to compare. The results display like this; ITEM 1 ITEM

RE: [PHP-DB] dynamic columns

2001-03-16 Thread Larry Rivera
Are the fields always the same? Ive used something similar, I usually fill an array with selection ids when while loop them into querys- To get the table I ussualy create a container table(one cell) and generate tables inside the container one for each item. -Original Message- From:

[PHP-DB] Re: [PHP] RE: [PHP-DB] Login System with access levels

2001-03-16 Thread Jack Sasportas
Just a note...you can hash the password in the database. Rick Emery wrote: First, I would NOT store passwords in a database. Rather, I'd store a hash based upon the password and username. Storing a password is dangerous as regards security. Second, if you're asking for syntax on how

RE: [PHP-DB] Login System with access levels

2001-03-16 Thread Rick Emery
First, I would NOT store passwords in a database. Rather, I'd store a hash based upon the password and username. Storing a password is dangerous as regards security. Second, if you're asking for syntax on how to add the security level column: ALTER TABLE mytable ADD access tinyint unsigned

[PHP-DB] Help with displaying rest of page after MySQL error

2001-03-16 Thread Chris Vargas
This has to be a basic question but I can't find it answered anywhere; I'm probably not searching for the right words or something. I have a page that inserts some MySQL search results in the middle of the page. My web hosting provider's MySQL uptime is spotty. I'd like the rest of the page to

Re: [PHP-DB] Help with displaying rest of page after MySQL error

2001-03-16 Thread Stuart J. Browne
My first line of PHP code (embedded in HTML) has: $db = mysql_connect("x","y","z") or die("saysomethinghere"); If I have a connection problem, it does print the "die" message and the connection error, but it also stops the page right there: no more HTML is displayed. Well, you've

[PHP-DB] SQL Mysql - Informix

2001-03-16 Thread Jon V
Any idea how to extract table names for a database in informix - like the sql for mysql SHOW TABLES; ?? J -- 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,