Date problem

MichaelHe

I have tried looking for an answer to my problem, but I can't seem to find anything about it.

I am looking at one post in a MySQL database, like this.

$getid=mysql_query("select * from Brugere WHERE Brugernavn='$brugernavn' AND Adgangskode='$adgangskode'");
{while ($row = mysql_fetch_array($getid)){
$dato=$row['Dato'];};}

Dato is a date field in my database the show the date like this : 2005-08-17
Show if i echo $dato it writes 2005-08-17on the the screen.
I am not using date_format in the query because I need the date written like this everywhere on the page.
But there are my place on the site where I need it written 17-08-2005. How do I get the date written like this, this one place.

echo $dato(and then maybe some codes) ??

I don't need $dato to be changes in any way since I use it like this elsewhere, but I just need it to be written different this one time on the screen.. Is it possible. ?

Michael

TobyRT

try

echo date("m d Y", $dato)

I think that should solve it

Have a look at the date() function in the php manual

MichaelHe

Hmm.. this is a little weird..

If I write echo $dato; it writes 2005-18-08 on the screen.
But if I write echo date("m d Y", $dato) it writes 01 01 1970..

why is that.. ?

TobyRT

oops - I forgot to mention, you need to add a line into your SELECT query

"select blah, blah, UNIX_TIMESTAMP (dato) as dato from db"

This puts it in a form that the date() function can understand.

MichaelHe

Now I have written

