Re: [PHP] create and read array

2004-09-17 Thread John Holmes
John Taylor-Johnston wrote: John, $sql .= "INSERT INTO newtable VALUES ({$mydata->AUS},{$mydata->id});\r\n"; I thought mysql would not permit that, running more than one query (insert ...) at a time? You can get away with it in phpmyadmin, although. You can only run one query per mysql_query() cal

Re: [PHP] create and read array

2004-09-17 Thread John Taylor-Johnston
John, $sql .= "INSERT INTO newtable VALUES ({$mydata->AUS},{$mydata->id});\r\n"; I thought mysql would not permit that, running more than one query (insert ...) at a time? You can get away with it in phpmyadmin, although. -- John Taylor-Johnston --

Re: [PHP] create and read array

2004-09-11 Thread John Taylor-Johnston
John, The long expanation is I'm indexing 2000 records to make a list of each author, and which record I can find them in. It's a bibliography thing. I want to do this, but I don't know how to code it: $array(); $myconnection = mysql_connect($server,$user,$pass); mysql_select_db($db,$myconnecti

Re: [PHP] create and read array

2004-09-10 Thread John Holmes
John Taylor-Johnston wrote: Can someone help me, show me how to do this please? 1. How do I write $mydata->AUS and $mydata->id into an array? $authors = array(); while ($mydata = mysql_fetch_object($news)) { # echo "$mydata->AUS, $mydata->id\n"; ??? write to array } mysql_close($myconnection); What

[PHP] create and read array

2004-09-10 Thread John Taylor-Johnston
Can someone help me, show me how to do this please? 1. How do I write $mydata->AUS and $mydata->id into an array? $authors = array(); while ($mydata = mysql_fetch_object($news)) { # echo "$mydata->AUS, $mydata->id\n"; ??? write to array } mysql_close($myconnection); 2. Then I need to create $SQL