Hi,

Friday, January 3, 2003, 4:18:05 PM, you wrote:
AF> I'm just starting out, this is my script...

AF> <?
AF> $name = $_POST['username'];
AF> $name = $name;
AF> $db = mysql_connect("localhost");
AF> mysql_select_db("vinyldealers",$db);
AF> $query = "SELECT shops.name FROM shops WHERE name = ".$name.";
AF> $result = mysql_query($query);
AF> while ($record = mysql_fetch_assoc($result)) {
AF>  while (list($feildname, $feildvalue) = each ($record)) {
AF>   echo $feildname. ": <B>" .$feildvalue. "</B><BR>";
AF>   }
AF>  echo"<BR>";
AF>  }
?>>

AF> This is the error I get...

AF> Parse error: parse error, unexpected ':' in
AF> C:\Xitami\webpages\php\result1.php on line 12

AF> I dunno what I'm doing wrong. Help please???




Don't need the ." at the end of this line:

$query = "SELECT shops.name FROM shops WHERE name = ".$name.";

-- 
regards,
Tom


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

Reply via email to