In a local database:
I have a field
content
in a table where I store numbers and symbols in the following format
{1,2,1,3,1,4,1,1,1} ∪ {1,2,198,776,455,666}
When I ran the query in my php code
SELECT * FROM table
and echo it in the web browser only
{1
is displayed I would like to mention that I used UTF-8 encoding for all my php scripts
and in addition when I connect to the database I use the following to set the charset
mysql_set_charset('utf8',$connection);
Can you post the query? It's a bit difficult to answer without seeing it.
Also what do you have the "content" field set as?
for example : VARCHAR, CHAR, DATE etc
CREATE TABLE db.content (id INT NOT NULL AUTO_INCREMENT ,que_id INT NULL ,que_content VARCHAR(300) NULL ,form VARCHAR(300) NULL ,
PRIMARY KEY (id) );
$que = mysql_query("SELECT id FROM content");
From the query youve shown, you are only retrieving the ID,
what is in 'que_id' and 'que_content' and 'form', You are not requesting them in your query.
You need something like
$query=mysql_query("SELECT * FROM content"):
while ($row=mysql_fetch_array($query))
{
$id=$row['id'];
$qid=$row['que_id'];
$content=$row['que_content'];
$form=$row['form'];
}
echo $id."<br>".$qid."<br>".$content."<br>".$form;
to echo out all of the db content, and you can filter out what you don't need.
I cannot distinguish your field data to where these math symbols and numbers were stored. can u have sample data for this topic?
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.