R rotan New Member Aug 11, 2002 #1 please help me that how i can print the select result on my server. my os is linux and database is mysql.
please help me that how i can print the select result on my server. my os is linux and database is mysql.
Christopher New Member Aug 11, 2002 #2 PHP? Depends, if it is one result, you can go Code: $query = mysql_query("SELECT * FROM table WHERE sum='1'"); $result = mysql_fetch_array($query); print "Sum: ".$result[sum]."<br>"; But if it's more then one result, like search results, then something like this: Code: $query = mysql_query("SELECT * FROM table WHERE category='ya'"); while($result = mysql_fetch_array($query)) { print "Title: ".$result[title]."<br>"; print "Description: ".$result[description]."<br>"; } Assuming the propper table structure.
PHP? Depends, if it is one result, you can go Code: $query = mysql_query("SELECT * FROM table WHERE sum='1'"); $result = mysql_fetch_array($query); print "Sum: ".$result[sum]."<br>"; But if it's more then one result, like search results, then something like this: Code: $query = mysql_query("SELECT * FROM table WHERE category='ya'"); while($result = mysql_fetch_array($query)) { print "Title: ".$result[title]."<br>"; print "Description: ".$result[description]."<br>"; } Assuming the propper table structure.