MySQL and String Functions

[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

[kenrbnsn]

What are the messages you're getting and can we see your code?

 

Ken

[fingerbob]

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"