Author Topic: [SOLVED] echo data from DB  (Read 81 times)

0 Members and 1 Guest are viewing this topic.

Offline denoteoneTopic starter

  • Enthusiast
  • Gender: Male
  • STRATACACHE.com NerdyLlama.com
    • View Profile
    • My Portfolio
[SOLVED] echo data from DB
« on: March 20, 2009, 04:10:40 PM »
I am having a hard time getting my data to to echo  can anyone see what i am doing wrong?

Code: [Select]
<table>
<tr>
<td>IP</td><td>Whois Data</td><td>time</td><td>Date</td><td>Reffer</td><td>Page Visited</td></tr>
<?php
$today
date("d");
require_once(
'visitors_connections.php')
mysql_select_db($database_visitors$visitors);
$query  "SELECT * FROM visitor_list WHERE visitor_day is equal to '$today'";
$result mysql_query($query);

while(
$row mysql_fetch_array($resultMYSQL_ASSOC))
{
    echo 
'<td>{$row['visitor_ip']} </td>
         <td>{$row['
visitor_whois']} </td>
         <td>{$row['
visitor_min']} : {$row['visitor_hour']} </td>
 <td>{$row['
visitor_day']} , {$row['visitor_month']} {$row['visitor_year']} </td>
 <td>{$row['
visitor_ref']}</td>
 <td>{$row['
visitor_page']}</td>';
}

?>


</table>
No, I didn't work it out upside down, I never turned it around.
- H. R. Giger  
 "Love you Julia" - Mike Rawers Co-Founder nerdyllama.com

Offline denoteoneTopic starter

  • Enthusiast
  • Gender: Male
  • STRATACACHE.com NerdyLlama.com
    • View Profile
    • My Portfolio
Re: echo data from DB
« Reply #1 on: March 20, 2009, 04:18:11 PM »
I made some tweaks....

Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<table>
<tr>
<td>IP</td><td>Whois Data</td><td>time</td><td>Date</td><td>Reffer</td><td>Page Visited</td></tr>
<tr>

<?PHP
ini_set("display_errors","2");
ERROR_REPORTING(E_ALL);

$today= date("d");
echo $today;
require_once('visitors_connections.php');
mysql_select_db($database_visitors, $visitors);
$query  = "SELECT * FROM visitor_list WHERE visitor_day = '$today'";
$result = mysql_query($query);

while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
    echo '<td>{$row['visitor_ip']} </td>
         <td>{$row['visitor_whois']} </td>
         <td>{$row['visitor_min']} : {$row['visitor_hour']} </td>
<td>{$row['visitor_day']} , {$row['visitor_month']} {$row['visitor_year']} </td>
<td>{$row['visitor_ref']}</td>
<td>{$row['visitor_page']}</td>';
}

?>


</tr>
</table>
</body>
</html>
No, I didn't work it out upside down, I never turned it around.
- H. R. Giger  
 "Love you Julia" - Mike Rawers Co-Founder nerdyllama.com

Offline revraz

  • Freak!
  • Gender: Male
  • Problems Resolved: 295
    • View Profile
Re: echo data from DB
« Reply #2 on: March 20, 2009, 04:21:30 PM »
Use mysql_error() after your query and the error should be apparent.

$result = mysql_query($query) or die (mysql_error());
If I can't make it better, then I'll make it worse, but it definitely won't be the same.

PHP Freaks Forums

« on: »

Tired of these ads? Purchase a supporter subscription to get rid of them.