I am wondering if anyone knows, is there anyway to change the date formate on a timestamp, before you print the timestamp I was thinking something like this.
SELECT date(y-m-d,date) FROM dateHi,
I am wondering if it is possible to link or join three tables together?
they are all linked by id
x_campaign - id
x_transactions - cid - refers to the x_campaign id
x_airplay - cid - refers to x_campaign id
are the tables names and the rows names.
Cheers
I am trying to send data to a page via a post header. This is for a login script I am doing, I basically don't want the users to see error=1
This is what I have so far, but all attempts seem not to send the post data.
$req="error=1";
header("method: POST");
header("Host: localhost");
header("Content-Type: application/x-www-form-urlencoded");
header("Content-Length: ".strlen($req));
header($req);
//header("Connection: close");
header('Location: index2.php');Hi I have been trying to change the DIV class the original script works fine, but I want the javascript to allow the person to click the div over and over and switch the class.
Here is my code (which does not work)
I am not sure what I am doing wrong, since I see people using if statements in javascript.
<script type="text/javascript">
function changeclass(action) {
var class = document.getElementById("tab"+action);
if ( class.className == switchoff )
{
document.getElementById("tab"+action).className = "switch";
}
else if ( class.className == switchoff )
{
document.getElementById("tab"+action).className = "switchoff";
}
}
</script>
<div id="tab1" onclick="changeclass(1);" class="switch">
</div>
<div id="tab2" onclick="changeclass(2);" class="switch">
</div>Hi david and all.
Just wondering what is the best way to handle a payment system.
I am thinking using Paypal to use as the system to deposit and withdraw. But what I need to know is in the DB how should I handle which is a withdraw and which is a deposit.
The system allows advertisers to buy ads on radio stations, and when they are played the system sends the money to the radio station's account.
for e.g. Say the Advertisers ID was 3 and the Radio station id was 9
from | TO | Amount
3 | 9 | 5.00
Then in another table I was thinking I need to handle their balance so any advice?
Hi I was wondering if there is any PHP code that I could use, to show how many friday the 13th there are in 2009 or any year a user request?
I know that sounds strange but no search engine shows this information, and I would like to know. Me and my house mate had a argument over how is correct. I say 3 and he says it only happens once.
I guess I could go though each month but would be better if there was away PHP date would be able to tell me.
Hi I need away to get the last part of this URL
{link saved}
The data after the 6th ,
I am having the biggest problems adding HTML signs like & into the DB.
I have tried everything I know of.
mysql_real_escape_string - seem not to work, and you would think it would.
addslashes() - Seems not to help me.
so just wondering what is the right code to use.
Hi all, having some small issues with my CSS plz look at this page {link saved}
you will see that the image at the bottom of the page is not all in the black, can anyone help with this.
The css the background is #story
If you can help That would be great.
Thanks
Hi Guys, need a little help.
I would like to hide URL's
I want a user to be able to go to the following
http://www.example.com/news/this-is-the-news
and for it to go to
http://www.example.com/news.php?id=1
each story in the database is stored title has a URL link like this-is-the-news but the title shows This is the news. Kinda like wordpress htaccess sorry that is the best explaining I can do.
If anyone can help that would be great.
This is what i am thinking I have to do.
When the link goes to news.php instead of the id= it has to be url=this-is-the-news and then in the first PHP code I have to do a database check to see if that link is in the database.
from there I have to show the body and the title in the right area?
Would that be correct? So in basic I need to know how to hide the URL to be more SEO friendly.
