Displaying data - Codewalkers

Codewalkers Forums Sponsor:

You eat, breathe and sleep innovation. Build your mobile intelligence with BlackBerry® experts this July. Register Today!

July 15th, 2003, 04:41 PM

Anonymous

Registered User

Codewalkers God 35th Plane (22000 - 22499 posts)

Join Date: Apr 2007

Posts: 22,309

Time spent in forums: < 1 sec
Reputation Power: 24

Displaying data

Hi,
I have created a database called 'pictures' and in it a table called 'info'. I have submitted some data into the table. I now come to the php,, this is what I have written:

php Code:

Original - php Code
<?php /* connect to db / @mysql_connect or die('Error connecting to MySQL.'); @mysql_select_db ('pictures') or die('Error connecting to database.'); / Retrieve the data / $query = "SELECT FROM info"; $result = mysql_query ($query); /* Display the data */ echo $result; ?>

 
<?php
 
/* connect to db */
@mysql_connect or die('Error connecting to MySQL.');
@mysql_select_db ('pictures') or die('Error connecting to database.');
 
 
/* Retrieve the data */
$query = "SELECT * FROM info";
$result = mysql_query ($query);
 
/* Display the data */
echo $result;
?>

However I get this message 'Resource id #2'. Please could you explain what I am doing wrong.
Thanks

July 15th, 2003, 04:48 PM

tkarkkainen

Moderator

Join Date: Apr 2007

Location: Finland

Posts: 2,320

Folding Points: 10700 Folding Title: Novice Folder

Time spent in forums: 6 Days 8 h 46 m 35 sec
Reputation Power: 4

RE: Displaying data

php Code:

Original - php Code
/* Display the data */ echo $result;

 
/* Display the data */
echo $result;

Change this to:

php Code:

Original - php Code
exho "<table>"; foreach(mysql_fetch_array($result) as $key => $value) { echo "<tr><td>$key</td><td>$value</td></tr>"; } exho "</table>";

 
exho "<table>";
foreach(mysql_fetch_array($result) as $key => $value) {
echo "<tr><td>$key</td><td>$value</td></tr>";
}
exho "</table>";

July 15th, 2003, 06:14 PM

sliver

Moderator

Join Date: Apr 2007

Location: WI, USA

Posts: 888

Time spent in forums: 21 h 17 m 29 sec
Reputation Power: 2

RE: Displaying data

Quote:

Change this to:

php:
exho "<table>";
foreach(mysql_fetch_array($result) as $key => $value) {
echo "<tr><td>$key</td><td>$value</td></tr>";
}
exho "</table>";
?>

2 errors in that code, it should be:

php Code:

Original - php Code
echo "<table>"; foreach(mysql_fetch_array($result) as $key => $value) { echo "<tr><td>$key</td><td>$value</td></tr>"; } echo "</table>"; ?>

 
echo "<table>";
foreach(mysql_fetch_array($result) as $key => $value) {
echo "<tr><td>$key</td><td>$value</td></tr>";
}
echo "</table>";
?>

Viewing: Codewalkers Forums > Other Technologies > Database Help > Displaying data

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump