Databridge V2 with MySQLi support IS Now Available!

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › General / Announcements › Dreamweaver › Dreamweaver

Dreamweaver

Thread began 3/21/2013 7:26 am by koky462446740 | Last modified 3/29/2013 8:25 am by koky462446740 | 2360 views | 11 replies

3/26/2013 8:13 pmkoky462446740

Hi,

I still cannot return no results if the default value is set to -1.

Is it because I used the wild cards in my sql? (for e.g., I used like and%)?

mysql_select_db($database_books, $books);
$query_Rssearch = sprintf("SELECT * FROM books WHERE books.Title like %s OR books.Author like %s OR books.Publisher like %s OR books.ISBN like %s", GetSQLValueString("%" . $colname_Rssearch . "%", "text"),GetSQLValueString("%" . $colname_Rssearch . "%", "text"),GetSQLValueString("%" . $colname_Rssearch . "%", "text"),GetSQLValueString("%" . $colname_Rssearch . "%", "text"));
$query_limit_Rssearch = sprintf("%s LIMIT %d, %d", $query_Rssearch, $startRow_Rssearch, $maxRows_Rssearch);
$Rssearch = mysql_query($query_limit_Rssearch, $books) or die(mysql_error());
$row_Rssearch = mysql_fetch_assoc($Rssearch);

Thanks!

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.