PHP - A Column Based Problem

I'm wondering how to do this with javascript for a table that i have made in php and html.

I want to hide the row for the table based on the value inside my first column for each row of the table.

Like if column 1 has "apple" inside it, then the row would not be shown.
I'm pretty sure this can be done in javascript but i'm not a coding guy, so any help would be appreciated!

My table.php file that has the table i want to do this for:
Code: [Select]
<script language="javascript">

imageX1='plus';
imageX2='plus';
imageX3='plus';

function toggleDisplay(e){
imgX="imagePM"+e;
tableX="table"+e;
imageX="imageX"+e;
tableLink="tableHref"+e;
imageXval=eval("imageX"+e);
element = document.getElementById(tableX).style;
 if (element.display=='none') {element.display='block';}
 else {element.display='none';}
 if (imageXval=='plus') {document.getElementById(imgX).src='http://www.pvpstreams.com/icons/wowicon.png';eval("imageX"+e+"='minus';");document.getElementById(tableLink).title='Hide WoW';}
 else {document.getElementById(imgX).src='http://www.pvpstreams.com/icons/wowicon.png';eval("imageX"+e+"='plus';");document.getElementById(tableLink).title='Show WoW';}
}
</script>

<?php
$username="user";
$password="password";
$tmp="database";

mysql_connect(localhost,$username,$password);
@mysql_select_db($tmp) or die( "Unable to select database");
$query="SELECT * FROM users";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();
?>
<table class="sortable" id="wow" border="1" cellpadding="0" cellspacing="0" style="margin-left:auto;margin-right:auto;text-align:left">
<tr>
<th><font face="Arial, Helvetica, sans-serif">Game</font></th>
<th><font face="Arial, Helvetica, sans-serif">Character</font></th>
<th><font face="Arial, Helvetica, sans-serif">Rating</font></th>
<th><font face="Arial, Helvetica, sans-serif"><img src="http://www.pvpstreams.com/table-images/xfirelogo.png">&nbsp;Status</font></th>
<th><font face="Arial, Helvetica, sans-serif"><img src="http://www.pvpstreams.com/table-images/xfirelogo.png">&nbsp;Link</font></th>
<th><font face="Arial, Helvetica, sans-serif">Realm</font></th>
<th><font face="Arial, Helvetica, sans-serif"><img src="http://www.pvpstreams.com/table-images/livestreamlogo.png">&nbsp;Status</font></th>
<th><font face="Arial, Helvetica, sans-serif"><img src="http://www.pvpstreams.com/table-images/livestreamlogo.png">&nbsp;Link</font></th>
<th><font face="Arial, Helvetica, sans-serif">Team&nbsp;Setup</font></th>
</tr>

<?php
$i=0;
while ($i < $num) {

$f1=mysql_result($result,$i,"wowcharacter");
$f2=mysql_result($result,$i,"username");
$f3=mysql_result($result,$i,"livestream");
$f4=mysql_result($result,$i,"wowserver");

$f5=mysql_result($result,$i,"wowplayer1");
$f6=mysql_result($result,$i,"wowplayer2");
$f9=mysql_result($result,$i,"wowplayer3");

$f7=mysql_result($result,$i,"wowrealm");
$f8=mysql_result($result,$i,"xfire");
$f10=mysql_result($result,$i,"xfirecheck");
$f11=mysql_result($result,$i,"wowrating");
?>

<tr>
<td><font face="Arial, Helvetica, sans-serif"><?php echo "<center><img src=http://www.pvpstreams.com/table-images/wowtable.png>"; ?></center></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo "<a class=blue href=http://$f4.battle.net/wow/en/character/$f7/$f1/simple>$f1</a>"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f11; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo "$f10"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo "<a class=blue href=http://www.pvpstreams.com/xfire.php?user=$f2>$f8</a>"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f7; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php include("livestreamcheck.php"); ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo "<a class=blue href=http://www.pvpstreams.com/livestream.php?user=$f2>$f3</a>"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo "<img src=http://www.pvpstreams.com/wclassicons/$f5.png><img src=http://www.pvpstreams.com/wclassicons/$f6.png><img src=http://www.pvpstreams.com/wclassicons/$f9.png>" ?></font></td>
</tr>


<?php
$i++;
}
?>
</table>

Dear All

I want to display my data in tabular columns with the headings of table  like 00:06-00:08,00:08-00:10,00:10:00:12:00........22:00-24:00.i.e.time
In database I have two columns one containing value and other containing time when this reading was done.
I could retrieve data from my mysql table in php and look at time.
I want to know how could I insert the value to the correct column of table based on the time.
e.g If I have record in table in database say containing value 09:45 and 5.
I want this value to go to the column heading 00:08-00:10 and same thing for the other values.

