<?PHP questions that don\\'t need their own thread ?>

Register a SA Forums Account here!
JOINING THE SA FORUMS WILL REMOVE THIS BIG AD, THE ANNOYING UNDERLINED ADS, AND STUPID INTERSTITIAL ADS!!!

You can: log in, read the tech support FAQ, or request your lost password. This dumb message (and those ads) will appear on every screen until you register! Get rid of this crap by registering your own SA Forums Account and joining roughly 150,000 Goons, for the one-time price of $9.95! We charge money because it costs us money per month for bills, and since we don't believe in showing ads to our users, we try to make the money back through forum registrations.

The Something Awful Forums > Discussion > Serious Hardware/Software Crap > The Cavern of COBOL > <?PHP questions that don\\'t need their own thread ?>

J Crewl: Dec 11, 2005

Stupid newbie question here. Is there anything inherently wrong with the below statement, or do I need to include more of a context?

code:

$db->query('INSERT INTO '.$db->prefix.'geocoordinates (name, latitude, longitude)VALUES
(\\''.$db->escape($name).'\\', \\''.$db->escape($latitude).'\\', \\''.$db->escape($longitude).'\\')') 
or error('Unable to insert geocode', __FILE__, __LINE__, $db->error());

Where name, latitude, and longitude are strings that I'm sure have value since I echo them before this. They are also all varchars in mysql db. The only other field in the table is an auto-incremented Id.

Is the problem in the syntax or is it something in my logic?

It only outputs the "unable to insert geocode" with no specific error to work off of.

J Crewl fucked around with this message at 01:26 on Mar 31, 2008

# ¿ Mar 31, 2008 01:20

Adbot: ADBOT LOVES YOU

# ¿ May 7, 2024 10:55

The Something Awful Forums > Discussion > Serious Hardware/Software Crap > The Cavern of COBOL > <?PHP questions that don\\'t need their own thread ?>