[PHP] MySQL error... but it works!!??

2002-01-05 Thread Simon Kimber
Does anyone have any idea why this is giving me a Warning: Supplied argument is not a valid MySQL result resource in... error? The funny thing is that apart from that error message it works perfectly!! --- $crdate = date(Y-m-d); $result = mysql_query(SELECT * FROM sites

[PHP] How do i retrieve the records that are NOT linked?

2001-10-20 Thread Simon Kimber
be greatly appreciated! Thanks! Simon Kimber -- PHP General 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] How do i retrieve the records that are NOT linked?

2001-10-20 Thread Simon Kimber
rights to? ie. every record from categories that does not have a record in category_user_rights linking it to a username such as fred Any help on this would be greatly appreciated! Thanks! Simon Kimber -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED

RE: [PHP] Is CRON'd PHP script already running?

2001-09-21 Thread Simon Kimber
How do i do that exactly? Cheers Simon -Original Message- From: Richard Heyes [mailto:[EMAIL PROTECTED]] Sent: 20 September 2001 18:38 To: [EMAIL PROTECTED] Subject: RE: [PHP] Is CRON'd PHP script already running? ...in perl check to see if the process is already running, and if

[PHP] Is CRON'd PHP script already running?

2001-09-20 Thread Simon Kimber
Hi All, I have a PHP script that i want to run every few minutes (via cron) but I only want it to run if it isn't already running. Is there something in cron itself to solve this or is there a way within PHP to detect that another instance of the current script is running and if so exit the new

[PHP] MySQL problem

2001-07-04 Thread Simon Kimber
occurred, even if it's zero times... they don't need to be listed in any particular order... Cheers Simon Kimber -- PHP General 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

RE: [PHP] MySQL problem

2001-07-04 Thread Simon Kimber
Sorry!!! I'm stupid! I forgot to mention that the list of causes has to be for a specified accident_report.weekending Cheers Simon -Original Message- From: Don Read [mailto:[EMAIL PROTECTED]] Sent: 04 July 2001 23:21 To: Simon Kimber Cc: [EMAIL PROTECTED] Subject: RE: [PHP

RE: [PHP] Multipe Tables, Single Query Problem

2001-06-19 Thread Simon Kimber
in one row (I think) using MySQL (I assume?) string functions... I have a funny feeling you need a sub select, which mysql doesn’t support... Ray, I have a funny feeling you could be right :o( Cheers Simon Kimber Funny.co.uk - The Comedy Portal http://www.funny.co.uk/ Now Incorporating: The UK

[PHP] Multipe Tables, Single Query Problem

2001-06-18 Thread Simon Kimber
. with all the actor names in one field... is this possible? or do i have to get the video data first and then the actors separately? Simon Kimber Funny.co.uk - The Comedy Portal http://www.funny.co.uk/ Now Incorporating: The UK Live Comedy Directory FREE promotion for UK Comedy Acts and Venues http

[PHP] All URL's calling one script

2001-05-24 Thread Simon Kimber
) Cheers Simon Kimber Funny.co.uk - The Comedy Portal http://www.funny.co.uk/ Now Incorporating: The UK Live Comedy Directory FREE promotion for UK Comedy Acts and Venues http://www.funny.co.uk/uklive/ eml. [EMAIL PROTECTED] icq. 16156911 -- PHP General Mailing List (http://www.php.net

[PHP] PATH_INFO at document root

2001-05-11 Thread Simon Kimber
then the PHP script does this: ? include ($DOCUMENT_ROOT . / . $SERVER_NAME . $PATH_INFO); ? So the question is, how do i get one script called no matter what comes after the root slash, and pass that info to the script? Cheers Simon Kimber -- PHP General Mailing List (http://www.php.net

[PHP] Finding the records that are NOT linked

2001-04-18 Thread Simon Kimber
D,clientIP,datestamp). Can anyone help me write a SQL query to pull out all the sites in link_sites that are not mentioned in link_stats.. ie the ones that have never been clicked.. Cheers Simon Kimber Funny.co.uk - The Comedy Portal http://www.funny.co.uk/ -- PHP General Mailing List (http://w