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 Link to comment https://forums.phpfreaks.com/topic/18171-help-with-phpmysql/ 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')"; Link to comment https://forums.phpfreaks.com/topic/18171-help-with-phpmysql/#findComment-77939 Share on other sites More sharing options...
snake310 Posted August 21, 2006 Author Share Posted August 21, 2006 thx... Link to comment https://forums.phpfreaks.com/topic/18171-help-with-phpmysql/#findComment-77940 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.