You may also want to look into the heredoc string literals. It may or may not help you with some of these longer "echo" commands. http://www.tizag.com/phpT/strings.php has a good explanation, and of course the bible is at http://us2.php.net/manual/en/language.types.string.php#language.types.string.syntax.heredoc. Thanks, Chris -----Original Message----- From: Patrick Price [mailto:superpatty@xxxxxxxxx] Sent: Fri 2/13/2009 9:52 PM To: Sashikanth Gurram Cc: php-db@xxxxxxxxxxxxx Subject: Re: Cannot print the data from database in the webpage I believe your problem is that the mysqli_fetch_array function on line 39 returns an enumerated array and the extract function on line 41 takes the values in an array and assigns it to an associative array based on the keys. Since the keys in an enumerated array are numbers, those are the variable names. I believe you will have an easier time if you do the following: while ($row=mysqli_fetch_array($data)) { $building = $row[0]; $parking_lot = $row[1]; $month = $row[2]; $day = $row[3]; $occupancy = $row[4]; $empty_spaces = $row[5]; $special_days = $row[6]; echo "<tr>\n <td>$building</td>\n <td>$parking_lot</td>\n <td>$month</td>\n <td>$day</td>\n <td>$occupancy</td>\n <td>$empty_spaces</td>\n <td>$special_days</td>\n </tr>\n"; echo "<tr><td colspan='7'><hr /></td></tr>\n"; } Now it is important in the order with which the fields are returned from the database since that will affect the row values when you are assigning them to variables (ie- if the day is returned first in the array it should be " $day = $row[0]" ) Hope that helps Thanks patrick Sent from: Decatur Ga United States. On Sat, Feb 14, 2009 at 12:05 AM, Sashikanth Gurram <sashi34u@xxxxxx> wrote: > Hi all, > > I am trying to run a query to retrieve data from mysql database and display > it in a webpage in a table. The query is running fine, but the the data is > not appearing on the webpage. All I see is a webpage with few empty cells. > The echo command starting from line 42 is something like this > *echo "<tr>\n > <td>$building</td>\n > <td>$parking_lot</td>\n <td>$month</td>\n > <td>$day</td>\n > <td>$occupancy</td>\n > <td>$empty_spaces</td>\n > <td>$special_days</td>\n > </tr>\n";* > > The variables I have used here ie., $building, $parking_lot etc are nothing > but the column names in the mysql database ie., building, parking_lot etc. I > hope I did not mess up in that sense. But, I do not know the reason for the > non appearance of the data. > > I am posting the whole code below. Also I am attaching a screenshot of the > display in the webpage. If anyone has any answer please let me know. > > Thanks > Sashi > > <?php > > // Connects to your Database > $host="******"; > $user="******"; > $password="******"; > $dbname="******"; > $cxn=mysqli_connect($host, $user, $password, $dbname) ; > if (!$cxn=mysqli_connect($host, $user, $password, $dbname)) > { > $error=mysqli_error($cxn); > echo "$error"; > die(); > } > else > { > echo "Connection established successfully"; > } > > $sql="SELECT * FROM occupancy"; > $data = mysqli_query($cxn,$sql); > if (!$data=mysqli_query($cxn,$sql)) > { > $error=mysqli_error($cxn); > echo "$error"; > die(); > } > else > { > echo "<br>"; > echo "Query sent successfully"; > } > > > echo "<br>"; > echo "<h1> OCCUPANCY <h1>"; > echo "<table cellspacing='0'>"; > echo "<tr><td colspan='7'><hr /></td></tr>"; > while ($row=mysqli_fetch_array($data)) > { > extract($row); > echo "<tr>\n > <td>$building</td>\n > <td>$parking_lot</td>\n > <td>$month</td>\n <td>$day</td>\n > <td>$occupancy</td>\n > <td>$empty_spaces</td>\n > <td>$special_days</td>\n > </tr>\n"; > echo "<tr><td colspan='7'><hr /></td></tr>\n"; > } > echo "</table>\n"; > > > ?> > > -- > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > Sashikanth Gurram > Graduate Research Assistant > Department of Civil and Environmental Engineering > Virginia Tech > Blacksburg, VA 24060, USA > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >
