homepage Welcome to WebmasterWorld Guest from 54.161.191.254
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
Forum Library, Charter, Moderators: coopster & jatar k

PHP Server Side Scripting Forum

    
Basic, Just cant see it.
dkin




msg:1269430
 5:08 pm on Apr 16, 2006 (gmt 0)

is there a problem with this

<?php
error_reporting(E_ALL);
include 'dbconnect.php';

$result = mysql_query("SELECT * FROM character where uid = '1'", $link) or die ("query 1: " . mysql_error());
$row = mysql_fetch_array($result);
?>

Im getting this error

query 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'character where uid = '1'' at line 1

thanks

Dylan

 

Tastatura




msg:1269431
 5:46 pm on Apr 16, 2006 (gmt 0)

How did you define uid field Ė as string or number? I am guessing as a number, hence I donít think you need single quotes around itís value. So it should be something like:

$result = mysql_query("SELECT * FROM character WHERE uid=1", $link) or die ("query 1: " . mysql_error());

I am relative newb to PHP and MySQL so take this with grain of saltÖ.

HTH

BertieB




msg:1269432
 5:56 pm on Apr 16, 2006 (gmt 0)

Take this with a pinch of salt too, but I believe that 'character' is a reserved word in MySQL. Running a similar query here gives the same error, as opposed to the 'db.table does not exist'.

Check the MySQL manual for reserved words.

BertieB




msg:1269433
 5:59 pm on Apr 16, 2006 (gmt 0)

Found the reference:

The words in the following table are explicitly reserved in MySQL 5.0. At some point, you might update to a higher version, so it's a good idea to have a look at future reserved words, too. You can find these in the manuals that cover higher versions of MySQL. Most of the words in the table are forbidden by standard SQL as column or table names (for example, GROUP). A few are reserved because MySQL needs them and (currently) uses a yacc parser. A reserved word can be used as an identifier if you quote it.

Among the words is indeed 'character'.

[dev.mysql.com...]

dreamcatcher




msg:1269434
 6:29 pm on Apr 16, 2006 (gmt 0)

Try using back ticks:

"SELECT * FROM `character`...

dc

dkin




msg:1269435
 7:01 pm on Apr 16, 2006 (gmt 0)

got it, just changed the table name, thanks all

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved