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. Link to comment https://forums.phpfreaks.com/topic/192214-so-simple-and-yet-it-wont-run/ 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()); Link to comment https://forums.phpfreaks.com/topic/192214-so-simple-and-yet-it-wont-run/#findComment-1012927 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. Link to comment https://forums.phpfreaks.com/topic/192214-so-simple-and-yet-it-wont-run/#findComment-1012929 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.