Jump to content

Archived

This topic is now archived and is closed to further replies.

fingerbob

MySQL and String Functions

Recommended Posts

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

Share this post


Link to post
Share on other sites

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

 

Ken

Share this post


Link to post
Share on other sites

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"

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.