Jump to content
Larry Ullman's Book Forums

Search the Community

Showing results for tags 'php mysql select var'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Single Editions
    • Modern Javascript: Develop and Design
    • The Yii Book
    • Effortless Flex 4 Development
    • Building a Web Site with Ajax: Visual QuickProject
    • Ruby: Visual QuickStart Guide
    • C++ Programming: Visual QuickStart Guide
    • C Programming: Visual QuickStart Guide
    • Adobe AIR: Visual QuickPro Guide
  • PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide
    • PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide (5th Edition)
    • PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide (4th Edition)
    • PHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide (3rd Edition)
    • PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide (2nd Edition)
    • PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide (1st Edition)
  • PHP for the Web: Visual QuickStart Guide
    • PHP for the Web: Visual QuickStart Guide (5th Edition)
    • PHP for the Web: Visual QuickStart Guide (4th Edition)
    • PHP for the Web: Visual QuickStart Guide (3rd Edition)
    • PHP for the World Wide Web: Visual QuickStart Guide (2nd Edition)
    • PHP for the World Wide Web: Visual QuickStart Guide (1st Edition)
  • Effortless E-commerce with PHP and MySQL
    • Effortless E-Commerce with PHP and MySQL (2nd Edition)
    • Effortless E-Commerce with PHP and MySQL
  • PHP Advanced: Visual QuickPro Guide
    • PHP Advanced and Object-Oriented Programming: Visual QuickPro Guide (3rd Edition)
    • PHP 5 Advanced: Visual QuickPro Guide (2nd Edition)
    • PHP Advanced: Visual QuickPro Guide
  • MySQL: Visual QuickStart Guide
    • MySQL: Visual QuickStart Guide (2nd Edition)
    • MySQL: Visual QuickStart Guide (1st Edition)
  • Other
    • Announcements
    • Newsletter, Blog, and Other Topics
    • Forum Issues
    • Social

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Found 1 result

  1. I am working with PHP Third edition and MySQL second edition - both show php mysql scripts. working with PHP for the web, third edition, page 373, modify the script to accept value from form field and then and to receive data from database. I have re worked this many times over and am frustrated to the point of brain freeze. what can i do to receive the business name associated with zip code in database. any assistance ? thank you. <?php if ( isset($_POST['submitted']) ) { $baz = $_POST['zip']; $dbc = mysql_connect('localhost', 'usr_name', 'password'); mysql_select_db('data_base_name'); //$query = 'SELECT biz_name FROM retail_client WHERE zip_code = 99201'; //$query = 'SELECT biz_name FROM retail_client WHERE zip_code = \'$baz\' '; // error message: mysql_query() expects parameter 2 to be resource, if($r = mysql_query('$dbc' 'SELECT biz_name FROM retail_client WHERE zip_code = 99201')) { while ($row = mysql_fetch_array($r) { print "<p> {$row['biz_name']} </p>"; } // while } // two } //ONE print ' <form action="this_script.php" method="post"> <p>Zip code: <input type="text" name="zip" size="10" /></p> <input type="submit" name="submit" value="go" /> <input type="hidden" name="submitted" value="true" /> </form> '; ?>
×
×
  • Create New...