bruce32466 Posted February 16, 2010 Share Posted February 16, 2010 Hi, new guy here. I'm using justhost for my server and the script is a search form to a mysql db. the script just gives me an error of: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/cookin19/public_html/search_script.php on line 24 The script is at www.cooking2behealthy.com/search_script.php here's the script: <html> <head> <title>search script</title> </head> <body> <form name="form" action="search_script.php" method="GET"> <input type="text" name="res" /> <input type="submit" name="submit" value="Search" /> </form> <?php $var = $_GET; require($_SERVER["DOCUMENT_ROOT"] ."/config/db_config.php"); $connection = mysql_connect($db_host, $db_user, $db_password) or die("error connecting"); mysql_select_db($db_name, $connection); $query = "SELECT * FROM recipe_table"; $result = mysql_query($query, $connection); $views = mysql_num_rows($result); echo "$views"; ?> Thanks. Bruce. Quote Link to comment Share on other sites More sharing options...
btherl Posted February 16, 2010 Share Posted February 16, 2010 Try $result = mysql_query($query, $connection) or die("Error in $query<br>" . mysql_error()); Quote Link to comment Share on other sites More sharing options...
bruce32466 Posted February 16, 2010 Author Share Posted February 16, 2010 I feel like such a bone head!!! thankyou! it was a typo in the table name. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.