I need to run a php script with includes from a cron job on a remote (hosted) Linux server. The cron job:
Code:
/bin/sh /usr/www/users/warmsafe/event_mgr/admin/sh_scripts/cron-lynx.sh
Annalyzer
Joined: Aug 25 '07
Location:
-
cron job to run php script with includes not working
I'm not positive that my problem is with the Linux end of this, but I'm pretty sure the php end is okay, so here goes:
I need to run a php script with includes from a cron job on a remote (hosted) Linux server. The cron job:
triggers ok - it runs a bash script called cron-lynx.sh that resides in the home/warmsafe/event_mgr/admin/sh_scripts... -
Can't you use something like
SELECT *
FROM table1 INNER JOIN table2 ON table1.id=table 2.id
WHERE table1.field1 != table2.field1 OR table1.field2 != table2.field2.. .... -
Love your answer tlhintoq! My favorite website. On another note, I just finished writing an application that uses authorize.net because the customer has a Joomla-based website and the available Joomla shopping carts did not meet their needs, so I know Joomla to be a source for a shopping cart that works with authorize.net.Leave a comment:
-
Problem solved. It was actually a break missing in the part of the code I didn't give you causing lines to be interpreted that weren't relevant to the case.
Thanks for your help.Leave a comment:
-
switch case not working
My form looks like this:
...Code:<form action="handle_event.php" method="POST" enctype="multipart/form-data"> <table id="event_edit" border="0"> <tr> <td> <label for="title">TITLE: </label> </td> <td class="input"> -
Okay, so what you need to do is use the second column from worksheet one to define the offset for the vlookup. That's do-able.
First, in worksheet 2, insert a row right under the numeric values. In that row, enter the number 1 in column A, 2 in column B, 3 in column C, etc. That's what you'll use to determine the offset for the vlookup and you'll use an hlookup to do it. Now, worksheet 2 looks like this:
...Leave a comment:
-
First, let me see if I understand you correctly. Worksheet 1 looks something like this:
111 112 orange
456 789 blue
with the values in column A and B being some measure of length (inches, centimeters, etc). Then, worksheet 2 looks something like this:
111 111 green
111 112 orange
455 789 purple
456 789 blue...Leave a comment:
-
No, that would make 1 table with 20 records.Leave a comment:
-
I don't know the "right" answer here, but I would base my decision on how I was going to refer to the Battle_Ship in future code. For example, say Fred is the player and Fred has the following battlegroups: BG1, BG2, BG3, and BG4. If BG1 contains an aircraft carrier (AC), a cruiser (CR), and 2 destroyers (D1 and D2), then it would make more sense to me to write code that used BG1/AC to refer to the aircraft carrier in battlegroup 1 and...Leave a comment:
-
Atli is right. Putting the username in the asteroid table as a foreign key is a one-to-many relationship. I mispoke in my first post. Hopefully my second post explained it better.Leave a comment:
-
Ah, okay. So 1 user has many asteroids. Then, yes, the user does go into the asteroid table. The user relates to the primary key in that the user is the owner of that particular asteroid.
You don't need the table linking them together since you don't have a many-to-many relationship. If each asteroid could be owned by more than one person, then you would need to link them to show ownership.
So, it sounds to me like...Leave a comment:
-
I don't quite understand the thought behind the table linking the user to the asteroid. Does each user get their own personal asteroid?
A linking table is used to provide the solution of a many-to-many relationship. Many users (own? inhabit? destroy?) many asteroids.
If you put the username in the asteroid table, then that asteroid can only be assigned to one user creating a one-to-one relationship. Each one asteroid...Leave a comment:
-
Got it. It did have to do with referring to a value from the subform. The value I was pulling was a total in a footer on the subform. As soon as I moved it to it's own hidden subform everything worked perfectly. Thanks for your help.Leave a comment:
-
It's very simple code, really.
From the control on the search form:
...Code:Private Sub memLast_Click() On Error GoTo Err_memLast_Click Dim stDocName As String Dim stLinkCriteria As String stLinkCriteria = "hhId=" & Me.hhId DoCmd.OpenForm "frmHousehold", , , stLinkCriteria Exit_memLast_Click: Exit SubLeave a comment:
-
That explains why I was able to do it with 2 queries. I like you're solution much better, though, thank you. It's much neater.Leave a comment:
-
On Current Event not triggered
I have an intake form that is opened by clicking a control on a search form. This click runs a subroutine in the search form that uses DoCmd.OpenRepor t with stLinkCriteria.
In the intake form I have a subroutine that is set to run OnCurrent - Private Sub Form_Current().
Here's where it gets weird. When I open the intake form by clicking the control in the search form, the code does not run (the results would be visible... -
Oops! Wait a second. That gives me the total number of food boxes for each year. I need the unduplicated count of households for each year.
Anybody?Leave a comment:
-
Ohhhhhhhhhhhhh, of course! Boy do I feel dumb. I was trying to make it harder than it really was. I had the DISTINCT keyword stuck in my brain when I didn't even need it.
Thanks so much! Back on track now.Leave a comment:
-
Help with SELECT DISTINCT
I have a table that counts food boxes received by each household (hhId).
Table Name: food_box
Fields: fbId (PK), fbDate, hhId (FK)
Currently, the table holds the following data:
fbId,Date,hhId
1,1 /1 /2009,1
2,2 /1 /2009,1
3,3 /1 /2009,1
4,4 /1 /2009,1
5,5 /1 /2009,1
6,6 /1 /2009,1
7,12/1 /2008,1
8,7 /1 /2009,1
9,1 /15/2009,1... -
Thanks so much zorgi! At least I can get some work done with relative confidence that I won't have to go back and change everything. It looks to me like the company that originally built this site did pretty much everything by default. That's why the owners hired me to "fix" it.Leave a comment:
No activity results to display
Leave a comment: