note 31607 deleted from faq by wez
| From: | wez@php.net | Date: | Thu, 15 May 2003 20:19:33 +0000 |
| Subject: | note 31607 deleted from faq by wez | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-48041@lists.php.net to get a copy of this message | ||
Nemohu zadat podminku.
Jestlize zadam dotaz "select * from ren;
Dotaz se provede a vrati mi vysledek ale pokud pouziju nejakou podminku napr. "select * from
ren where type="hs""
dotaz se neprovede a vrati hlasku "Parse error: parse error, unexpected T_STRING in
c:\apache\apache\htdocs\ren.php on line 10"
pokud tenro prikaz zadam v command line mysql, dotaz se provede spravne.
Pouzivam apache pod w2000,mysql,php 4.3.1.
dekuji za pomoc.
<?php
// Pøipojení, výbìr databáze
$link = mysql_connect("czhnas8179", "root", "")
or die("Nelze se pøipojit");
print "Pøipojeno úspìnì!";
mysql_select_db("intranet")
or die("Nelze vybrat databázi");
// Pøíprava SQL dotazu
$query = "SELECT * FROM ren WHERE type="hs"";
$result = mysql_query($query)
or die("Dotaz nelze provést");
// Zobrazení výsledku v HTML
print "<table>\n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
print "\t<tr>\n";
foreach ($line as $col_value) {
print "\t\t<td>$col_value</td>\n";
}
print "\t</tr>\n";
}
print "</table>\n";
// Odpojení z MySQL databáze
mysql_close($link);
?>