note 31607 added to faq
| From: | petr dot hoffmann at rieter dot com | Date: | Mon, 28 Apr 2003 06:59:11 +0000 |
| Subject: | note 31607 added to faq | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-47188@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);
?>
--
http://www.php.net/manual/en/faq.php
http://master.php.net/manage/user-notes.php?action=edit+31607
http://master.php.net/manage/user-notes.php?action=delete+31607
http://master.php.net/manage/user-notes.php?action=reject+31607