Re: DUMB QUESTION I'M SURE
| From: | Jason k Larson | Date: | Fri, 03 Jan 2003 06:28:18 +0000 |
| Subject: | Re: DUMB QUESTION I'M SURE | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-130059@lists.php.net to get a copy of this message | ||
I think it's just the $query var not having the right number of quotes. I added single quotes around the value.
<?
$name = $_POST['username'];
$name = $name;
$db = mysql_connect("localhost");
mysql_select_db("vinyldealers",$db);
$query = "SELECT shops.name FROM shops WHERE name = '".$name."'";
$result = mysql_query($query);
while ($record = mysql_fetch_assoc($result)) {
while (list($feildname, $feildvalue) = each ($record)) {
echo $feildname. ": <B>" .$feildvalue. "</B><BR>";
}
echo"<BR>";
}
?>
HTH,
Jason k Larson
Adam French wrote:
I'm just starting out, this is my script... <? $name = $_POST['username']; $name = $name; $db = mysql_connect("localhost"); mysql_select_db("vinyldealers",$db); $query = "SELECT shops.name FROM shops WHERE name = ".$name."; $result = mysql_query($query); while ($record = mysql_fetch_assoc($result)) { while (list($feildname, $feildvalue) = each ($record)) { echo $feildname. ": <B>" .$feildvalue. "</B><BR>"; } echo"<BR>"; } ?> This is the error I get... Parse error: parse error, unexpected ':' in C:\Xitami\webpages\php\result1.php on line 12 I dunno what I'm doing wrong. Help please???