fingerbob
-
Posts
2 -
Joined
-
Last visited
Never
Posts posted by fingerbob
-
-
Hi,
I'm using the following query to return formatted infomation from a table:
SELECT SUBSTRING (`name`, LOCATE('.',`name`)+2) as newname FROM `mytable`
This query works when I use it though phpMyadmin, but I get error messages when I try to use it through php.
I've been trying to update a field in another table with the results of this query but with no success.
Can anyone help?
Thanks
MySQL and String Functions
in MySQL Help
Posted
Hi Ken,
My Code is
<?
$db = mysql_connect("localhost", "user", "pass")
or die("Could not connect : " . mysql_error());
mysql_select_db("mydb") or die("Could not select database");
$result = mysql_query("SELECT SUBSTRING (`name`, LOCATE(\'.\',`name`)+2) as newname FROM `mytable`") or die('Error.....' . mysql_error());
while ($row = mysql_fetch_array($result)) {
extract($row);
echo $newname;
echo "<br>";}
?>
The error message says there is
"an an error in your SQL syntax"