Re: [PHP] DUMB QUESTION I'M SURE

[Jason k Larson]

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???

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php