Have you did an echo "<br>query = $sql_1 <br>"; Then you can copy an past in phpmyadmin and verify it works.
Just to check the query. Pat www.gypsyfarm.com<http://www.gypsyfarm.com> Never be afraid to try something new. Remember, amateurs built the ark, and professionals built the Titanic. From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Roshan Shahare Sent: Monday, December 17, 2007 4:36 AM To: roshan Shahare Subject: [php_mysql] (unknown) We are facing problem of the fetching the rows from the table which we created temprary we are able to fectch the recrods through the phpmyadmin but unable form code $sql_1 = "SELECT * FROM ".$tableNames." limit 0,10"; $res1_e = mysql_query($sql_1) or die(mysql_error()); $nrows =mysql_num_rows($res1_e); while($row_info = mysql_fetch_array($res1_e)) { echo "<br>".$row_info['id']; } --------------------------------- Now you can chat without downloading messenger. Click here to know how. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
