Re: [PHP-DB] Why use MySQL with PHP

2001-11-16 Thread Sheridan Saint-Michel
the people who built www.php.net didn't make the page W3C compliant. Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com - Original Message - From: Nally, Tyler G. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 16, 2001 8:36 AM Subject: RE: [PHP-DB

Re: [PHP-DB] Why use MySQL with PHP

2001-11-15 Thread Sheridan Saint-Michel
time look some of these programs up). Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com - Original Message - From: søren eriksen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 15, 2001 2:34 PM Subject: [PHP-DB] Why use MySQL with PHP Hi

Re: [PHP-DB] Why use MySQL with PHP

2001-11-15 Thread Sheridan Saint-Michel
Tell me about it. You ever try running php.net through http://validator.w3.org ? It's not pretty. Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com - Original Message - From: B. van Ouwerkerk [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday

Re: [PHP-DB] UPDATE table1 FROM table2

2001-11-02 Thread Sheridan Saint-Michel
of the columns in table1 you don't want changed appear as temp.colname. The temp table will only exist as long as the thread does, since it was created with the temporary keyword. Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com - Original Message - From: m0sh3

Re: [PHP-DB] Embedding Perl

2001-10-24 Thread Sheridan Saint-Michel
You have to put the actual command in the exec or backticks as you would type it in your shell, not just the filename. So instead of $out = `convert-pdf.pl Blank.gif`; Try $out = `perl convert-pdf.pl Blank.gif`; Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company

[PHP-DB] MySQL Last Modified

2001-10-24 Thread Sheridan Saint-Michel
together a workaround =P Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com

Re: [PHP-DB] Howto make a double LEFT JOIN

