select cell from row, only display cell if contains data

martincrumlish

Hi,

I have the following script....pretty simple

<?php

include("dbconnect.php");
$query = "SELECT text14 FROM questions";
$result = mysql_query($query);
?>
<html>
<head>
<title>How can we improve paddypower.com?</title>
<style>
td{font-family:arial;font-size:10pt}
</style>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#FFFFFF" text="#000000">
<table width="760" border="1" cellspacing="0" cellpadding="5" align="center" bordercolor="#000000">
  <tr> 
    <td><b><font color="#FF0000">How can we improve paddypower.com?</font></b></td>
  </tr>
  <tr>
    <td>
    <!-- display details loop-->
	<?php
	while($row = mysql_fetch_array($result)){
	?>
      <table width="100%" border="0" cellspacing="0" cellpadding="5">
        <tr> 
          <td width="21%" bgcolor="#FFFFCC"><b>Feedback:</b></td>
          <td width="79%"><? echo $row[text14]?></td>
        </tr>
      </table>
      <hr width="100%" noshade align="center">
	  <?php } ?>
	  <!-- display details loop end -->
    </td>
  </tr>
</table>
</body>
</html>

This basically displaus whatever is in the cell text14 in the database. However, there are 13 other cells in each row. Not all of these cells have a value (text14 doesnt always have a value)

When i run the script above, it loops through every row and displays a blank cell if there is no value in text14 for that row. How can I make it work so that only text14 cells that have a value are displayed, regardless of whatever value are in other rows.

Thanks,
Martin

autocolismo

"SELECT text14 FROM questions WHERE text14 >'0'";

try this it may work

rheroux

You could also try this:

"SELECT text14 FROM questions WHERE text14 IS NOT NULL"

martincrumlish

Thanks, that worked 🙂

Also, do you know how I can make these 3 queries into 1 query?

	$query = "INSERT INTO details (title,name,age,internet,country,email) VALUES ('$title1','$name1','$age1','$internet1','$country1','$email1')";
	$result = mysql_query($query) or die(mysql_error);

$query1 = "INSERT INTO questions (q1,text1,q2,text2,q3,text3,q4,text4,q5,text5,q6,text6,q7,text7,q8,text8,q9,text9,q10,text10,q11,text11,q12,text12,q13,text13) VALUES ('$Q1','$text1','$Q2','$text2','$Q3','$text3','$Q4','$text4','$Q5','$text5','$Q6','$text6','$Q7','$text7','$Q8','$text8','$Q9','$text9','$Q10','$text10','$Q11','$text11','$Q12','$text12','$Q13','$text13')";
$result1 = mysql_query($query1) or die(mysql_error);

$query2 = "INSERT INTO feedback (text14) VALUES ('$text14')";
$result2 = mysql_query($query2) or die(mysql_error);

Thanks

rheroux

I don't know of any MySQL functions that can insert into 3 tables with one query. Check the manual though, you never know.

And breaking it up into 3 queries isn't that tough is it? 😉

martincrumlish

I was trying this because of a problem I had where if a user submitted the form then the PHP would insert 3 rows - 1 with the data and 2 empty rows. However, I have fixed this now....i thought it may have been because there were 3 queries.