I hope I am clear with the problem definition but if you need more info.Please let me know.

Thanks,
elp

To accomplish the layout I was looking for, I used the following code:

for ($i=1; $i<=7; $i++)
   {

//set day of week for display as title of columns
$dow=date("l", strtotime($year.'W'."$weekno"."$i"));

echo "<td class=\"wvcolumn\" valign=\"top\">
<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" align=\"center\" width=\"$daycolumn\">
<tr><th class=\"wvtitle\" valign=\"bottom\" align=\"center\" width=\"$daycolumn\"><a class=\"titledate\" href=\"createticket.php?action=o&month=".date("m", strtotime($year.'W'."$weekno"."$i"))."&date=".date("d", strtotime($year.'W'."$weekno"."$i"))."&year=".date("Y", strtotime($year.'W'."$weekno"."$i"))."\">$dow, ".date("F d", strtotime($year.'W'.$weekno."$i"))."</a>&nbsp;<a onClick=\"window.open('http://www.batchgeo.com')\" title=\"Map $dow's Appointments\" href=\"mapday.php?week=$weekno&year=$year&day=$i\"><img width=\"20\" style=\"border-style: none\" src=\"../images/icon_globe.png\"></a></th></tr>";

if(date("Y-m-d")==date("Y-m-d", strtotime($year.'W'."$weekno"."$i"))) {
$query = "SELECT fieldtickets.ticketnumber, fieldtickets.business, title, apptdatetime, DATE_FORMAT(apptdatetime,'%h:%i %p') AS fapptdatetime, status, billstatus, type, assigntech, clients.business FROM fieldtickets LEFT JOIN clients ON fieldtickets.business = clients.id WHERE status='Open' AND (type = 'Field' OR type = 'Phone') AND apptdatetime BETWEEN '".date("Y-m-d", strtotime($year.'W'."$weekno"."$i"))." 00:00:00' AND '".date("Y-m-d", strtotime($year.'W'."$weekno"."$i"))." 23:59:59' UNION SELECT fieldtickets.ticketnumber, fieldtickets.business, title, apptdatetime, DATE_FORMAT(apptdatetime,'%h:%i %p') AS fapptdatetime, status, billstatus, type, assigntech, clients.business FROM fieldtickets LEFT JOIN clients ON fieldtickets.business = clients.id WHERE status = 'Pending' ORDER BY status ASC, apptdatetime ASC";
} else { $query = "SELECT fieldtickets.ticketnumber, fieldtickets.business, title, apptdatetime, DATE_FORMAT(apptdatetime,'%h:%i %p') AS fapptdatetime, status, billstatus, type, assigntech, clients.business FROM fieldtickets LEFT JOIN clients ON fieldtickets.business = clients.id WHERE status='Open' AND (type = 'Field' OR type = 'Phone') AND apptdatetime BETWEEN '".date("Y-m-d", strtotime($year.'W'.$weekno."$i"))." 00:00:00' AND '".date("Y-m-d", strtotime($year.'W'.$weekno."$i"))." 23:59:59' ORDER BY apptdatetime ASC"; }

$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result)){
//if ticket is open show appt time and business, if ticket pending display DELIVERY and business name
if($row[status]=="Open") { $href="createticket.php?action=e&ticket=".$row[ticketnumber]; $time=$row[fapptdatetime]; $delivery=""; } elseif($row[status]=="Pending") { $href="createticket.php?action=c&ticket=".$row['ticketnumber'].""; $time=""; $delivery="DELIVER"; }
echo "<tr><td valign=\"top\"><a title=\"".$row[ticketnumber]." - ".$row[title]."\" class=\"".$row[status]."\" href=\"$href\"><span>$delivery$time ".substr($row['business'], 0, $displaychars)."</span></a></td></tr>\n"; }

echo "</table>";

}

echo "</td></tr>
</table>";

Output is similar to this, and any existing "deliveries" are displayed under the current day.
 _________________________________________________ ______________
|     Monday     |     Tuesday     |    Wednesday    |     Thursday     |       Friday       |
|appointments |appointments |appointments     |appointments   |appointments

This works great, but requires 5 separate queries. My database is very small for now, so its not a big deal, but I know this can be done much more efficiently.

How can I query the whole week and put appointments in their corresponding tables (days)? Thank you for your help!

