echo out something else than what is in the database

[printline]

Hello

i have some php code where i echo out somethings from a database into a table.

What i need is some php code to show something else than what i am getting from the database.

Here is an example:

I echo out a field like this:

[PHP]<?php
$sql = "SELECT * FROM QHEADER WHERE [QuoteID] = '" . $QuoteToFind . "'" ;
$qheader = ads_exec($conn,$sql);
while (ads_fetch_row($qheader))
{
$RJustQuoteToFind = ads_result($qheader,"Quote Nbr");
echo "<td bgcolor='#EFEFEF' align='left' valign='top' class='boldtext' style='border-style: none; padding-top: 3px;'>" . ads_result($qheader,"VGrove") . "</td>";

}
?> [/PHP]

Now this field shows up in the table as: "Y"

What i need it to show is: "Yes"

Is it possible to do something like:

if FieldTocheck = 'Y' then FieldToPrint = "Yes"

Any input is welcome.............?????

[gregerly]

Hello

i have some php code where i echo out somethings from a database into a table.

What i need is some php code to show something else than what i am getting from the database.

Here is an example:

I echo out a field like this:

[PHP]<?php
$sql = "SELECT * FROM QHEADER WHERE [QuoteID] = '" . $QuoteToFind . "'" ;
$qheader = ads_exec($conn,$sql);
while (ads_fetch_row($qheader))
{
$RJustQuoteToFind = ads_result($qheader,"Quote Nbr");
echo "<td bgcolor='#EFEFEF' align='left' valign='top' class='boldtext' style='border-style: none; padding-top: 3px;'>" . ads_result($qheader,"VGrove") . "</td>";

}
?> [/PHP]

Now this field shows up in the table as: "Y"

What i need it to show is: "Yes"

Is it possible to do something like:

if FieldTocheck = 'Y' then FieldToPrint = "Yes"

Any input is welcome.............?????

Hi there,

I'm assuming that this portion:

[PHP]ads_result($qheader,"VGrove") [/PHP]

is what is echoing "Y". If this is the case, you could alter your code as such:

[PHP]$varEcho=(ads_result($qheader,"VGrove") =="Y")?"Yes":"No";[/PHP]

The above code creates a variable based on the ads_result() function. If that function call results in a "Y", the $varEcho is set to "Yes", else sets it to "No". It's called a ternary. You could then echo out $varEcho instead of the ads_result()

Hope that helps.

Greg

[printline]

Great! Just what i needed. It works perfect.

Tanks a lot..... ;o)

[printline]

Could you perhaps help me something else also..............?

I have another field i'm getting from a database i wont to change into something else. It is date/time field.

Ex:

[PHP]<?php
$sql = "SELECT * FROM QHEADER WHERE [QuoteID] = '" . $QuoteToFind . "'" ;
$qheader = ads_exec($conn,$sql);
while (ads_fetch_row($qheader))
{

$RJustQuoteToFind = ads_result($qheader,"Quote Nbr");
echo ads_result($qheader,"LastQuoteDateTime");

}
?>[/PHP]

it comes in a predefined date/format, and I want to change this, but how......????

[nathj]

Could you perhaps help me something else also..............?

I have another field i'm getting from a database i wont to change into something else. It is date/time field.

Ex:

[PHP]<?php
$sql = "SELECT * FROM QHEADER WHERE [QuoteID] = '" . $QuoteToFind . "'" ;
$qheader = ads_exec($conn,$sql);
while (ads_fetch_row($qheader))
{

$RJustQuoteToFind = ads_result($qheader,"Quote Nbr");
echo ads_result($qheader,"LastQuoteDateTime");

}
?>[/PHP]

it comes in a predefined date/format, and I want to change this, but how......????

Hi,

I think you can do that with the php date() function.

Cheers
nathj

[printline]

Tried it, but now i get both the current date and time + the predefined date and time format from the database:

[PHP]<?php
$sql = "SELECT * FROM QHEADER WHERE [QuoteID] = '" . $QuoteToFind . "'" ;
$qheader = ads_exec($conn,$sql);
while (ads_fetch_row($qheader))
{

$RJustQuoteToFind = ads_result($qheader,"Quote Nbr");
//$NewLastQuoteDateTime = ads_result($qheader,"LastQuoteDateTime");


echo (date("d m Y G:i" . ads_result($qheader,"LastQuoteDateTime")));

}
?>[/PHP]

???????????

[Purple]

Hi,

[PHP]echo (date("d m Y G:i" . ads_result($qheader,"LastQuoteDateTime")));[/PHP]

should be

[PHP]echo (date("d m Y G:i", ads_result($qheader,"LastQuoteDateTime")));[/PHP]

note the comma rather than the period - the period is concatenating the input into the function rather than allowing the date to be formatted to be passed as a second parameter.

Hope that helps..

Regards Purple

[printline]

If put in a comma instead i get this error message:

A non well formed numeric value encountered in C:\Inetpub\wwwroot\quotetest.php on line 739
1970 01 01 1:33

[sdhariwal]

it should be like this

echo (date("d m Y G:i", strtotime(ads_result($qheader,"LastQuoteDateTime") )));

use timestamp insted of date

[printline]

That helped.

Thanks a lot ;o)

[Purple]

it should be like this

echo (date("d m Y G:i", strtotime(ads_result($qheader,"LastQuoteDateTime") )));

use timestamp insted of date

Hi,

sdhariwal's suggestion is one approach, may I suggest a better one may be to store the LastQuoteDateTime on the database as a datetime field and then you will not need the strtotime converstion.

Regards Purple