2001-10-05 Thread Sheridan Saint-Michel
- Original Message - From: Bas Jobsen [EMAIL PROTECTED] To: Sheridan Saint-Michel [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, October 04, 2001 7:17 PM Subject: Re: [PHP-DB] Howto make a double LEFT JOIN Hello Sheridan Saint-Michel, Well it works fine, tnx!!! But now i want

Re: [PHP-DB] Auto_increment field size (was: Howto make a double LEFT JOIN)

2001-10-05 Thread Sheridan Saint-Michel
- Original Message - From: Bas Jobsen [EMAIL PROTECTED] To: Sheridan Saint-Michel [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, October 05, 2001 9:50 AM Subject: Re: [PHP-DB] Howto make a double LEFT JOIN snip ACK! Don't do this. You do know that an unsigned int (using a signed

Re: [PHP-DB] Howto make a double LEFT JOIN

2001-10-04 Thread Sheridan Saint-Michel
Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com - Original Message - From: Bas Jobsen [EMAIL PROTECTED] To: Sheridan Saint-Michel [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, October 03, 2001 2:52 PM Subject: Re: [PHP-DB] Howto make a double

Re: [PHP-DB] what's the current URL

2001-10-03 Thread Sheridan Saint-Michel
. $SCRIPT_NAME; Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com - Original Message - From: Francisco Carvalho [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 03, 2001 3:50 PM Subject: [PHP-DB] what's the current URL Is there a way for PHP

Re: [PHP-DB] old news SQL help needed

2001-10-01 Thread Sheridan Saint-Michel
Try this instead: Delete league_news FROM leagues where news_date + interval 7 day = now(); Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com - Original Message - From: Larry Linthicum [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday

Re: [PHP-DB] Storing code in a mysql database

2001-09-19 Thread Sheridan Saint-Michel
Try this eval(\$sql=\select * from vehicle where company=$company_code\;); Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com - Original Message - From: Mark Newnham [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 19, 2001 4:34 PM

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

2001-09-17 Thread Sheridan Saint-Michel
No, the only time you need a semicolon within the query string is if you are performing multiple commands. ie $query=Set @count=0; Select name,@count=@count+1 as count from people; Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com - Original Message

Re: [PHP-DB] SQL combine to summations queries?

2001-09-06 Thread Sheridan Saint-Michel
; if table1.fielda has more rows. If table2.fieldb has more rows use: Select sum(table1.fielda),sum(table2.fieldb) from table2 LEFT JOIN table1 ON table1.id=table2.id; Hope that helps Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com -- PHP Database Mailing List (http

[PHP-DB] Previous | Next (Again)

2001-08-31 Thread Sheridan Saint-Michel
(Looks like I picked the wrong day to start coding!); Get the idea? Then if they wanted to rearrange the pics, you could just swap the picnumbers of the two pics they want to swap... or do something similar to the update line above. Sheridan Saint-Michel Website Administrator FoxJet

Re: [PHP-DB] Selection an id from a table where it doesn't exisit inanother

2001-08-30 Thread Sheridan Saint-Michel
it return a list of results which are totally incorrect. Thanks Scott. Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL

Re: [PHP-DB] MD5 (' ')

2001-08-29 Thread Sheridan Saint-Michel
MD5 doesn't use a salt. http://www.faqs.org/rfcs/rfc1321.html Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com - Original Message - From: Andrey Hristov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 29, 2001 10:10 AM Subject: Re: [PHP

Re: [PHP-DB] MD5 (' ')

2001-08-29 Thread Sheridan Saint-Michel
also have not actually verified that the above script does ANYTHING =P ) Good luck. I'll let you know if I find anything specific on Debian. Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e

Re: [PHP-DB] Re: Photo Album Schema

2001-08-24 Thread Sheridan Saint-Michel
He suggested a DB redesign to allow a Many to Many relationship between users and images. I was trying to show that there was no reason to do so and at least one good reason not to do so =) Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com - Original

Re: [PHP-DB] Re: Photo Album Schema

2001-08-23 Thread Sheridan Saint-Michel
just using id.gif immediately becomes problematic as each user is, by design, going to have multiple images. I know you could add a count to id, or mangle it, or any number of other things. But that takes us back into unnecessary complexity. Sheridan Saint-Michel Website Administrator FoxJet

Re: [PHP-DB] Re: Photo Album Schema

2001-08-23 Thread Sheridan Saint-Michel
(checking to see if more than one person is associated with the image, Adding a new entry into image, changing all my info to reflect the new Image_Name) to avoid this. Therefore, I think for this project, the original DB structure works much better. Sheridan Saint-Michel Website Administrator FoxJet

Re: [PHP-DB] listing

2001-08-23 Thread Sheridan Saint-Michel
? } ? Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com - Original Message - From: Andrius Jakutis [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 23, 2001 11:22 PM Subject: Re: [PHP-DB] listing This gives 25 the same entries. I need to list

Re: [PHP-DB] listing

2001-08-23 Thread Sheridan Saint-Michel
Then you start reading =) http://www.mysql.com/doc/ Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com - Original Message - From: Andrius Jakutis [EMAIL PROTECTED] To: Rick Emery [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, August 23, 2001 11:50

Re: [PHP-DB] Photo Album Schema

2001-08-21 Thread Sheridan Saint-Michel
. Then when outputing the page just do something like echo Img src=\$queryresult['location']\; Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com - Original Message - From: Rick Emery [EMAIL PROTECTED] To: [EMAIL PROTECTED]; PHP-DB [EMAIL PROTECTED] Sent

Re: [PHP-DB] Photo Album Schema

2001-08-21 Thread Sheridan Saint-Michel
for the future. Things like FTP access, and having random pictures on the user's initial album page wouldn't be too dificult with this setup. Well, I guess that's enough rambling for one e-mail =P Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com - Original Message

Re: [PHP-DB] Photo Album Schema

2001-08-21 Thread Sheridan Saint-Michel
in the filename be alpha... which is also easily enforcable with a simple ereg. Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com - Original Message - From: Justin Buist [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 21, 2001 11:50 AM Subject: Re

Re: [PHP-DB] Photo Album Schema

2001-08-21 Thread Sheridan Saint-Michel
- Original Message - From: Hugh Bothwell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 21, 2001 12:23 PM Subject: Re: [PHP-DB] Photo Album Schema Sheridan Saint-Michel [EMAIL PROTECTED] wrote in message 036e01c12a62$22947200$[EMAIL PROTECTED]">news:036e

Re: [PHP-DB] Member authentication with PHP and MySQL

2001-08-13 Thread Sheridan Saint-Michel
to see more than metacode http://www.zend.com/codex.php?id=393single=1 And here is the header for other files on the site using the above script http://www.zend.com/codex.php?id=397single=1 Let me know if this helps Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company

Re: [PHP-DB] Member authentication with PHP and MySQL

2001-08-13 Thread Sheridan Saint-Michel
/std/cookie_spec.html I hope all that is clear. Let me know if you have any more questions Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com - Original Message - From: Cato Larsen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 13, 2001 9:06

Re: [PHP-DB] Member authentication with PHP and MySQL

2001-08-13 Thread Sheridan Saint-Michel
\ where email=\$email\; or Add to your DB sid char(32) (md5 always returns a 32 character long string) Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com - Original Message - From: Cato Larsen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, August 13

Re: [PHP-DB] Attachment

2001-08-10 Thread Sheridan Saint-Michel
guys made theirs =P If you have any specific questions let me know. Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com - Original Message - From: WNLeong [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, August 10, 2001 2:55 AM