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

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 s

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

egory_user_rights" contains: username, category_ID How do I pull everything out of "categories" that a given user DOES NOT have rights to? ie. every record from "categories" that does not have a record in "category_user_rights" linking it to a u

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

ategory_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] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

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

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?

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

RE: [PHP] MySQL problem

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]

[PHP] MySQL problem

er of times each has 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 cont

RE: [PHP] Multipe Tables, Single Query Problem

.ID=videoID, and videos.ID = 20; ? > > But in just want one row? You could return all the names 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 coul

[PHP] Multipe Tables, Single Query Problem

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

[PHP] All URL's calling one script

) 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/) To

[PHP] PATH_INFO at document root

the PHP script does this: 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/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e

[PHP] Finding the records that are NOT linked

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