php mysql problem...

am 13.03.2007 23:14:25 von stjepko

I have a problem in my code...this is a one php file wich is included in
another php file
--------------------------------------

$sqlpodartikli = "SELECT * FROM podartikli WHERE artiklid=".$row[id];

$result2 = mysql_query($sqlpodartikli) ;
if($result2)
{
while($row2 = mysql_fetch_array($result2))
{
?>

}
}
?>

-----------------

I want to order by rednibr table in podartikli....how?
tnx

Re: php mysql problem...

am 13.03.2007 23:24:39 von Shion

stjepko wrote:
> I have a problem in my code... I want to order by rednibr table in podartikli....how?

$sqlpodartikli = "SELECT * FROM podartikli WHERE artiklid=".$row[id]."
ORDER BY rednibr";

--

//Aho

Re: php mysql problem...

am 14.03.2007 00:46:54 von stjepko

"J.O. Aho" wrote in message
news:55oml7F25eh18U1@mid.individual.net...
> stjepko wrote:
>> I have a problem in my code... I want to order by rednibr table in
>> podartikli....how?
>
> $sqlpodartikli = "SELECT * FROM podartikli WHERE artiklid=".$row[id]."
> ORDER BY rednibr";
>
>
> --
>
> //Aho

I done that but after that i did not get any resultat out :(
but tnx...

Re: php mysql problem...

am 14.03.2007 01:01:20 von Shion

stjepko wrote:
> "J.O. Aho" wrote in message
> news:55oml7F25eh18U1@mid.individual.net...
>> stjepko wrote:
>>> I have a problem in my code... I want to order by rednibr table in
>>> podartikli....how?
>> $sqlpodartikli = "SELECT * FROM podartikli WHERE artiklid=".$row[id]."
>> ORDER BY rednibr";
>
> I done that but after that i did not get any resultat out :(
> but tnx...

Check that your select query is correct, echo it out can help.
Do use mysql_error() to see if there is some other errors

echo mysql_errno() . ": " . mysql_error() . "
\n";

Of course you can order things in php, but thats a lot more work storing
it an a big array and then sort it.This will consume more memory and
take longer time.

Fix your mail client too, there shouldn't been any row below this one in
your reply.
--

//Aho

Re: php mysql problem...

am 15.03.2007 18:33:59 von unknown

Post removed (X-No-Archive: yes)