<div>
@gamebits: Nice Catch! &nbsp;To avoid accidentally using a MySQL reserved word in my queries, I like to name columns like o_city, o_code, o_condition, etc.
</div>


@gamebits: Nice Catch!  To avoid accidentally using a MySQL reserved word in my queries, I like to name columns like o_city, o_code, o_condition, etc.

<div>
All Right! &nbsp;Thank you!<br />
<br />
Gamebits gets the points, but thanks for the additional tidbit Ray.<br />
<br />
Now for the stupid follow up question. &nbsp;I'm going to copy the code and paste it in to fix this, but for the future, where are backticks on my keyboard? &nbsp; Or do you just make them up with some kind of magic?
</div>


All Right!  Thank you!

Gamebits gets the points, but thanks for the additional tidbit Ray.

Now for the stupid follow up question.  I'm going to copy the code and paste it in to fix this, but for the future, where are backticks on my keyboard?   Or do you just make them up with some kind of magic?

<div>
the key beside the key with the number one on your keyboard
</div>


the key beside the key with the number one on your keyboard

<div>
`<br />
ahh, got it! &nbsp;`Thank you`!<br />
<br />

</div>


<div>
<div class="content wysiwyg-content">
I'm moving from a server with an old version of mysql 3.23.58 &nbsp;to a newer version, 5.0.45<br />
<br />
In my php scripts, I have a query like this: <br />
<br />
INSERT INTO oys_reports (city,code,condition,f,c) VALUES ('Baltimore IH','NAMD','na','61','16.1<wbr />')<br />
<br />
which doesn't seem to work with mysql 5, I just get a syntax error.<br />
<br />
Is there a different way to do the same thing now?<br />
<br />
Thanks, &nbsp; &nbsp;Chris
</div>
</div>


I'm moving from a server with an old version of mysql 3.23.58  to a newer version, 5.0.45

In my php scripts, I have a query like this: 

INSERT INTO oys_reports (city,code,condition,f,c) VALUES ('Baltimore IH','NAMD','na','61','16.1')

which doesn't seem to work with mysql 5, I just get a syntax error.

Is there a different way to do the same thing now?

Thanks,    Chris

mysql query needs changing from old to new mysql?

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.