[PHP-DB] refresh the page on back

2004-10-14 Thread balwantsingh
first of all excuse me for putting the non related question in this forum. but i am sure someone will help me. i want that whenever users press the browser back button, the page should be refreshed and than displayed. thanks for your help in advance. with best wishes balwant -- PHP Database

Re: [PHP-DB] refresh the page on back

2004-10-14 Thread M Saleh EG
use the cache disable headers in HTML as well as PHP for the server side headers. pick any of the two methods. 1-HTML caching control: meta http-equiv=pragma content=no-cache / meta http-equiv=cache-control content=no-cache / meta http-equiv=cache-control content=must-revalidate / meta

RE: [PHP-DB] PHP versions - Development server live server...

2004-10-14 Thread Peter Borcherds
I don't recall installing any optimising or encrypting extensions?? Are they perhaps installed with mySQL? How do I reinstall them, that is assuming I need them? -Original Message- From: M Saleh EG [mailto:[EMAIL PROTECTED] Sent: 14 October 2004 03:24 To: Peter Borcherds Cc: [EMAIL

RE: [PHP-DB] mysql error and resource ID:

2004-10-14 Thread Graham Cossey
See PHP manual Chapter 6. Types Strings for an explanation of single double quotes. From the doc: If the string is enclosed in double-quotes (), PHP understands more escape sequences for special characters But the most important feature of double-quoted strings is the fact that variable

RE: [PHP-DB] mysql error and resource ID:

2004-10-14 Thread Stuart Felenstein
Anyone see something wrong here : My error message is : 0: 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'd',1,'d',1,1, 31, 33,10/15/2004))' at line 5 Code: $query = INSERT INTO MainTable

RE: [PHP-DB] mysql error and resource ID:

2004-10-14 Thread Stuart Felenstein
Yes, actually my apologies to everyone. I figured out the error. So , yep, I'm down to a problem with the date. The column is set to date. I'll go ahead and add the quotes. Stuart --- [EMAIL PROTECTED] wrote: Stuart, The date has forward slashes. These are not integers, right? So put

[PHP-DB] Converting Date for mysql

2004-10-14 Thread Stuart Felenstein
I have one of those widget calendars. Mysql keeps throwing back the date regardless of the way I format it. I'm passing session variables over to the database and have tried quotes ' around the date as well. Now I went ahead and changed this line: $_SESSION['f3k'] = $_POST['DateAvailable'];

RE: [PHP-DB] Converting Date for mysql

2004-10-14 Thread Bastien Koert
did you look to see what the data format was? many of these calendars fill in american dates (mm-dd-) and mysql prefers (-mm-dd)check to see what the format is before you assign it to the session id... bastien From: Stuart Felenstein [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject:

Re: [PHP-DB] Generate Menu based on database structure

2004-10-14 Thread Leo G. Divinagracia III
graeme wrote: Hi, Rather than writing a recursive function I'd suggest that you create a menu class and store each record as an object of the class. why reinvent the wheel: http://www.destroydrop.com/javascripts/tree/ -- Leo G. Divinagracia III [EMAIL PROTECTED] z -- PHP Database Mailing

[PHP-DB] How to optimize select of random record in DB ?

2004-10-14 Thread -{ Rene Brehmer }-
I made this code to pick a random record from a changeable number of records in a given table. I'm just curious if any of the more awake coders out there can see a way to optimize this for better performance, since there's several other DB queries on the same page. $records =