Quoting Cesar Aracena <[EMAIL PROTECTED]>:
### Try by adding a backslash to the : there (..."\: <B>"...)
###
### Cesar L. Aracena
### [EMAIL PROTECTED]
### [EMAIL PROTECTED]
### (0299) 156-356688
### Neuqu�n (8300) Capital
### Argentina
###
###
### -----Mensaje original-----
### De: Adam French [mailto:[EMAIL PROTECTED]]
### Enviado el: viernes, 03 de enero de 2003 3:18
### Para: [EMAIL PROTECTED]
### Asunto: [PHP] DUMB QUESTION I'M SURE
###
### 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.";
you might also want to format the above like this:
$query = "SELECT shops.name FROM shops WHERE name = $name";
you're gonna get an error in your sql syntax otherwise
### $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
###
###
### --
### PHP General Mailing List (http://www.php.net/)
### To unsubscribe, visit: http://www.php.net/unsub.php
###
###
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php