Ahojte som zaciatocnik co sa PHP a MySQL tyka a xcel som uploadnut svoju mysql a php prvotinu.... Mam klasik hosting na Redhoste s podporou PHP a MySQL, ale nedari sa mi tam rozbehat db. Normalne cez ich myphpadmina si vytvorim db, vyexportujem a pripojim cez mysqsl_connect, klasika a ked si dam nacitat stranku da mi ze acces denied bla bla bla. Ked som to skusal cez apache na mojom compe setko ficalo.... Viete mi niekto pomoct? Dik. Prikladam kod
Kód:
<?php
$con = mysql_connect("host","moje pouzivatelske meno","heslo");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("nazov db", $con);
$result=mysql_query("SELECT * FROM muzstva0708 ORDER BY body DESC, strelene DESC, dostane ASC;");
echo "<table border='0' width='212px'>
<tr>
<th class=table1>Tým</th>
<th class=table1>Z</th>
<th class=table1>V</th>
<th class=table1>R</th>
<th class=table1>P</th>
<th class=table1 colspan='3'>Skóre</th>
<th class=table1>B</th>
</tr>";
while( $row=mysql_fetch_array($result) )
{
echo "<tr>";
echo "<td class=table2>" . $row['muzstvo'] . "</td>";
echo "<td class=table2>" . $row['zapasy'] . "</td>";
echo "<td class=table2>" . $row['vyhry'] . "</td>";
echo "<td class=table2>" . $row['remizi'] . "</td>";
echo "<td class=table2>" . $row['prehry'] . "</td>";
echo "<td class=table2>" . $row['strelene'] . "</td>";
echo "<td class=table2>" . $row['semicolon'] . "</td>";
echo "<td class=table2>" . $row['dostane'] . "</td>";
echo "<td class=table2>" . $row['body'] . "</td>";
echo "</tr>";
}
echo "</table>";
mysql_close($con);
?>