To expand on that.. printf is short for print-formatted... its a function inherited from c (I think) which basically allows your to format variable for the display within the function, eg if you had $x=1.2243 then you could, for example, use ptinf to only display it as 1.22 To cut a long story short, Larry was right in his advice.. just thought I'ld stick my ha'penny's worth in too.. give you an idea why! > I don't see why you are using printf there try print instead or echo ;)0 > -----Original Message----- > From: Jeff Grossman [mailto:[EMAIL PROTECTED]] > Sent: Saturday, July 07, 2001 6:56 PM > To: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] Parsing Error > > Thanks Larry. > > Now I am getting a printf too few arguments error on this line: > > printf("<A > HREF=\"mailto:[EMAIL PROTECTED]?subject=$store\%20$jobdesc\";>$jobdesc</A><BR > >\n"); > > Thanks, > Jeff > "Larry Rivera" <[EMAIL PROTECTED]> wrote: > > >After a brief look it appears that your call to mysql_query is > incorrect > >" after the query then "," then the link resource > > > >-----Original Message----- > >From: Jeff Grossman [mailto:[EMAIL PROTECTED]] > >Sent: Saturday, July 07, 2001 6:23 PM > >To: [EMAIL PROTECTED] > >Subject: [PHP-DB] Parsing Error > > > >I keep getting the following error: > > > >Warning: Supplied argument is not a valid MySQL result resource in > >/home/httpd/html/stats/jobs/listing.php on line 33 > > > >Warning: Supplied argument is not a valid MySQL result resource in > >/home/httpd/html/stats/jobs/listing.php on line 43 > > > >when I try to display the following webpage. What am I doing wrong? > > > ><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" > > "http://www.w3.org/TR/1999/REC-html401-19991224/loose.dtd";> > ><html> > ><head> > > <title>Title</title> > ></head> > ><body> > ><?php > >$hostName="localhost"; > >$userName="jeff"; > >$password="jeff"; > >$databaseName="jobs"; > >$tableName="listings"; > > > >// connnect to the database > >if (!($link=mysql_pconnect($hostName, $userName, $password))) { > > DisplayErrMsg(sprintf("error connecting to host %s by user > >%s", $hostName, $userName)); > > exit(); > >} > > > >// select the database > >if (!mysql_select_db($databaseName, $link)) { > > DisplayErrMsg(sprintf("Error in selecting %s database", > >$databaseName)); > > DisplayErrMsg(sprintf("error:%d %s", mysql_errno($link), > >mysql_error($link))); > > exit(); > >} > > > >// send the SQL queries > > > >$result=mysql_query("SELECT * FROM listings WHERE store='West Covina', > >$link"); > > > >// return how many rows > >$num_rows=mysql_num_rows($result); > >// check if greater than zero > >if($num_rows!=0) { > > printf("<FONT SIZE=+3>West Covina</FONT> <FONT SIZE=-2><I><A > >HREF=\"../test/stores.php#WC\">address</A></I></FONT><BR><BR>"); > > while ($row=mysql_fetch_array($result)) { > > $store=$rowid["store"]; > > $jobdesc=$rowid["jobdesc"]; > > printf("<A > >HREF=\"mailto:[EMAIL PROTECTED]?subject=$store\%20$jobdesc\";>$jobdesc</A><B > R > >>\n"); > > } > >} > >mysql_free_result($result); > > > >?> > > > ></body> > ></html> > > > > > >Thank you, > >Jeff > >--- > >Jeff Grossman ([EMAIL PROTECTED]) > > --- > Jeff Grossman ([EMAIL PROTECTED]) > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
