snake310 Posted August 21, 2006 Share Posted August 21, 2006 Hello cAn anyonr help me have a problem with writing to a mysql database with php<?php $query = "INSERT INTO asus "; $query .= "(model, serial, "; $query .= "InTime, provider) "; $query .= " VALUES(a8n,123545,545464,45646)"; mysql_pconnect("localhost","root") or die("Unable to connect to SQL server"); mysql_select_db("motherboards") or die("Unable to select database"); mysql_query($query) or die("Insert Failed!");?>Anyone hase any idea?btw just the query has error the connection workes perfectly Quote Link to comment Share on other sites More sharing options...
hvle Posted August 21, 2006 Share Posted August 21, 2006 you need single quote around values like this:$query .= " VALUES('a8n','123545','545464','45646')"; Quote Link to comment Share on other sites More sharing options...
snake310 Posted August 21, 2006 Author Share Posted August 21, 2006 thx... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.