pixeltrace
-
Posts
577 -
Joined
-
Last visited
Never
Everything posted by pixeltrace
-
i think the problem is with the porder.php page. i tried assigning and id =1 in the product_id [code]<?php include '../db_connect.php'; $uSql = "SELECT product_image, product_name, product_desc, product_type, product_price FROM products WHERE product_id= '1'"; $uResult = mysql_query($uSql, $connection) or die("Error: ". mysql_error(). " with query ". $uSql); $uRow = mysql_fetch_array($uResult); ?>[/code] and the porder.php was able to populate the data for that specific id. what could be wrong on my page? why is it not getting the id number from my previous page? need help. thanks!
-
its still not populating. :( what else is missing here? i even tried changing my first page. goto http://www.sinagtala.net/products.php?url=products/painting.php ----------- this is the script for that page----------------- [code]<html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Untitled Document</title> <link href="../CSS.css" rel="stylesheet" type="text/css"> <style type="text/css"> <!-- body { margin-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; background-color: #E7E7DD; } --> </style></head> <body> <table width="500" border="0" cellspacing="0" cellpadding="0"> <tr> <td><form method='post' action='porder.php'> <? include '../db_connect.php'; $uSql = "SELECT product_image, product_name, product_type, product_desc, product_price, product_id FROM products WHERE product_type = 'painting' "; $uResult = mysql_query($uSql, $connection); if(!$uResult){ echo 'no data found'; } else{ while($uRow = mysql_fetch_row($uResult)){ ?> <table width="500" border="0" cellspacing="0" cellpadding="0"> <tr> <td colspan="7"><img src="../images/spacer.gif" width="10" height="10"></td> </tr> <tr> <td width="14" rowspan="3"><img src="../images/spacer.gif" width="10" height="10"></td> <td width="84" rowspan="3" align="center" valign="top"><a href="../images/products/<?= $uRow[0]?>.jpg" target="_blank" class="fotgal"><img src="../images/products/thumbs/<?= $uRow[0]?>.gif" width="70" height="69" border="0"></a></td> <td width="10" rowspan="3"><img src="../images/spacer.gif" width="10" height="10"></td> <td width="243"><span class="bodytext3"> <?= $uRow[1]?> </span></td> <td colspan="2" valign="top"><span class="bodytext">| <?= $uRow[2]?> </span></td> <td width="10" rowspan="3"><img src="../images/spacer.gif" width="10" height="10"></td> </tr> <tr> <td colspan="3"><span class="bodytext6"> <?= $uRow[3]?> </span></td> </tr> <tr> <td><span class="bodytext3"> <?= $uRow[4]?> </span></td> <td width="42"> </td> <td width="97" align="center"><input name="submit" type="submit" value="Order Now"> <input type=hidden value=<?= $uRow[5]?> name=product_id> </td> </tr> <tr> <td colspan="7"><img src="../images/spacer.gif" width="10" height="10"></td> </tr> <tr> <td colspan="3"> </td> <td colspan="3"><span class="bodytext">--------------------------------------------------------------------------------------------</span></td> <td> </td> </tr> </table> <? } } ?></form> </td> </tr> </table> </body> </html> [/code] but its producing the same result. the porder.php is still not populating
-
yes, its already uploaded to my site and it has a database. im totally messed up with this. what should be the proper query for my sql? thanks!
-
sorry about that. i have removed the comma already and the porder.php is appearing already but the data is not populating. what else is wrong on my script? thanks in advance!
-
this is my porder.php script now ---------------- <? $product_id = $_GET['product_id']; ?> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Untitled Document</title> <link href="../CSS.css" rel="stylesheet" type="text/css"> <style type="text/css"> <!-- body { margin-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; background-color: #E7E7DD; } --> </style></head> <body> <table width="500" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="18" align="center"> <? include '../db_connect.php'; $uSql = "SELECT product_image, product_name, product_desc, product_type, product_price, FROM products WHERE product_id= '$product_id' "; $uResult = mysql_query($uSql, $connection) or die("Error: ". mysql_error(). " with query ". $uSql); ?> <table width="408" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="408" align="center">You have ordered </td> </tr> <tr> <td align="center"> <table width="36" border="1" cellpadding="0" cellspacing="0" bordercolor="#666666"> <tr> <td width="32" align="center"><img src="../images/products/thumbs/<?= $uRow[0]?>.jpg"></td> </tr> </table></td> </tr> <tr> <td><img src="../images/spacer.gif" width="4" height="4"></td> </tr> <tr> <td bg bgcolor="#E14B19"><img src="../images/spacer.gif" width="4" height="1"></td> </tr> <tr> <td><img src="../images/spacer.gif" width="4" height="4"></td> </tr> <tr> <td align="center"><?= $uRow[1] ?></td> </tr> <tr> <td align="center"><?= $uRow[2] ?></td> </tr> <tr> <td align="center"><?= $uRow[3] ?></td> </tr> <tr> <td><img src="../images/spacer.gif" width="4" height="4"></td> </tr> <tr> <td bg bgcolor="#E14B19"><img src="../images/spacer.gif" width="4" height="1"></td> </tr> <tr> <td><img src="../images/spacer.gif" width="4" height="4"></td> </tr> <tr> <td> </td> </tr> <tr> <td> </td> </tr> <tr> <td> </td> </tr> <tr> <td> </td> </tr> </table> </td> </tr> </table> </body> </html> ------------------ and this is the error message ------------------ Error: 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 'FROM products WHERE product_id= ''' at line 1 with query SELECT product_image, product_name, product_desc, product_type, product_price, FROM products WHERE product_id= ''
-
this is my code for the porder.php ---------- <? $product_id = $_GET['product_id']; ?> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Untitled Document</title> <link href="../CSS.css" rel="stylesheet" type="text/css"> <style type="text/css"> <!-- body { margin-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; background-color: #E7E7DD; } --> </style></head> <body> <table width="500" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="18" align="center"> <? include '../db_connect.php'; $uSql = "SELECT product_image, product_name, product_desc, product_type, product_price, FROM products WHERE product_id= '$product_id' "; $uResult = mysql_query($uSql, $connection); if(!$uResult){ echo 'no data found'; } else{ while($uRow = mysql_fetch_row($uResult)){ ?> <table width="408" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="408" align="center">You have ordered </td> </tr> <tr> <td align="center"> <table width="36" border="1" cellpadding="0" cellspacing="0" bordercolor="#666666"> <tr> <td width="32" align="center"><img src="../images/products/thumbs/<?= $uRow[0]?>.jpg"></td> </tr> </table></td> </tr> <tr> <td><img src="../images/spacer.gif" width="4" height="4"></td> </tr> <tr> <td bg bgcolor="#E14B19"><img src="../images/spacer.gif" width="4" height="1"></td> </tr> <tr> <td><img src="../images/spacer.gif" width="4" height="4"></td> </tr> <tr> <td align="center"><?= $uRow[1] ?></td> </tr> <tr> <td align="center"><?= $uRow[2] ?></td> </tr> <tr> <td align="center"><?= $uRow[3] ?></td> </tr> <tr> <td><img src="../images/spacer.gif" width="4" height="4"></td> </tr> <tr> <td bg bgcolor="#E14B19"><img src="../images/spacer.gif" width="4" height="1"></td> </tr> <tr> <td><img src="../images/spacer.gif" width="4" height="4"></td> </tr> <tr> <td> </td> </tr> <tr> <td> </td> </tr> <tr> <td> </td> </tr> <tr> <td> </td> </tr> </table> <? } } ?> </td> </tr> </table> </body> </html>
-
this is my code for the product item page ---------------- <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Untitled Document</title> <link href="../CSS.css" rel="stylesheet" type="text/css"> <style type="text/css"> <!-- body { margin-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; background-color: #E7E7DD; } --> </style></head> <body> <table width="500" border="0" cellspacing="0" cellpadding="0"> <tr> <td> <? include '../db_connect.php'; $uSql = "SELECT product_image, product_name, product_type, product_desc, product_price, product_id FROM products ORDER by product_type"; $uResult = mysql_query($uSql, $connection); if(!$uResult){ echo 'no data found'; } else{ while($uRow = mysql_fetch_row($uResult)){ ?> <table width="500" border="0" cellspacing="0" cellpadding="0"> <tr> <td colspan="7"><img src="../images/spacer.gif" width="10" height="10"></td> </tr> <tr> <td width="14" rowspan="3"><img src="../images/spacer.gif" width="10" height="10"></td> <td width="84" rowspan="3" align="center" valign="top"> <a href="../images/products/<?= $uRow[0]?>.jpg" target="_blank" class="fotgal"><img src="../images/products/thumbs/<?= $uRow[0]?>.gif" width="70" height="69" border="0"></a></td> <td width="10" rowspan="3"><img src="../images/spacer.gif" width="10" height="10"></td> <td width="243"><span class="bodytext3"> <?= $uRow[1]?> </span></td> <td colspan="2" valign="top"><span class="bodytext">| <?= $uRow[2]?> </span></td> <td width="10" rowspan="3"><img src="../images/spacer.gif" width="10" height="10"></td> </tr> <tr> <td colspan="3"><span class="bodytext6"> <?= $uRow[3]?> </span></td> </tr> <tr> <td><span class="bodytext3"> <?= $uRow[4]?> </span></td> <td width="42"> </td> <td width="97" align="center"><a href="porder.php?$product_id=<?= $uRow[5] ?>" class="bodytext7">Order Now</a> </td> </tr> <tr> <td colspan="7"><img src="../images/spacer.gif" width="10" height="10"></td> </tr> <tr> <td colspan="3"> </td> <td colspan="3"><span class="bodytext">--------------------------------------------------------------------------------------------</span></td> <td> </td> </tr> </table> <? } } ?> </td> </tr> </table> </body> </html>
-
guys i need help please check http://www.sinagtala.net/products.php try clicking on the "order now" link on the product items notice that the next page is telling me no data found. whats wrong with my script? below is the script for my products page (iframe page) -------------- <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Untitled Document</title> <link href="../CSS.css" rel="stylesheet" type="text/css"> <style type="text/css"> <!-- body { margin-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; background-color: #E7E7DD; } --> </style></head> <body> <table width="500" border="0" cellspacing="0" cellpadding="0"> <tr> <td> <? include '../db_connect.php'; $uSql = "SELECT product_image, product_name, product_type, product_desc, product_price, product_id FROM products ORDER by product_type"; $uResult = mysql_query($uSql, $connection); if(!$uResult){ echo 'no data found'; } else{ while($uRow = mysql_fetch_row($uResult)){ ?> <table width="500" border="0" cellspacing="0" cellpadding="0"> <tr> <td colspan="7"><img src="../images/spacer.gif" width="10" height="10"></td> </tr> <tr> <td width="14" rowspan="3"><img src="../images/spacer.gif" width="10" height="10"></td> <td width="84" rowspan="3" align="center" valign="top"> <a href="../images/products/<?= $uRow[0]?>.jpg" target="_blank" class="fotgal"><img src="../images/products/thumbs/<?= $uRow[0]?>.gif" width="70" height="69" border="0"></a></td> <td width="10" rowspan="3"><img src="../images/spacer.gif" width="10" height="10"></td> <td width="243"><span class="bodytext3"> <?= $uRow[1]?> </span></td> <td colspan="2" valign="top"><span class="bodytext">| <?= $uRow[2]?> </span></td> <td width="10" rowspan="3"><img src="../images/spacer.gif" width="10" height="10"></td> </tr> <tr> <td colspan="3"><span class="bodytext6"> <?= $uRow[3]?> </span></td> </tr> <tr> <td><span class="bodytext3"> <?= $uRow[4]?> </span></td> <td width="42"> </td> <td width="97" align="center"><a href="porder.php?$product_id=<?= $uRow[5] ?>" class="bodytext7">Order Now</a> </td> </tr> <tr> <td colspan="7"><img src="../images/spacer.gif" width="10" height="10"></td> </tr> <tr> <td colspan="3"> </td> <td colspan="3"><span class="bodytext">--------------------------------------------------------------------------------------------</span></td> <td> </td> </tr> </table> <? } } ?> </td> </tr> </table> </body> </html> -------------- and this is the script for the next page ------------- <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Untitled Document</title> <link href="../CSS.css" rel="stylesheet" type="text/css"> <style type="text/css"> <!-- body { margin-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; background-color: #E7E7DD; } --> </style></head> <body> <table width="500" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="18" align="center"> <? include '../db_connect.php'; $uSql = "SELECT product_image, product_name, product_desc, product_type, product_price, FROM products WHERE product_id= '$product_id' "; $uResult = mysql_query($uSql, $connection); if(!$uResult){ echo 'no data found'; } else{ while($uRow = mysql_fetch_row($uResult)){ ?> <table width="408" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="408" align="center">You have ordered </td> </tr> <tr> <td align="center"> <table width="36" border="1" cellpadding="0" cellspacing="0" bordercolor="#666666"> <tr> <td width="32" align="center"><img src="../images/products/thumbs/<?= $uRow[0]?>.jpg"></td> </tr> </table></td> </tr> <tr> <td><img src="../images/spacer.gif" width="4" height="4"></td> </tr> <tr> <td bg bgcolor="#E14B19"><img src="../images/spacer.gif" width="4" height="1"></td> </tr> <tr> <td><img src="../images/spacer.gif" width="4" height="4"></td> </tr> <tr> <td align="center"><?= $uRow[1] ?></td> </tr> <tr> <td align="center"><?= $uRow[2] ?></td> </tr> <tr> <td align="center"><?= $uRow[3] ?></td> </tr> <tr> <td><img src="../images/spacer.gif" width="4" height="4"></td> </tr> <tr> <td bg bgcolor="#E14B19"><img src="../images/spacer.gif" width="4" height="1"></td> </tr> <tr> <td><img src="../images/spacer.gif" width="4" height="4"></td> </tr> <tr> <td> </td> </tr> <tr> <td> </td> </tr> <tr> <td> </td> </tr> <tr> <td> </td> </tr> </table> </td> </tr> </table> </body> </html> --------------- hope you can help me with this. thanks!
-
help on my submitting updates to database
pixeltrace replied to pixeltrace's topic in PHP Coding Help
i just remove the $eventimage and $eventpopup and then, i tried checking it by filling up all the fields in the form and this is the error message after clicking the submit button --------------- 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 '', '')' at line 2 --------------- whats wrong with my script? i need help on this thanks! -
help on my submitting updates to database
pixeltrace replied to pixeltrace's topic in PHP Coding Help
this is the sript for my confirmation page -------------------- http://www.sinagtala.net/eric/eventupdate.phps -------------------- thanks in advance! -
help on my submitting updates to database
pixeltrace replied to pixeltrace's topic in PHP Coding Help
this is the script for my form page -------------------- <TBODY> <TR><TD vAlign=top><form id="form1" name="form1" method="post" action="eventupdate.php"> <table width="761" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="435"><table width="431" border="0" cellspacing="0" cellpadding="0"> <tr> <td colspan="2" class="bodytext3">Add Sinagtala Events Here </td> </tr> <tr> <td colspan="2"><img src="../images/spacer.gif" width="10" height="30" /></td> </tr> <tr> <td width="97" class="bodytext3">Event Title: </td> <td width="334"><input name="EventTitle" type="text" class="newsletter" size="50" maxlength="100" /> </td> </tr> <tr> <td colspan="2" class="bodytext3"><img src="../images/spacer.gif" width="10" height="10" /></td> </tr> <tr> <td class="bodytext3">Event Type : </td> <td><input name="EventType" type="text" class="newsletter" size="50" maxlength="100" /></td> </tr> <tr> <td class="bodytext3"> </td> <td><span class="bodytext2">event types:</span><span class="bodytext6"> corporate, past, private, sponsored, tour</span> </td> </tr> <tr> <td colspan="2" class="bodytext3"><img src="../images/spacer.gif" width="10" height="10" /></td> </tr> <tr> <td class="bodytext3">Event Date </td> <td><input name="EventDate" type="text" class="newsletter" size="20" maxlength="100" /> <span class="bodytext2">Format:</span><span class="bodytext6"> YY MD (eg. 2005 jan01)</span> </td> </tr> <tr> <td class="bodytext3">Description:</td> <td><textarea name="EventDescription" cols="50" rows="10" class="newsletter2"></textarea></td> </tr> <tr> <td colspan="2" class="bodytext3"><img src="../images/spacer.gif" width="10" height="10" /></td> </tr> <tr> <td class="bodytext3">image name: </td> <td><input name="EventImage" type="text" class="newsletter" size="25" maxlength="100" /> </td> </tr> <tr> <td class="bodytext3"> </td> <td> <span class="bodytext2">* image name is the image filename</span></td> </tr> <tr> <td colspan="2" class="bodytext3"><img src="../images/spacer.gif" width="10" height="10" /></td> </tr> <tr> <td class="bodytext3">pop-up link </td> <td><input name="Eventpopup" type="text" class="newsletter" size="25" maxlength="100" /></td> </tr> <tr> <td class="bodytext3"> </td> <td> <span class="bodytext2">* pop-up link is the pop-up pagename </span></td> </tr> <tr> <td colspan="2"><img src="../images/spacer.gif" width="10" height="10" /></td> </tr> <tr> <td> </td> <td><input class="mybutton" type="submit" name="Submit" value="SUBMIT" /></td> </tr> <tr> <td colspan="2"> </td> </tr> </table></td> <td width="11"><span class="bodytext3"><img src="../images/spacer.gif" width="10" height="10" /></span></td> <td width="1" bgcolor="#A2330F"><span class="bodytext3"><img src="../images/spacer.gif" width="1" height="10" /></span></td> <td width="11"><span class="bodytext3"><img src="../images/spacer.gif" width="10" height="10" /></span></td> <td width="292" valign="top"><div align="center" class="bodytext3"><br><br>On this page, you can add Sinagtala Events<br> using the form on the left side. </div></td> <td width="11"><span class="bodytext3"><img src="../images/spacer.gif" width="10" height="10" /></span></td> </tr> </table> </form> ---------------------------- -
guys, i need help on this, i have to page 1 - for the form page (wherein i fill up the form and submit) 2 - confirmation page (this page will check the data and submit it to my database) my problem is i keep on getting the error messages that i made although the fields that needs to be fillup are inputted. also i have a condition here - if my $EventImage is fillup, it will submit '2' as the value of $EventImageLink otherwise, it will submit '1' as its value - if $Eventpopup is not filled up, it will just submit '1' as the value of $Eventpopup
-
thank bro! it worked!
-
sorry about the mess, im just really not good at this yet. this is the script by the way of my news page -------- http://www.sinagtala.net/eric/news.phps
-
by the way, that script is for my news page http://www.sinagtala.net/news.php for products page everything is working fine. except for the select category section. if you click any of the catergories (all products, painting, cds, books) it will just point you to the allproducst page which is prodall.php -------- also, here is the script of my select category section -------- <form method="POST" style="margin:0" name="form" action="products/prodall.php"> <table width="135" border="0" cellspacing="0" cellpadding="0"> <tr> <td colspan="2" align="left"><img src="images/productcategory.gif" width="206" height="24"></td> </tr> <tr> <td width="30" rowspan="3" align="left"><img src="images/productbar3.gif" width="30" height="75"></td> <td width="176" valign="top"><img src="images/spacer.gif" width="10" height="10"/></td> </tr> <tr> <td align="right" valign="top"> <span class="bodytext1">select category</span> <select class="sorteventlist" name="list" onFocus="selectedIndex = 0" onChange="if( options[selectedIndex].value != '') document.location = 'products.php?url='+form.list.value"> <option value="javascript:;">------------</option> <option value="products/prodall.php">ALL PRODUCTS</option> <option value="products/cd.php">AUDIO CDS</option> <option value="products/painting.php">PAINTINGS</option> <option value="products/book.php">BOOKS</option> </select></td> </tr> <tr> <td> </td> </tr> </table></form> --------
-
hey, it worked for my right panel but for my iframe its still not working here is the php script from my first line ----------- <? if (!isset($url)) { $url='news/upcoming.php';} ?> ----------- the script of my iframe ----------- <iframe id="newsmain" name="newsmain" src="<?=$url;?>" width=499 height=425 marginwidth=0 marginheight=0 hspace=0 vspace=0 frameborder=0 scrolling=yes></iframe> </td> ----------- the script of my $_GET ----------- <? $id = $_GET['id']; { $side = 'news/upcomingside.php'; if ($id == '1') {$side = 'news/upcomingside.php';} if ($id == '1') {$url = 'news/upcoming.php';} if ($id == '2') {$side = 'news/eventside.php';} if ($id == '2') {$url = 'news/events.php';} if ($id == '3') {$side = 'news/recommendside.php';} if ($id == '3') {$url = 'news/recommends.php';} if ($id == '4') {$side = 'news/upcomingside.php';} if ($id == '4') {$url = 'news/hot.php';} if ($id == '5') {$side = 'news/eventside.php';} if ($id == '5') {$url = 'news/pastevents.php';} if ($id == '6') {$side = 'news/eventside.php';} if ($id == '6') {$url = 'news/privateevents.php';} if ($id == '7') {$side = 'news/eventside.php';} if ($id == '7') {$url = 'news/tourevents.php';} if ($id == '8') {$side = 'news/eventside.php';} if ($id == '8') {$url = 'news/sponsoredevents.php';} if ($id == '9') {$side = 'news/eventside.php';} if ($id == '9') {$url = 'news/corporateevents.php';} if ($id == '10') {$url = 'news/newsinq.php';} } ?> <? include ($side); ?> ----------- whats wrong with my script?
-
hey, the echo or print worked but for the $_GET, i dont have an idea how to use it. could you give me an example on my page? thanks!
-
hi, http://www.sinagtala.net/info.php from here its telling me that the register global is "off" what will i do with this?
-
here is my products.php scripts http://www.sinagtala.net/eric/products.phps
-
i've made a copy of my products.php in http://www.sinagtala.net/eric/ please check thanks!
-
sorry for the hassle. my products page can be downloaded here http://www.sinagtala.net/eric/ hope you guys can help me with this i just need to fix it asap thanks in advance!
-
products page http://www.sinagtala.net/products.php +++++ how can i attached my products page? its giving me a page error "page cannot be displayed" whenever i am attaching my scripts here. +++++
-
guys, i need help on this. please check my products page http://www.sinagtala.net/ try clicking the product button or services button on the right panel notice that it will redirect you to the default page of my iframe which is prodall.php try clicking the product button and on the select category (all products, paintings, cds, books) notice that it will also redirect you to the default page of my iframe this was working before before my webhosting migrate my site to another server. no changes in the php version and sql. hope you guys can help me on this. thanks in advance!
-
Thanks bro, i'll go ahead and try this one. [!--quoteo(post=371209:date=May 4 2006, 06:49 AM:name=anuka)--][div class=\'quotetop\']QUOTE(anuka @ May 4 2006, 06:49 AM) [snapback]371209[/snapback][/div][div class=\'quotemain\'][!--quotec--] [code] <? include 'db_connect.php'; $uSql = "SELECT event_date FROM events"; $uResult = mysql_query($uSql, $connection); if(!$uResult){ echo 'no data found'; } else{ while($uRow = mysql_fetch_row($uResult)) { $eventdate=date("y-m-d", strtotime($uRow[event_date])); $systemdate = date('y-m-d'); } } if ($eventdate >= $systemdate) {$urls = 'upcomingmain.php';} else { $urls = 'noupcoming.php'; } ?>[/code] Plz try this code [/quote]
-
guys, i need help on this. i have posted this problem before and i thought i already came up with a solution but its still not working. what i wanted to happen in my script is that: i have a data with corresponding dates. so on my website, what i wanted to happen is if the date of my data is >= to the systemdate my site will load upcoming.php but when the date of my data is < the systemdate my site will load noupcoming.php. below is my current script and what it does is, it only loads the noupcoming.php whether my data is >= or < the system date. i short its not functioning to what i wanted it to be. ========== <? include 'db_connect.php'; $uSql = "SELECT event_date FROM events"; $uResult = mysql_query($uSql, $connection); if(!$uResult){ echo 'no data found'; } else{ while($uRow = mysql_fetch_row($uResult)){ $eventdate = $uRow['event_date']; $systemdate = date('y-m-d'); } } if ($eventdate >= $systemdate) {$urls = 'upcomingmain.php';} else { $urls = 'noupcoming.php'; } ?> =============== hope you could help me with this. thanks a lot!