Thanks Larry.

Now I am getting a printf too few arguments error on this line:

HREF=\"mailto:[EMAIL PROTECTED]?subject=$store\%20$jobdesc\";>$jobdesc</A><BR>\n");


"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
>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"
>        "";>
>       <title>Title</title>
>// 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",
>       DisplayErrMsg(sprintf("error:%d %s", mysql_errno($link),
>       exit();
>// send the SQL queries
>$result=mysql_query("SELECT * FROM listings WHERE store='West Covina',
>// return how many rows
>// check if greater than zero
>if($num_rows!=0) {
>    printf("<FONT SIZE=+3>West Covina</FONT> <FONT SIZE=-2><I><A
>    while ($row=mysql_fetch_array($result)) {
>    $store=$rowid["store"];
>    $jobdesc=$rowid["jobdesc"];
>    printf("<A
>HREF=\"mailto:[EMAIL PROTECTED]?subject=$store\%20$jobdesc\";>$jobdesc</A><BR
>    }
>Thank you,
>Jeff Grossman ([EMAIL PROTECTED])

Jeff Grossman ([EMAIL PROTECTED])

PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to