I have the following script which successfully finds the values for $payer_email, reminder_date and sub_expire_date, however where I am having trouble is when I apply a WHERE condition to the SELECT. The condition I am trying to apply is the commented out line at the end of the SELECT. The intention of the WHERE is to filter the values from the SELECT to only provide those values which point to the subscription expiry (sub_expire_date) thirty days ahead of time, but no values are found when they really should be. Can anyone tell me what is wrong? <?php error_reporting(E_ALL ^ E_NOTICE); …

Member Avatar
Member Avatar
+0 forum 1

Hello, how to write url alias in nginx ? I have create the url alias before in apache. But, now the web is moved to nginx. This is the url alias config (using .htaccess) that I have write in apache : RewriteEngine On # Turn on the rewriting engine RewriteBase /revive RewriteRule ^gambar/(.*)/(.*)$ www/delivery/avw.php?zoneid=$1&cb=INSERT_RANDOM_NUMBER_HERE&n=$2 I have try to write the config for the latest line in nginx using this codes, but it is failed : server { ... rewrite ^gambar/(.*)/(.*)$ www/delivery/avw.php?zoneid=$1&cb=INSERT_RANDOM_NUMBER_HERE&n=$2 last; ... } Please tell me how create url alias in nginx Thank you

Member Avatar
Member Avatar
+0 forum 1

Hi there, My question isn't strictly about programming, it's primarily a question of how to approach my problem with the tools I have. I am building a website where a user can sign up and create their own profile/portfolio so to speak. Let's say this is `mysite.com`. Say Joe Bloggs signs up so his profile/portfolio would then exist at `mysite.com/joebloggs`. Joe decides he would rather use his own domain name `joebloggs.com` for his profile/portfolio. I know that in web application I can of course check the `$_SERVER` variables to find the incoming domain, check a database mapping and act accordingly. …

Member Avatar
Member Avatar
+0 forum 1

I have a C++ program with a main routine which reads arguments from command line: int main(int argc, const char *argv[]) In my system I have defined some aliases in my bash environment which abbreviates directory names. Example: alias dst='home/username/Documents/test' alias src='home/username/Download/test' My program is called "dircopy" and I want to use the following input: `dircopy /home/username/Download/test /home/username/Documents/test` But I want to avoid writing the whole path for destination directory and source directory each time I run the program. Is there a clever way to use the alias definitions in bash when calling my "dircopy"-program ? (Example: dircopy $src $dst …

Member Avatar
Member Avatar
+0 forum 5

When using emails as usernames you want them to be unique over your table, but this can be a problem if you consider a GMail account, because of their [username](https://support.google.com/mail/answer/12096?hl=en) [policy](https://support.google.com/mail/answer/10313?hl=en). They allow: * dots * digits * letters * plus addressing text by using the `+` sign, i.e. `orange+juice@gmail.com` * length between 6 and 30 characters, excluding dots and the appended part But when resolving the username they do not consider: * dots * different capitalization * plus addressing So, when you write to: UserName@gmail.com u.sername@gmail.com user.name+forum@gmail.com .u.s.e.r.n.a.m.e.@gmail.com u.serName+doh@googlemail.com You will always match the same account: username@gmail.com This class …

Member Avatar
Member Avatar
+2 forum 1

Hi, can anyone tell me the advantages of alias name

Member Avatar
Member Avatar
+0 forum 6

I have written a mysql query- SELECT questions.id,questions.date,questions.title,users.user_name,subjects.subject FROM questions INNER JOIN topics ON questions.topic_id=topics.id INNER JOIN subjects topics.subject_id=subjects.id INNER JOIN users ON subjects.id=users.sub1 OR subjects.id=users.sub2 WHERE users.id=8; which is giving error- #1066 - Not unique table/alias: 'topics' .i am unable to understand the problem.

Member Avatar
Member Avatar
+0 forum 1

mysql Inner join problem I have written a mysql query- SELECT questions.id,questions.date,questions.title,users.user_name,subjects.subject FROM questions INNER JOIN topics ON questions.topic_id=topics.id INNER JOIN subjects topics.subject_id=subjects.id INNER JOIN users ON subjects.id=users.sub1 OR subjects.id=users.sub2 WHERE users.id=8; which is giving error- 1066 - Not unique table/alias: 'topics' .i am unable to understand the problem.

Member Avatar
Member Avatar
+0 forum 1

Hi, I am having trouble with retrieving records on my database. My layout was this.. [CODE]UsersList Username Firstname LastName Role Records TheUser ApprovedBy DateApproved [/CODE] The first text are the table names while the indented once are the field names. I have a table named Records. TheUser and ApprovedBy was referring to the Username under the UsersList table. Now my problem was, when I retrieve the records by aliases. I need to use the first name and last name of the users to generate report. Example: [CODE]UsersList mzip Michael Zip Supervisor xtian Christian Holmes Trainee Records xtian mzip 1/22/2012 4:53:00 …

Member Avatar
Member Avatar
+0 forum 2

I’ve created a dynamic page ([I]page.php[/I]) who’s content changes based on the incoming link, specifically by calling a GET on the ID in the URL. So, for example, someone visits [I][url]www.domain.com/page.php?id=310[/url][/I] and the content on the page changes queries the database and returns results for item 310. I’m in the process of redesigning a few things and I’m trying to figure out whether there is a way instead to make these URLs more “friendly.” So, instead of it being [I]page.php?id=310[/I] is there a way to create an alias (for lack of a better term) to make the URL more representative …

Member Avatar
Member Avatar
+0 forum 4

I have 2 directories on Mac OS, one is the original directory and the other is an alias of the original directory. I want to list the contents of the aliased directory using shell script. I used the cd command to switch to the aliased directory, but it fails displaying 'directory not found' Can someone please help me out?

Member Avatar
Member Avatar
+0 forum 1

Almost every user on this board has an alias that is unique and descriptive. But also, many users create multiple alias to fit in different environment. So my questions for the members here are: 1. What does your name/alias mean? 2. What else would you like to share? 3. Does this name permeate to your offline world?

Member Avatar
Member Avatar
+0 forum 2

The End.