JustinPhP Posted January 24, 2011 Share Posted January 24, 2011 echo <br>"; //put a break after each database entry } error Parse error: syntax error, unexpected '<', expecting ',' or ';' in /home/content/87/7333587/html/DepartmentC.php on line 24 SELECT `Orderdate`,`Orderid`,`Order_Comments`,`salesrep_customerid`,`productcode`,`productname`,`quantity`,`warehouselocation` FROM `Orders` WHERE `warehouselocation`=\'%j%\' how do i make this print the results Select Full Code Yes i kno connection details are missing but they work lol mysql_select_db($dbname, $chandle) or die ($dbname . " Database not found. " . $dbuser); $mainsection="Orders"; //The name of the table where web links are stored $query1='SELECT * FROM `Orders` WHERE `warehouselocation`Like \'%j%\'' . ' ORDER BY `Orderdate`'; $result = mysql_db_query($dbname, $query1) or die("Failed Query of " . $query1); //do the query while($thisrow=mysql_fetch_row($result)) { $i=0; while ($i < mysql_num_fields($result)) { $field_name=mysql_fetch_field($result, $i); echo $thisrow[$i] . " "; //Display all the fields on one line $i++; } echo </br>"; //put a break after each database entry } Quote Link to comment Share on other sites More sharing options...
mikecampbell Posted January 24, 2011 Share Posted January 24, 2011 echo </br>"; should be echo "</br>"; 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.