Where did i make mistake?

Dakkar

I am trying to write a simple portal system and there is no error for beggining but its showing wrong data from mysql i couldnt solve the problem can anybody help me here is my php code and mysql

Mysql

# phpMyAdmin SQL Dump
# version 2.5.4
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Feb 29, 2004 at 05:23 PM
# Server version: 4.0.16
# PHP Version: 4.3.4
# 
# Database : `portal`
# 

# --------------------------------------------------------

#
# Table structure for table `syl_cs_text`
#

CREATE TABLE `syl_cs_text` (
  `post_id` mediumint(8) unsigned NOT NULL default '0',
  `post_subject` varchar(60) default NULL,
  `post_text` text,
  PRIMARY KEY  (`post_id`)
) TYPE=MyISAM;

#
# Dumping data for table `sylveria_cs_text`
#


# --------------------------------------------------------

#
# Table structure for table `syl_sc_text`
#

CREATE TABLE `syl_sc_text` (
  `post_id` mediumint(8) unsigned NOT NULL default '0',
  `post_subject` varchar(60) default NULL,
  `post_text` text,
  PRIMARY KEY  (`post_id`)
) TYPE=MyISAM;

#
# Dumping data for table `syl_sc_text`
#


# --------------------------------------------------------

#
# Table structure for table `syl_uo_text`
#

CREATE TABLE `syl_uo_text` (
  `post_id` mediumint(8) unsigned NOT NULL default '0',
  `post_subject` varchar(60) default NULL,
  `post_text` text,
  PRIMARY KEY  (`post_id`)
) TYPE=MyISAM;

#
# Dumping data for table `syl_uo_text`
#

INSERT INTO `syl_uo_text` VALUES (1, 'Asd', '122456789645');
INSERT INTO `syl_uo_text` VALUES (2, 'This subject', 'Aman yava? yollar ya?');
INSERT INTO `syl_uo_text` VALUES (3, 'Abc', 'abcdefg ');
INSERT INTO `syl_uo_text` VALUES (4, 'Dark Lord', 'One ring to the dark lords hand sitting on his throne');
INSERT INTO `syl_uo_text` VALUES (5, 'In a land so dark', 'Where i have to go');

Php Code:

<html>

<head>
<meta http-equiv="Content-Language" content="tr">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1254">
<title>PORTAL MANAGEMENT</title>
</head>

<body bgcolor="#C0C0C0">

<p align="center"><u><font face="Arial Black" size="4">PORTAL MANAGAMENT</font></u></p>
<hr>
<ul>
  <li>
  <p align="left">

<?

@mysql_connect("localhost", "root", "")
    or die("Veritabani ile baglanti kurulamadi!");
@mysql_select_db("portal")
    or die("Veritabaninda bir hata olustu!");


$sql = "SELECT post_text FROM syl_uo_text WHERE post_id = '1'";
$res = mysql_query($sql) OR die(mysql_error());

echo "$res";

?>

</li>

  <li>
  <p align="left">
<?


$sql2 = "SELECT post_text FROM syl_uo_text WHERE post_id = '2'";
$res2 = mysql_query($sql2) OR die(mysql_error());

echo "$res2";
?>
</li>
  <li>
  <p align="left">
<?

$sql3 = "SELECT post_text FROM syl_uo_text WHERE post_id = '3'";
$res3 = mysql_query($sql3) OR die(mysql_error());

echo "$res3";
?>
</li>
  <li>
  <p align="left">

<?

$sql4 = "SELECT post_text FROM syl_uo_text WHERE post_id = '4'";

$res4 = mysql_query($sql4) OR die(mysql_error());

echo "$res4";

?>
</li>
  <li>
  <p align="left">

<?

$sql5 = "SELECT post_text FROM syl_uo_text WHERE post_id = '5'";
$res5 = mysql_query($sql5) OR die(mysql_error());

echo "$res5";

?>
</li>
</ul>
<p align="left">&nbsp;</p>
<p align="left">&nbsp;</p>

</body>

</html>

and when i use this php code its showing the datas like this

Resource id #3 

Resource id #4

Resource id #5

Resource id #6

Resource id #7

Where is the problem?

yelvington

PHP is complaining at you with good cause. The problem is that you're trying to echo resources and that's now how it works.

A resource is an abstract bucket of potentially many records of potentially great complexity.

In order to get at the underlying data you must loop through the resource using one of the mysql_fetch_* functions and refer to specific columns.

There is plenty of example code in the manual.

Dakkar

which command should i use after mysql_fetch_ for this issue?

CaptianChaos

Try this:

$sql = "SELECT post_text FROM syl_uo_text WHERE post_id = '1'";
$res = mysql_query($sql) OR die(mysql_error());
$row = mysql_fetch_row($res);
print_r($row);

Dakkar

Ok i changed it and it s printing the mysql data but there is still an error its showing like this

Array ( [0] => One ring to the dark lords hand )

How can i delete Array ( [0] => part?

Thanks

yelvington

http://www.php.net/mysql

mysql_fetch_array, mysql_fetch_assoc, mysql_fetch_row and mysql_fetch_object all do roughly the same thing. Which one you use may be a matter of personal preference.

The following are equivalent:

while($row = mysql_fetch_array($res))
echo "post_text is $row[post_text]";

while($row = mysql_fetch_assoc($res))
echo "post_text is $row[post_text]";

while($row = mysql_fetch_object($res))
echo "post_text is $row->post_text";

Dakkar

Thanks so much to everyone

Dakkar

I tried your ways but i still couldnt delete the
Array ( [0] => lines what must i do?

nemonoman

remove this line from your code:

print_r($row);

Weedpacket

As in

The [man]print_r[/man] manual page
print_r -- Prints human-readable information about a variable

Dakkar

so what must i do
if i delete print_r what should i write instead of it
or if i shouldnt delete print_r where is the problem?

timmytock

bump, im having same problems

yelvington

Did you look at the manual?

This is not a hard problem. Explicit source code examples are on EVERY page for EVERY one of the mysql_fetch_* functions.

Dakkar

I looked at the print_r tutorial but i couldnt find anything usefull for removing Array ( [0] => lines

rweston002

Originally posted by Dakkar
I looked at the print_r tutorial but i couldnt find anything usefull for removing Array ( [0] => lines

Should read the manual to get a better understanding.

print_r prints out array's and by default, inserts the "Array ([index] => Value"

But if you know the index, and in this case seems to be only one, then do:

echo ($row[0]);

Now go read that manual. 😉