Topic awaiting preservation: problems with mysql database (Page 1 of 1) $Pages that link to <a href="https://ozoneasylum.com/backlink?for=12970" title="Pages that link to Topic awaiting preservation: problems with mysql database (Page 1 of 1)" rel="nofollow" >Topic awaiting preservation: problems with mysql database <span class="small">(Page 1 of 1)</span>\$

sabina Obsessive-Compulsive (I) Inmate From: franc paris Insane since: Oct 2003	posted 11-05-2003 13:27 I am writing this code <html> <head> <title></title> </head> <body> <?php $link = mysql_connect("localhost", "administrator", "") or die ("Could not connect to MySQL"); mysql_select_db ("test") or die ("Could not select database"); $query = "SELECT * FROM votimi"; $result = mysql_query ($query) or die ("Query failed"); // printing HTML result print "<table>\n"; while ($line = mysql_fetch_array($result)) { print "\t<tr>\n"; while(list($col_name, $col_value) = each($line)) { print "\t\t<td>$col_value</td>\n"; echo $col_value; } print "\t</tr>\n"; } print "</table>\n"; ?> </body> </html> I am riciving this 3 3 4 4 5 5 5 5 5 5 but my database in mysql loks like this votat ----- 3 4 5 5 5 the answer is why i am reciving two colums i want to recive one column like in mysql lklkjlkj
Tyberius Prime Paranoid (IV) Mad Scientist with Finglongers From: Germany Insane since: Sep 2001	posted 11-05-2003 13:50 well, you are printing $col_value twice... drop the echo, that should work... print "\t\t<td>$col_value</td>\n"; echo $col_value; so long, Tyberius Prime

Topic awaiting preservation: problems with mysql database (Page 1 of 1) $Pages that link to <a href="https://ozoneasylum.com/backlink?for=12970" title="Pages that link to Topic awaiting preservation: problems with mysql database (Page 1 of 1)" rel="nofollow" >Topic awaiting preservation: problems with mysql database <span class="small">(Page 1 of 1)</span>\$

sabina
Obsessive-Compulsive (I) Inmate

From: franc paris
Insane since: Oct 2003

posted 11-05-2003 13:27

I am writing this code

<html>

<head>
<title></title>
</head>

<body>

<?php

$link = mysql_connect("localhost", "administrator", "")
or die ("Could not connect to MySQL");

mysql_select_db ("test")
or die ("Could not select database");
$query = "SELECT * FROM votimi";
$result = mysql_query ($query)
or die ("Query failed");

// printing HTML result

print "<table>\n";
while ($line = mysql_fetch_array($result)) {
print "\t<tr>\n";
while(list($col_name, $col_value) = each($line)) {
print "\t\t<td>$col_value</td>\n";
echo $col_value;
}
print "\t</tr>\n";
}
print "</table>\n";

?>

</body>

</html>

I am riciving this

3 3
4 4
5 5
5 5
5 5

but my database in mysql loks like this

votat
-----
3
4
5
5
5

the answer is why i am reciving two colums
i want to recive one column like in mysql

lklkjlkj

Tyberius Prime
Paranoid (IV) Mad Scientist with Finglongers

From: Germany
Insane since: Sep 2001

posted 11-05-2003 13:50

well, you are printing $col_value twice...

drop the echo, that should work...

print "\t\t<td>$col_value</td>\n";
echo $col_value;

so long,

Tyberius Prime

Maximum Security
OZONE
DHTML/Javascript
Server-Side Scripting - Oh my!
CSS - DOM - XHTML - XML - XSL - XSLT
Stupid Basic HTML
Visual Therapy
Photoshop
Photoshop Pong, Anyone?
*WARNING* BIG SIG APPROACHING
Photography
3D Modelling & Rendering
Multimedia/Animation
Print Graphics
Holding Pens
Philosophy and other Silliness
Outpatient Counseling
Site reviews!
Mad Scientists' Laboratory
Getting to know the Grail

Maximum Security

OZONE

DHTML/Javascript

Server-Side Scripting - Oh my!

CSS - DOM - XHTML - XML - XSL - XSLT

Stupid Basic HTML

Visual Therapy

Photoshop

Photoshop Pong, Anyone?

***WARNING*** BIG SIG APPROACHING

Photography

3D Modelling & Rendering