[PHP-DB] Joining two talbes

2003-03-23 Thread Jeremi Bergman
Can someone help me understand joining tables, and how I can do this: SELECT clients.business_name, details.quoted_price, details.finish_date FROM clients, details WHERE clients.client_id = details.client_id =" . $HTTP_GET_VARS['id']; Can I do that? thx -- PHP Database Mailing List (http://w

RE: [PHP-DB] Insert Date

2003-03-16 Thread Jeremi Bergman
Thank you, How would I do the insert statement in php using a date() or now() function? -Original Message- From: John W. Holmes [mailto:[EMAIL PROTECTED] Sent: Saturday, March 15, 2003 4:13 PM To: 'Jeremi Bergman'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Insert Date &g

[PHP-DB] Insert Date

2003-03-14 Thread Jeremi Bergman
I'm having problem inserting the date into my mysql database. What type of field should my date field be? How do I insert that into a database, the current date for example? "INSERT INTO tblDate (fldDate) VALUES (" . Date() . ")"; Thanks for you help in advance! Jeremi -- PHP Database Mailin

RE: [PHP-DB] redirect

2003-03-01 Thread Jeremi Bergman
Nevermind, I found the answer, and why it wasn't working. Now I was wondering how I can format a number to be a currency? Like if $totalprice = 14.343 have it print 14.34. thanks -Original Message- From: Jeremi Bergman [mailto:[EMAIL PROTECTED] Sent: Saturday, March 01, 2003 2:

[PHP-DB] redirect

2003-03-01 Thread Jeremi Bergman
How can I redirect a user to a specific page if they are already "authenticated"? if ($SESSION_Authenticated) { //code here to redirect; } thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php