mysql_query("select * from Brugere WHERE Brugernavn='$brugernavn' AND Adgangskode='$adgangskode' UNIX_TIMESTAMP (dato) as dato from db");
{while ($row = mysql_fetch_array($getid)){
$dato=$row['Dato'];

And now it says

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/home/web/web60269/TEST/BrugerUpgrade.php on line 22

And line 22 is the {while line ??

mrhappiness

in each SELECT you may have a maximum of exactly 1 FROm-statements according to http://dev.mysql.com/doc/mysql/en/select.html...

MichaelHe

OK I don't think I understood that :bemused:

mrhappiness

[ ] you read the link

in short:
a standard SELECT looks like this

SELECT
  some_columns
FROM
  some_tables
WHERE
  some_conditions_are_true

you wrote

select * from Brugere WHERE Brugernavn='$brugernavn' AND Adgangskode='$adgangskode' UNIX_TIMESTAMP (dato) as dato from db");

which would be

SELECT
  some_columns
FROM
  some_tables
WHERE
  some_conditions_are_true
FROM
  some_tables

looks kinda weird, doesn't it?

TobyRT

What he means is that you've said, inadvertently, select * from a table where something is true, and then you've put another 'FROM' in again. Just delete the last 'from db'

The reason it's failing on the 'while' line is that I don't think you've told it what $getid is have you? It's looking for a variable that's not there!

$result= mysql_query(blah blah from blah);
{while ($row = mysql_fetch_array($getid)){
$dato=$row['Dato'];

MichaelHe

OK..

I didnt' see the from db as a FROM statement.. my mistake.. 😉

But now my codes look like this:

$getid=mysql_query("select * from Brugere WHERE Brugernavn='$brugernavn' AND Adgangskode='$adgangskode' UNIX_TIMESTAMP (dato) as dato");
{while ($row = mysql_fetch_array($getid)){
$dato=$row['Dato'];
;}

Later i write:

<?echo $dato;?> and <?echo date("m d Y", $dato)

The outcome on the page is.

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/home/web/web60269/TEST/BrugerUpgrade.php on line 22

01 01 1970

So still the error is there, and the original date from the echo $dato is not there and the echo date("m d Y", $dato) still writes 01 01 1970...
I don't quite get it..?

mrhappiness

you want to select the converted date, don't you?

so why don't you make it part of your SELECT part?

i think there's lots of basics you will have to learn 🙂

TobyRT

I Think you've got your query the wrong way around - yo'ure givingi t the conditions and then telling it what to select, try telling it what to select and THEN the conditions that must be met - that's the way I do it at anyrate🙂 I'm sure that your query SHOULD work, but I'm not an expert either!

$getid=mysql_query("select UNIX_TIMESTAMP (dato) as dato from Brugere WHERE Brugernavn='$brugernavn' AND Adgangskode='$adgangskode'"); 
// { why are you using this curly bracket here? You don't need it - oops - i typed it didn't I :/
while ($row = mysql_fetch_array($getid)){ 
$dato=$row['dato']; //use lowercase - it's case sensitive
}

MichaelHe

It's getting weird..

I have written it exactly as wrote it :

$getid=mysql_query("select UNIX_TIMESTAMP (dato) as dato from Brugere WHERE Brugernavn='$brugernavn' AND Adgangskode='$adgangskode'");
while ($row = mysql_fetch_array($getid)){
$dato=$row['dato'];}

But still I get the same error in the While line, and the the echo $dato is not showing anything.
My field in the database is called Dato with capital start letter, has this anything to do with it.

mrhappiness

remove the space between UNIX_TIMESTAMNP and the (

if the error still occurs put

echo mysql_error();

after your call to mysql_query

MichaelHe

Great.. Now it works.. 🙂

TobyRT

DOH! Don't believe I missed that!

littlegirl

<html> 
<head><title>UPT - Forme FshirjeStudent</title></head> 
<body topmargin="0" background="ko.gif"onLoad="show5()"> 
[code=php]<? require_once("dbvars.php"); 
require_once("dbconnect.php"); 
$sql = "SELECT * FROM studentet WHERE ID_Student = $ID_Student "; 
$resultall = mysql_query($sql) or die ("Error in query: $sql".mysql_error()); 
while($row=mysql_fetch_array($resultall)){ 
$emer=$row['Emer']; 
$mbiemer=$row['Mbiemer']; 
$Viti_Aktual=$row['Viti_Aktual']; 
$ID_Drejtimi=$row['ID_Drejtimi']; 
$query2="SELECT *from drejtimet WHERE ID_Drejtimi=' $ID_Drejtimi' order by Emer"; 
$result2=mysql_query($query2); 
while($row2=mysql_fetch_array($result2)){ 
$Emer=$row2['Emer']; 
if (isset($_GET["ID_Student"])) { 
$ID_Student = $_GET["ID_Student"]; 
$query_fshi = "delete from studentet where ID_Student = $ID_Student"; 
mysql_query($query_fshi);} 
?>

<table width="458" height="114" border="0" align="center" cellpadding="0">
<tr>
<td background="sfondi.gif" bgcolor="#9999CC"><strong><font size="2" face="Arial, Helvetica, sans-serif">Ju sapo fshite nga Baza e te Dhenave studentin:

<? echo "<strong><font size=\"2\" face=\"Arial, Helvetica, sans-serif\" text color= \"FF0000\"> $emer &nbsp; </strong> </font>" ?>

<? echo "<strong><font size=\"2\" face=\"Arial, Helvetica, sans-serif\" text color= \"FF0000\"> $mbiemer &nbsp; </strong> </font>" ?>

,
<

? echo "<strong><font size=\"2\" face=\"Arial, Helvetica, sans-serif\" text color= \"FF0000\"> $Viti_Aktual &nbsp; </strong> </a></font>" ?>

te Deges

<? echo "<strong><font size=\"2\" face=\"Arial, Helvetica, sans-serif\" text color= \"FF0000\"> $Emer &nbsp; </strong> </font>" ?>

</font></strong></td>
</tr>
</table>
<table width="624" border="0" align="right" cellpadding="0" bordercolor="#990000"> <tr>
<td width="267" bordercolor="#716F64" background="sfondi.gif" bgcolor="#CCCCFF" class="smallwhitetxt style1"><div align="center"><font color="#0000FF"><a href="fshi_student.php">
Kliko ketu per te fshire nje student tjeter </a></font> </div></td>
<td width="25"> </td>
<td width="324"><table width="230" border="0" align="center" cellpadding="0"><tr>
<td width="226" background="sfondi.gif" bgcolor="#CCCCFF"><div align="center"><font color="#0000FF"><a href="admin.php" class="smallwhitetxt style2"> Kliko ketu per te shkuar ne faqen administrim </a></font></div></td> </tr> </table></td> </tr></table>

<? } } ?>

</body>
</html>[/code]