mysql_fetch_array - supplied argument error
Posted: Tue Jul 25, 2006 11:29 am
feyd | Please use
feyd | Please use
Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]
Im getting an error on a select statement. I am not sure why this is happening. I have the vars different so they cant be referencing one another. The error occurs on while ($myrow = mysql_fetch_array($result))Code: Select all
$dbcon = mysql_connect("localhost", "test", "test");
mysql_select_db($dbase,$dbcon);
$export = "select distinct agentno,pa_cq,last,first from $edttable order by last,first";
$expresult = mysql_query($export,$dbcon) or die (mysql_error());
$num_fields = mysql_num_fields($expresult);
print("<table border='1'>\n");
print("<tr><td bgcolor=\"#FFFFCC\">License #</td><td bgcolor=\"#FFFFCC\">Last Name</td><td bgcolor=\"#FFFFCC\">First Name</td>\n");
$query1="select * from util.states";
$result1=mysql_query($query1,$dbcon) or die (mysql_error());
while ($myrow1 = mysql_fetch_assoc($result1))
{
$starray[]=$myrow1['STATE'];
$tstate=$myrow1['STATE']; if($myrow1['STATE'] != '') { $tstate = $myrow1['STATE']; }
print("<td bgcolor=\"#FFFFCC\">$tstate</td>");
}
print("</tr></table>\n");
while($dbrow = mysql_fetch_array($expresult))
{
$pacq = ''; if($dbrow['pa_cq'] != '') { $pacq = $dbrow['pa_cq']; }
$tempag = ''; if($dbrow['agentno'] != '') { $tempag = $dbrow['agentno']; }
$first = ''; if($dbrow['first'] != '') { $first = $dbrow['first']; }
$last = ''; if($dbrow['last'] != '') { $last = $dbrow['last']; }
$query2 = "insert into combtmp (pa_cq,agentno,first,last) values ('$pacq','$tempag','$first','$last')";
$result2=mysql_query($query2,$dbcon) or die (mysql_error());
$query = "select agentno,state,lic,peoples,fraz_vet,fraz_ppl,stonebrdg,aflac,mutual,monumental,genworth,gwl,gwm from agstate where agentno='$tempag'";
print("QUERY RESULT-$query\n");
$result=mysql_query($query,$dbcon) or die (mysql_error());
$recs = mysql_num_rows($result);
while ($myrow = mysql_fetch_array($result))
{
$state = ''; if($myrow['state'] != '') { $state = $myrow['state']; }
$lic = ''; if($myrow['lic'] != '') { $lic = $myrow['lic']; }
if($lic == 'Y') { $lic = 'X'; }
//$peoples = ''; if($myrow['peoples'] != '') { $peoples = $myrow['peoples']; }
$fraz_vet = ''; if($myrow['fraz_vet'] != '') { $fraz_vet = $myrow['fraz_vet']; }
if($fraz_vet == 'Y') { $fraz_vet = 'V'; }
$fraz_ppl = ''; if($myrow['fraz_ppl'] != '') { $fraz_ppl = $myrow['fraz_ppl']; }
if($fraz_ppl == 'Y') { $fraz_ppl = 'F'; }
$stonebrdg = ''; if($myrow['stonebrdg'] != '') { $stonebrdg = $myrow['stonebrdg']; }
if($stonebrdg == 'Y') { $stonebrdg = 'S'; }
$aflac = ''; if($myrow['aflac'] != '') { $aflac = $myrow['aflac']; }
if($aflac == 'Y') { $aflac = 'A'; }
$mutual = ''; if($myrow['mutual'] != '') { $mutual = $myrow['mutual']; }
if($mutual == 'Y') { $mutual = 'm'; }
}
}feyd | Please use
Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]