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]
