[PHP] PHP no longer logging errors - found them!

2001-06-21 Thread Jeff Armstrong
Little Bo jeff has lost his logs, and doesn't know where to find them! Fix up the conf and they will come home dragging their hints behind them! I moved some php config values into httpd.conf so that I could manage my virtual sites better (e.g. phpMyAdmin needs globals) and assumed that

[PHP] PHP no longer logging errors

2001-06-21 Thread Jeff Armstrong
PHP appears to no longer be logging errors: My php.ini is unchanged: error_reporting = E_ALL display_errors = On display_startup_errors = On log_errors = On error_log = /var/log/apache/php.log Over the last few days, whenever I had a syntax error in my scripts, I was getting segmentat

RE: [PHP] Date subtraction

2001-03-23 Thread Jeff Armstrong
Do it in MySQL = Fast Don't fiddle in PHP = waste of your time. Look into the following: select UNIX_TIMESTAMP(date1)-UNIX_TIMESTAMP(date1) as diff_secs, TO_DAYS(date1)-TO_DAYS(date1) as diff_days, PERIOD_DIFF(date1,date2)as diff_months, YEAR(dat

RE: [PHP] sql problem

2001-03-23 Thread Jeff Armstrong
Not sure what you are trying to do? Not sure what a Persal is (maybe an Arial?) Perhaps you want: select E.empname from employer E, badclient B where E.employercode = B.employercode and E.pesal='$Persal' Note there are two tables given aliases of E and B that are JOINED by the first c

RE: [PHP] Sorry....sessions ... again...with code...

2001-03-23 Thread Jeff Armstrong
I have tried you code and cannot see any real problem? This is what I see happening: 1 one.php creates a session and sets the value of $a to 'a' 2 click on 2 and you get to two.php with the value set to 'a' 3 click on OFF and you get to off.php where the value is unset 4 click back and y

RE: [PHP] URIs as variables

2001-03-22 Thread Jeff Armstrong
Instead of using a HIDDEN form field (I assume you don't use this in any client side javascript), why not just use a session variable. Add this to the top of the relevant pages using include: You can then use $sesh[url] in any php block to find what this value was set to on the first page. Reg

RE: [PHP] files with html extension

2001-03-22 Thread Jeff Armstrong
: Jeff Armstrong Cc: [EMAIL PROTECTED] Subject: Re: [PHP] files with html extension Jeff Armstrong wrote: > This is exactly why http://www.w3.org recommend that you DONT > SPECIFY A FILE TYPE TYPE in your HREFs. But doth that actually work - how many web servers are able to handle this t

RE: SV: [PHP] Booking by Date/Time in mySQL

2001-03-22 Thread Jeff Armstrong
Jon, not sure if I agree with you: locking - almost always a bad idea, atomicity is much faster and safer and usually indicates a better relational design. SQL is fundamentally set oriented, but newbies are almost always row oriented. mySQL locks table automagically, but it doesn't do ro

RE: [PHP] trim string - try array/join()

2001-03-22 Thread Jeff Armstrong
You have a hidden issue with the extra trailing comma. When I want a list of things, I prefer this approach: $db = mysql_select_db("tkenet_db"); $query = "SELECT app_name,status FROM approval_list where doc_no='6'"; $result = mysql_query($query,$db); $ccs=array(); while( $data = mysql_fetch_row(

RE: [PHP] Ack! Cookie Problems!

2001-03-22 Thread Jeff Armstrong
Why not just set the session start time in a session variable and then test against that? Something like: session_start(); # This array contains all the session items if (!isset($sesh)) { $sesh = array(); session_register('sesh'); $sesh[start] = time(); } if ( $PHP_SELF == '/login') { if

RE: [PHP] How to delete a row from MySql

2001-03-22 Thread Jeff Armstrong
curious of Hither Green writes: > printf("(DELETE)", $PHP_SELF, $myrow["id"]); Is there a reason why you're not using interpolation? This looks simpler to me, and I thought that a lot of effort went into optimising PHP interpolation. echo "Delete $myrow[id]"; cheers, Jeff -Original M

RE: [PHP] Sessions help please

2001-03-21 Thread Jeff Armstrong
Apologies for the long post. I use this approach: (simplified) at the top of every page, before any HTML. Pop it into an include right at the top. I have not included all the util function e.g. LogQuietAlert() regards Jeff "); gotoPage("/login"); } } #===

FW: [PHP] can you have two sql statements on the same page.

2001-03-21 Thread Jeff Armstrong
Matt, > put two sets of data in the same while loop... If there is some logical relationship between the sets of records then consider adding a join: $sql = "select club_full_name,message,messate_title " " from clubs,noticeboard " " where clubs.club_name = noticeboard.club_na

RE: [PHP] files with html extension

2001-03-20 Thread Jeff Armstrong
I agree with Phill, don't make all your HTML into PHP unless you aint got much - but hey if you aint got much then you can fix the real problem! soapbox: { The issue here seems to derive from the fact that all the internal HREFs point to xxx.html This is exactly why http://www.w3.org recommen

RE: SV: [PHP] Booking by Date/Time in mySQL

2001-03-20 Thread Jeff Armstrong
aranteed safe, as you can end up with double bookings in the pico seconds between the select and the insert - but hey, how many hits a second do you expect. Regards Jeff's Granny -Original Message----- From: Thomas Edison Jr. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 5:08

RE: SV: [PHP] Booking by Date/Time in mySQL

2001-03-20 Thread Jeff Armstrong
One problem is that you are only checking the first booking. select * from booking where room='room' gives ALL bookings, and you look like you are just testing the FIRST one. why not turn it round and do: select * from booking where ('$start'>=startdate and '$start'<=enddate) or ('$en

RE: [PHP] Query - Grouping Results

2001-03-19 Thread Jeff Armstrong
how about something like select distinct name, date_format(time, "%W %D %M %Y") as login from users, user_logins where user_logins.user_id = users.id order by name,time -Original Message- From: Jordan Elver [mailto:[EMAIL PROTECTED]] Sent: Monday, March 19, 20

RE: [PHP] Re: Privilege system of Mysql...

2001-03-19 Thread Jeff Armstrong
The easiest way to do this is to use phpMyAdmin. Go to the mysql database on your server Insert a record into the table called 'user' * enter appropriate value for host (localhost or %) * fill in user name * when entering password, select the PASSWORD function from the pulldown and enter the p