I am using this sql to filter records :

$query = "select * from mobileprices where range='5000'"()
 but i am getting this error message :
mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/dracra/public_html/a.com/range.php

range field contains product prices range and filled with 5000, 10000, 15000, 20000 etc.
I tried the following code to update the range values from numeric to text in phpmyadmin sql area :

Code: [Select]
UPDATE mobileprices
SET range='five'
WHERE range='5000'
but i am getting this error message :

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'range='five' WHERE range='5000'' at line 2

I am confused as there are thousands of records and manually updating it one by one will take so much time.
Anyone could help me out as how i can change numeric with text in range.

or there is any way by that sql could accept this :

$query = "select * from mobileprices where range='5000'"()

I need a solution, so please help me !!

Control problem based on two forms

Hello everyone,
I have a problem with the control of my two forms
principle it is good for the first form, but if I wanted to control my 2nd form, blocking ca
Here's the script:

Code: [Select]
<html>
<head>
<script type="text/javascript" >
function formValidation1(oEvent) {
oEvent = oEvent || window.event;
var txtField = oEvent.target || oEvent.srcElement;

var txt_nom_pereck1=true;
var msg=" ";
if(document.getElementById("txt_nom_pere").value.length < 3 ){ txt_nom_pereck1=false; msg = msg + "Your name should be minimun 3 char length";}
if(document.getElementById("txt_prenom_pere").value.length < 3 ){ txt_nom_pereck1=false; msg = msg + "Your name should be minimun 3 char length";}


if(txt_nom_pereck1){document.getElementById("submit_etape4").style.display='block'; }
else{document.getElementById("submit_etape4").style.display='none'; }
}

window.onload = function () {


var submit_etape4 = document.getElementById("submit_etape4");

var txt_nom_pere = document.getElementById("txt_nom_pere");
var txt_prenom_pere = document.getElementById("txt_prenom_pere");

var txt_courriel_pere = document.getElementById("txt_courriel_pere");
var txt_courriel_pere_conf = document.getElementById("txt_courriel_pere_conf");



var txt_nom_pereck1=false;
document.getElementById("submit_etape4").style.display='none';
txt_nom_pere.onkeyup = formValidation1;
txt_prenom_pere.onkeyup = formValidation1;

}

//************Partie 2 : ******/////////////////////////////

/*
function formValidation2(oEvent) {
oEvent = oEvent || window.event;
var txtField = oEvent.target || oEvent.srcElement;

var txt_nom_pereck2=true;
var msg=" ";

if(document.getElementById("txt_courriel_pere").value.length < 3 ){ txt_nom_pereck2=false; msg = msg + "Your name should be minimun 3 char length";}
if(document.getElementById("txt_courriel_pere_conf").value.length < 3 ){ txt_nom_pereck2=false; msg = msg + "Your name should be minimun 3 char length";}


if(txt_nom_pereck2){document.getElementById("submit_etape5").style.display='block'; }
else{document.getElementById("submit_etape5").style.display='none'; }
}

window.onload = function () {


var submit_etape5 = document.getElementById("submit_etape5");

var txt_courriel_pere = document.getElementById("txt_courriel_pere");
var txt_courriel_pere_conf = document.getElementById("txt_courriel_pere_conf");



var txt_nom_pereck2=false;
document.getElementById("submit_etape5").style.display='none';
txt_nom_pere.onkeyup = formValidation2;
txt_prenom_pere.onkeyup = formValidation2;
}

Je voulais activer cette partie pour comtrole le Form 2
Le probleme existe au niveau des nom des fonctions

I wanted this part to enable the Comtrol Form 2
The problem exists at the level of function names
*/
</script>

</head>
<body >
<form method=" post" action="form-success.php">
<table>
<tr>
<td>First Name</td>
<td><input type="text" id="txt_nom_pere" name="FirstName"></td>
</tr>
<tr>
<td>First Name</td>
<td><input type="text" id="txt_prenom_pere" name="FirstName"></td>
</tr>
</table>
<input type="button" id="submit_etape4" value="Sign Up!!" style="display:none;"  />
</form>




<form method=" post" action="form-success.php">
<table>
<tr>
<td>First Name</td>
<td><input type="text" id="txt_courriel_pere" name="FirstName"></td>
</tr>
<tr>
<td>First Name</td>
<td><input type="text" id="txt_courriel_pere_conf" name="FirstName"></td>
</tr>
</table>
<input type="button" id="submit_etape5" value="Sign Up!!" style="display:none;"  />
</form>


</body>
</html>