Jump to content

fingerbob

New Members
  • Posts

    2
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

fingerbob's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. 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"
  2. 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
×
×
  • Create New...

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.