Hi All I have a table *resubmt_skill_ids, *it has two coulmns, skillid (primary key) and skillname (unique key). I have below code. ,
* $query_string = "INSERT INTO resubmt_skill_ids (skillname) VALUES ('php'), ('sql') " ; $result = db_query($query_string);
if($result) { while($obj = **db_fetch_array($result)) {* * * * //DO Other stuff*
With this I get the warning: warning: mysqli_fetch_object() expects parameter 1 to be mysqli_result, boolean given in C:\MyWeb6.20\wamp\www\livejobs1\includes\database.mysqli.inc on line 151.
As per Drupal documentation db_query should return "A database query result resource, or FALSE if the query was not executed correctly." So if($result) condition turns out to be true, can I guess that there will be atleast 1 record in $result.
I found data is written to table, and want to have newly written data (both skillname and corresponding skillid), can I extract the data from $result, or I need to do one more query to get the newly written data.
Thanks Austin