[SOLVED] What am I doing wrong?

[patheticsam]

Hi!

 

I have an SQL commande here :

 

$sql = "SELECT `id`, `status`, `pricef`, `pricea`, `cut`, `note`, TIME(`start_time` + `lenght`) as end_time FROM table WHERE friend='$friend' AND city='$city' ORDER by `date`, `start_time`";

 

$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());

 

while($data = mysql_fetch_assoc($req))

 

 

With that code the start_time + lenght will diplay correctly with $data[start_time] and $data[end_time]

 

 

But if I do the same thing with :

 

$sql = "SELECT `id`, `status`, (`pricef` - `pricea`) as cut, `note`, TIME(`start_time` + `lenght`) as end_time FROM table WHERE friend='$friend' AND city='$city' ORDER by `date`, `start_time`";

 

$data[cut] will display correctly but $data[pricef] and $data[pricea] donsen't display anymore....

 

I don't understand what i'm doing wrong. Can someone help me out? Thanks!!

[revraz]

You are putting them into a field called cut.  List them by themself if you still want to see them.

[divadiva]

Thats because in you rsql you are not specifying to displat pricef and pricea .It is only deplaying id status cut note and endtime.

 

"SELECT `id`, `status`, (`pricef` - `pricea`) as cut, `note`, TIME(`start_time` + `lenght`) as end_time FROM table WHERE friend='$friend' AND city='$city' ORDER by `date`, `start_time`"

 

 

Modify to this:

 

 

"SELECT `id`, `status`,pricef,pricea, (`pricef` - `pricea`) as cut, `note`, TIME(`start_time` + `lenght`) as end_time FROM table WHERE friend='$friend' AND city='$city' ORDER by `date`, `start_time`"

 

 

Best

Divya

[patheticsam]

It worked! Thanks I knew it wasn't something big...Thanks again!