April 10th, 2013, 08:37 PM
Output the data into each different tags
I have stored data in a MySQL database and I've output it in PHP. I want to know how I can output the data in different <span id="text1">` tags from `<tr><td>` tags.
On my PHP page it show something like this:
$errmsg_arr = array();
$errflag = false;
$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
die('Failed to connect to server: ' . mysql_error());
$db = mysql_select_db(DB_DATABASE);
die("Unable to select database");
$_SESSION['ERRMSG_ARR'] = $errmsg_arr;
echo implode('<br />',$errmsg_arr);
$qrytable1="SELECT id, mydata FROM mydb ";
$result1=mysql_query($qrytable1) or die('Error:<br />' . $qry . '<br />' . mysql_error());
while ($row = mysql_fetch_array($result1))
How can I split the output the data into an array before I could output them in different <span id="text1">` tags from `<tr><td>` tags?
<tr><td>my data 1</td></tr><tr><td>my data 2</td></tr><tr><td>my data 3</td></tr><tr><td>my data 4</td></tr>
any advice would be much appreicated.
thanks in advance
April 11th, 2013, 07:55 AM
This is a duplicate of your previous post. You could have just edited it to fix the formatting. My other responses to the previous post still apply.
1) DO NOT use the deprecated MySQL extensions. Switch to PDO.
2) It is not clear what you mean by split into an array. Please provide an example of what you want the HTML to look like rather than what it currently is.
Comments on this post
Last edited by gw1500se; April 11th, 2013 at 07:58 AM.
There are 10 kinds of people in the world. Those that understand binary and those that don't.