Jump to content

pixeltrace

Members
  • Posts

    577
  • Joined

  • Last visited

    Never

Everything posted by pixeltrace

  1. hi, from http://www.google.com.sg/ig?hl=en the dom colapse that i am referring are the modules below wherein the have the plus and minus buttons that expand and colapse the content. any idea where i can get the dom colapse code of it? thanks!
  2. hi, any idea on how and where can i get the code of the dom colapse used in www.google.com.sg? thanks!
  3. also for updating any items in table2 base from any changes in table 1 will this query work? UPDATE * FROM table1 LEFT JOIN table2 WHERE table1.crud IS CHANGED is there a query code call IS CHANGED? what is the correct code for that? thanks!
  4. hi i just want to ask, since i wanted to copy items in table 1 to table 2 which doesnt have duplicates. will this work? INSERT * FROM table1 LEFT JOIN table2 WHERE table2.id IS NULL i haven't tried it, but i just wanted to check first if it will work thanks!
  5. hi, i apologize if my question is not clear. currently i will be running a php page in cron that will automatically update table 2 with whatever new item is in table 1 and functions that i might needs is a query or php code that will only copy new items from table 1 that is not yet existing in table 2 table 1 has this fields id | name | address| phone | company and i only need to get new items in table 1 going to table 2 for this field id | name | address wherein in it will validate this 3 fields if the 3 fields are the same, it will not copy it anymore. hope you could help me with this. thanks!
  6. hi, i tried this, its a select function not update or copy is there a way that i can copy items in table 1 going to table 2? thanks!
  7. hi, i need help, is there any code available that can copy specific items in a table to another table and verifies if there's any duplicates also? example table 1 id | name | address | email | contact | company in table 2 id | name | address | email how do i copy field id, name, address and email in table 1 going to table 2 and omits items that are already existing in table 2 via id and name? hope you could help me with this. thanks so much!
  8. i mean it can submit either an array or a non-array result is it possible? thanks!
  9. hi, i need help, currently i have a code and it only submit results in array if(isset($_GET['poitype']) and count($_GET['poitype']) > 0) $poitype = implode(",", $_GET['poitype']); else $poitype = ''; how do i modify this code so that i can also submit a non-array value? because i submit this same variable on two different function 1 . using checkboxes, the name of my checkbox is poitype[] 2. using list menu, the name of my list menu is poitype hope you could help me fix this. thanks!
  10. hi, i found a code that displays result in 2 columns but i still cant make it work normally what i wanted to happen is if i have 10 results the display will look like this result1 result6 result2 result7 result3 result8 result4 result9 result5 result10 and currently this is the code that i have <?php $columns = 2; $sql = "SELECT * FROM jos_classifieds_providers WHERE published=1"; $result = mysql_query($sql) or die("Couldn't execute query."); $num_rows = mysql_num_rows($result); $rows = ceil($num_rows / $columns); while($row = mysql_fetch_array($result)) { $data[] = $row['name']; $data1[] = $row['address']; $data2[] = $row['postalcode']; } echo "<table border='0'>n"; for($i = 0; $i < $rows; $i++) { echo "<tr>n"; for($j = 0; $j < $columns; $j++) { if(isset($data[$i + ($j * $rows)])) { echo "<td><img src="" . $data[$i + ($j * $rows)] . ""></td>n"; echo "<td valign="top">" . $data1[$i + ($j * $rows)] . "<br>" . $data2[$i + ($j * $rows)] . "</td>n"; } } echo "</tr>n"; } echo "</table>n"; ?> but i am getting an error Parse error: parse error, unexpected '\"', expecting ',' or ';' in /var/www/html/myoochi/findit/test2.php on line 29 and this is my testpage link http://mango.resonance.com.sg/myoochi/findit/test2.php hope you could help me with this. thanks!
  11. hi, i need help, i have a page wherein the result listing needs to be displayed in 2 columns. let say i have a total count of 10, the first 5 will be displayed in the first column and the remaining 5 will be displayed in the next column. this is my current code and i cant seem to make it work <? $uSql = "SELECT * FROM jos_classifieds_categories WHERE parent = '$id' AND published=1 LIMIT 0,5"; $uResult = mysql_query($uSql, $connection); if(!$uResult){ echo 'no data found'; }else{ while($uRow = mysql_fetch_array($uResult)){ $name = $uRow["name"]; $subid = $uRow["id"]; echo " <table width='600' border='0' cellspacing='3' cellpadding='0'> <tr> <td><a href='test.php?id=$id&subid=$subid&view=subview'>$name</a></td> <td><a href='test.php?id=$id&subid=$subid&view=subview'>$name</a></td> </tr> </table> "; } } ?> hope you could help me with this. thanks!
  12. hi, its working now, i just had a type error. thanks so much for the help!
  13. hi, i need help, i have a page wherein i need to display the items in jos_providers table but i always get a "no data found" message. initially i have 3 tables jos_classifieds_providers jos_classifieds_providers_categories jos_classifieds_categories. my "id" in jos_classifieds_providers is equal to the "provider" column in my jos_classifieds_providers_categories and each column has its respective "category" value which is another column in jos_classifieds_providers_categories now each category item in jos_classifieds_providers_categories has its respective name in jos_classifieds_categories where the "parent" column is equal to the "category" column in jos_classifieds_providers_categories i am not sure if my query is working since its not displaying any results below is my current code <? include 'db_connect.php'; $view = (isset($_GET['view'])) ? $_GET['view'] : "main"; if ($view == "main"){ echo " <a href='test.php?id=328&view=sub'>Furniture, Fittings and Decor</a><br> <a href='test.php?id=354&view=sub'>Interior Design</a><br> <a href='test.php?id=355&view=sub'>Cleaning and Repairs</a><br> <a href='test.php?id=367&view=sub'>Home Accessories and Appliances</a><br> <a href='test.php?id=381&view=sub'>Home Alterations and Additions</a><br> <a href='test.php?id=388&view=sub'>Architects, Engineering and Construction</a><br> <a href='test.php?id=391&view=sub'>Home Entertainment</a><br> <a href='test.php?id=395&view=sub'>Real Estate Agents</a><br> <a href='test.php?id=397&view=sub'>Property Services</a><br> <a href='test.php?id=401&view=sub'>Garden and Landscaping</a><br> "; } if ($view =="sub"){ $id = $_GET['id']; $uSql = "SELECT * FROM jos_classifieds_categories WHERE parent = '$id' AND published=1"; $uResult = mysql_query($uSql, $connection); if(!$uResult){ echo 'no data found'; }else{ while($uRow = mysql_fetch_array($uResult)){ $name = $uRow["name"]; echo "<a href='test.php?id=$id&view=subview'>$name</a>" . "<br>"; } } } ?> ====================================================<br><br> <? if ($view = "sub"){ $id = $_GET['id']; $uSql = "SELECT * FROM jos_classifieds_providers WHERE `id` IN (SELECT DISTINCT(provider) FROM `jos__classifieds_providers_categories` WHERE `category` IN (SELECT DISTINCT(id) FROM `jos__classifieds_categories` WHERE `parent` = $id) "; $uResult = mysql_query($uSql, $connection); if(!$uResult){ echo 'no data found'; }else{ while($uRow = mysql_fetch_array($uResult)){ $name = $uRow["name"]; echo "$name $address" . "<br>"; } } }elseif ($view = "subview"){ $id = $_GET['id']; $uSql = "SELECT * FROM jos_classifieds_providers WHERE `id` IN (SELECT DISTINCT(provider) FROM `jos__classifieds_providers_categories` WHERE `category` IN (SELECT DISTINCT(id) FROM `jos__classifieds_categories` WHERE `parent` = $id) "; $uResult = mysql_query($uSql, $connection); if(!$uResult){ echo 'no data found'; }else{ while($uRow = mysql_fetch_array($uResult)){ $name = $uRow["name"]; $address = $uRow["address"]; echo "$name $address" . "<br>"; } } } ?> and this is my test page http://mango.resonance.com.sg/myoochi/findit/test.php hope you could help me with this. thanks!
  14. hi, what i mean is each values taken from the form must be separated in columns. let say i have column brand, product model, product type, serial no, warranty period....... so on. if the form is submitted, how can i save it on the csv that the value for brand name, product model, product type,....... will be inserted in there respective columns? hope you could help me with this. thanks!
  15. thanks! its working now. i have another question, how can i display the listing result in such a way that i can display the listing result in 2, 3 or 4 columns? currently this is my code <? include 'db_connect.php'; $view = (isset($_GET['view'])) ? $_GET['view'] : "main"; if ($view == "main"){ echo " <a href='test.php?id=328&view=sub'>Furniture, Fittings and Decor</a><br> <a href='test.php?id=354&view=sub'>Interior Design</a><br> <a href='test.php?id=355&view=sub'>Cleaning and Repairs</a><br> <a href='test.php?id=367&view=sub'>Home Accessories and Appliances</a><br> <a href='test.php?id=381&view=sub'>Home Alterations and Additions</a><br> <a href='test.php?id=388&view=sub'>Architects, Engineering and Construction</a><br> <a href='test.php?id=391&view=sub'>Home Entertainment</a><br> <a href='test.php?id=395&view=sub'>Real Estate Agents</a><br> <a href='test.php?id=397&view=sub'>Property Services</a><br> <a href='test.php?id=401&view=sub'>Garden and Landscaping</a><br> "; } if ($view =="sub"){ $id = $_GET['id']; $uSql = "SELECT * FROM jos_classifieds_categories WHERE parent = '$id' AND published=1"; $uResult = mysql_query($uSql, $connection); if(!$uResult){ echo 'no data found'; }else{ while($uRow = mysql_fetch_array($uResult)){ $name = $uRow["name"]; echo "<a href='test.php'>$name</a>" . "<br>"; } } } ?> hope you could help me with this. thanks!
  16. Hi, Thanks! how will it be if each field item should be separated in column not commas?
  17. hi, i need help. i have a project wherein inquiries must be logged in a csv form. my problem is i have no idea how to do it. sample page is this http://mango.resonance.com.sg/memoryworld/index.php?option=com_warranty hope you could help me with this. thanks!
  18. hi, infid3l thanks you are right about it. sorry for the cofusion
  19. also the values for my dist is 1000 2000 3000 4000 5000 6000 7000 8000 9000 10000 how to compute the zoom by 85% where dist is equal to those values? need help on this. thanks!
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.