Форум программистов [Powered by Invision Power Board]

Код


$conn = mysql_connect("localhost","root","") or die("Невозможно установить соединение: ". mysql_error());
mysql_select_db("energo");
if ($sort){
$result = mysql_query(
"SELECT DISTINCT products.about as about, products.id_products as id, catalog.name as catalog_name, products.name as name, products.ed as ed, products.price as price 
FROM catalog INNER JOIN products ON catalog.id_catalog = products.id_catalog
ORDER BY products.$sort", $conn);} 
else {
$result = mysql_query("
SELECT DISTINCT products.about as about, products.id_products as id, catalog.name as catalog_name, products.name as name, products.ed as ed, products.price as price
FROM catalog INNER JOIN products ON catalog.id_catalog = products.id_catalog
ORDER BY products.name", $conn);}

if ($result) {
echo "<table>\n";
echo "<tr>
<td class=katsh><p>Описание</p></td>
<td class=katsh><p>Код</p></td>
<td class=katsh><p>Название</p></td>
<td class=katsh><p>Ед.</p></td>
<td class=katsh><p>Цена</p></td>
<td class=katsh><p>Купить</p></td>
</tr>";
while ($row = mysql_fetch_array($result)) {
echo "<tr><td class=kat>";
if ($row['about']<>"") {echo "<a href=".$row['about']."><img src=../pic[s]/about.gif></a>";}
echo "</td>";
echo "<td class=kat><p>".$row['id']."</p></td>";
echo "<td class=kat2><p>".$row['name']."</p></td>";
echo "<td class=kat><p>".$row['ed']."</p></td>";
echo "<td class=kat><p>".$row['price']."</p></td>";
echo "<td class=kat><a href=><img src=../pic[s]/bag.gif></a></td>";
echo "</tr>";

Код


        <a href=<your url>?item=<?php $row['id']; ?>>buy</a>

Код


        if (isset($_GET['item']))
        {
                 $item=trim(stripslashes(htmlspecialchars($_GET['item'])));
                 $query="insert into `temp_user_name_trash` values ('$item', '$uid')";
                 mysql_query($query);
        }

Код


        $que="select * from `temp_user_name_trash` where `uid`=$uid";
        $query=mysql_query($que);

Цитата(Dajna @ 20.11.2006, 16:12

)

if ($sort){
$result = mysql_query(
"SELECT DISTINCT products.about as about, products.id_products as id, catalog.name as catalog_name, products.name as name, products.ed as ed, products.price as price
FROM catalog INNER JOIN products ON catalog.id_catalog = products.id_catalog
ORDER BY products.$sort", $conn);}
else {
$result = mysql_query("
SELECT DISTINCT products.about as about, products.id_products as id, catalog.name as catalog_name, products.name as name, products.ed as ed, products.price as price
FROM catalog INNER JOIN products ON catalog.id_catalog = products.id_catalog
ORDER BY products.name", $conn);}

Код


$query="
SELECT DISTINCT products.about as about, products.id_products as id, catalog.name as catalog_name, products.name as name, products.ed as ed, products.price as price 
FROM catalog INNER JOIN products ON catalog.id_catalog = products.id_catalog
ORDER BY products.";

$sort?$query.=$sort:$query.="name";