Time worked on easyPHP but not now

BIOSTALL

Hi all,

When i started to build my site I used easyPHP. For those of you who dont know what easyPHP is, its basically Apache, mySQL and PHP all in one. I've now bought the domain, webspace etc and somethings now not working correctly

The trouble i am getting is that if i had a simple query such as:

$result = mysql_query("SELECT DATE_FORMAT(timeadded, '%H:%i) AS time1 FROM bands", $connection);
$row = mysql_fetch_array($result);
$timeadded = $row['time1'];
echo $timeadded;

If would work on easyPHP but it doesnt work now :-S $timeadded is empty. I've checked the database and theres definitely a value in there.

This problem is only occuring on the time. Its fine with dates etc

Has anyone got any suggestions to why this might be please??

Many thanks,

BIOSTALL

bubblenut

Try this to see what errors mysql is givinig.

 $result = mysql_query("SELECT DATE_FORMAT(timeadded, '%d/%m/%Y') AS time1 FROM bands", $connection) or die("MySQL Error: " . mysql_error());
$row = mysql_fetch_array($result);
$timeadded = $row['time1'];

BIOSTALL

Already have. Theres no errors, $timeadded is just equal to nothing.

BIOSTALL

Rodney_H_

BIOSTALL wrote:

$result = mysql_query("SELECT DATE_FORMAT(timeadded, '%H:%i) AS time1 FROM bands", $connection);

In your SELECT statement, where is timeadded coming from? Is it a number? is it a variable? Does it need to be wrapped in single-quotes?

And, doesn't the date format require a closing single-quote: '%H:%i'

BIOSTALL

OK, that query i wrote in my first post was made up. It was an example.

The fact is, it worked when i ran it on easyPHP, but doesn't run now.

I'm asking if theres any reason why this would happen.

Thanks,

BIOSTALL

subwayman

If the query is as simple as the one you gave, then your issue has to be with the data in the DB. On the face of it there is no reason for such a simple query to work on one db and not on the other.

Try the following:

Add timeadded to your query: "SELECT timeadded,DATE_FORMAT(timeadded, '%H:%i) AS time1 FROM bands",
add an echo of the query string immediately after creating it.
from the page returned copy the query string to the clipboard
paste the query into phpmyadmin (or whatever else you use to admin your db on the new server
run it.

Check the results.

I don't know why but phpmyadmin always seems to report more errors in my stuff than php, so I always rely on it to help with this sort of thing.

Rodney_H_

BIOSTALL wrote:
OK, that query i wrote in my first post was made up. It was an example. snip

Why wouldn't you have posted the actual code? Wouldn't that have proven to be more useful?

edit: I hope subwayman's idea will help.

nemonoman

I agree that there is no value in posting a made up demo problem that IS CODED WRONG (note the missing single quote on your date_format() -- the statement you posted will throw an error).

You say you know that database is storing a value...what method are you using for determining that?

btree

You need to add some converters to convert the queries from OFF mode to ON mode , some webservers packages install MySQL In OFF-Mode , so all quieries are applied on OFF Mode.

nemonoman

Here's my guess: your actual query passes a value in a where clause like:
"WHERE id='$id'":

In your new installation/server, regesiter_globals is off, not on like it is in your local test environment.

So the query looks for id='', finds nothing, returns no value.

This explains how you can (1) see the value you are trying to select when you browse the data and (2) how you get a null return without throwing a SQL error.

Prove I'm wrong by posting your real query.