- Strength to Increase Rep
- +0
- Strength to Decrease Rep
- -0
- Upvotes Received
- 6
- Posts with Upvotes
- 5
- Upvoting Members
- 5
- Downvotes Received
- 0
- Posts with Downvotes
- 0
- Downvoting Members
- 0
47 Posted Topics
 | Try this one: [CODE]UPDATE related_category SET related_category.rel_cat_name = ( SELECT product_category.cat_name FROM product_category WHERE related_category.rel_cat_id = product_category.cat_id LIMIT 1 )[/CODE] |
| | Looks to me like JS or file path problem. CodeIgniter uses the real directories/files if they exist otherwise it's up to the router. |
| | xmllint does a great job if you're using linux Otherwise save the text as something.xml and open it with the browser. In the example you have some tags that are never closed: Company ConfNr Phone |
| | Try this one: [CODE]SELECT Score FROM scores ORDER BY row_id DESC LIMIT 1;[/CODE] |
| | There are only two variables in your RegExp: [CODE]^([^/]+)/([^/]+)$[/CODE] Use this to get three segments: [CODE]^([^/]+)/([^/]+)/([^/]+)$ [/CODE] |
| | Yes it is possible to use external JS on blogspot. You can add it in JS Widget or in the template code. |
| | If you want to store the result into empty table: [CODE]INSERT INTO Users SELECT userid, count(*) FROM ratings GROUP BY userid[/CODE]  |
| | Check this article on Access DDL: [url]http://www.databasejournal.com/features/msaccess/article.php/3460771/Access-Data-Definition-Language-DDL-Creating-and-Altering-Tables-On-The-Fly.htm[/url] |
| | You can try google chart api: [url]http://code.google.com/apis/chart/interactive/docs/gallery/orgchart.html[/url]  |
| | Re: number format Use this code: [CODE]$a = array_map(create_function('$x', 'return sprintf("%02s", $x);'), range(1,31));[/CODE] |
| | Re: code igniter Controller is CI_Controller in CodeIgniter 2. [url]http://codeigniter.com/user_guide/installation/upgrade_200.html[/url] |
| | Does this file exist? [CODE]/mounted-storage/home36c/sub003/sc29343-BHKZ/progekt.com.utpal/helora/login/logIn.php[/CODE] Note the filename case log[B]I[/B]n.php  |
| | Set the correct mysql encoding: [URL="http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html"]Connection Character Sets and Collations[/URL] |
| | Either use new form for each row, or change the field names for each row. |
 | Test with this code: [CODE]<?php //my database class class Db { // make sure we dont connnect database to every function public $mysql; function __contruct(){ $this->mysql = new mysqli('localhost','root','password','db'); if (mysqli_connect_error()) { die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); } } } $db = new DB(); var_dump($db->mysql); … |
| | Re: script enquiry Note that you can still type 033+2323 in the field: [CODE]<script type="text/javascript"> function zz(txt){ var txt1 = txt.value.replace(/[^0-9\+]/g, ""); document.getElementById('aa').value = txt1; } </script> <input name="phone" type="text" id="aa" onblur="zz(this)" />[/CODE] |
| | Can't see what's the point of using arrays here: [CODE]$action = $_POST['action']; if ($action == 'Submit') { if(strpos($item_value."*".$amount_value, $targetstring) !== FALSE) { print "<td><input type=text name=$item_name value=$item_value></td>"; print "<td><input type=text name=$amount_name value=$amount_value></td>"; } else { print "<td><input type=text name=$item_name value=$item_value style=\"background-color: Yellow;\"></td>\n"; print "<td><input type=text name=$amount_name value=$amount_value style=\"background-color: Yellow;\"></td>\n"; } … |
| | Try to set the width of the table. Something like: [CODE].Divscroll table{width:200%}[/CODE] |
| | Just use: [CODE]if ($pubinfo_username == $_SESSION['username'])[/CODE] I don't see why binary compare is required in this case.  |
| | |
| | Try to execute the query manually in mysql. It may be unique field index, wrong field name that's preventing inserting new value. |
| | Re: tooltips help I'm not sure if I understood you correctly, but you can try this example: [CODE]<head> <style> #ttcont { display:block; background: url(imgs/bars/3.png) top right no-repeat; } #ttcont2 { display:block; background: url(imgs/bars/2.png) top right no-repeat; } #ttcont3 { display:block; background: url(imgs/bars/1.png) top right no-repeat; } </style> </head> <body> <script type="text/javascript"> var tooltip=function(){ … |
 | Try with the following example: [CODE]<?php session_start(); if ($_GET['get']){ echo "resp:".$_SESSION['v']; die(); } $_SESSION['v'] = 'SECRET CODE'; ?> <html> <head> <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js"></script> </head> <body> <a href="#" onclick="get();">click</a><br /> <script type="text/javascript"> function get(){ $.get('?get=1', function(data) { alert(data); }); } </script> </body>[/CODE] |
| | |
| | Only HTML, no. You'll need some server language to connect to the excel table using ODBC for example and pull the data from there.  |
| | Or you can use wildcard sub-domain and process the name in php |
| | Generally it depends on your choice of database. One possible solution is to give them INSERT only rights to the orders table and filter the SELECT with a view to show them only their orders. This should work if they don't need to update the orders. Other solution is to … |
| | Hacker News clone or stackoverflow clone. Both are quite challenging and useful. |
| | You can include it in the array: [CODE]<?=form::dropdown(array('name' => 'category_id', 'class' => 'input-select', 'onclick' => 'yourFuncion()'), $categories, $members['category_id'])?>[/CODE] |
| | Use [B]OR[/B] instead of [B]AND[/B]: [CODE]select Employee.Emp_Id,First_Name,Last_Name,Gender,Mobile_No,Email_id,Blood_Group from Employee where Emp_Id like ('%' + '$empid' + '%') OR First_Name like ('%' + '$empname' + '%') OR Mobile_No like ('%' + '$mobileno' + '%') OR Blood_Group like ('%' + '$bloodgroup' + '%')[/CODE] |
| | The mysql library should have a method, which returns the id or you can use LAST_INSERT_ID() [url]http://dev.mysql.com/doc/refman/5.0/en/getting-unique-id.html[/url] |
| | Re: need help Something like that ? [CODE]<form method="get" action="http://google.com"> <input type="submit" value="Go" /> </form>[/CODE] |
| | Try with this Unicode modifier: [url]http://www.fileformat.info/info/unicode/char/a788/index.htm[/url] |
| | The redirect doesn't repost the data. The best solution is to avoid the redirect. Otherwise You can store the variable in cookie/session or pass it as get parameter (which will work with the redirect); |
| | |
| | Use this: [CODE]<input type="text" id="datepicker" name="rcv_date" value="<?php echo date('m/d/Y');?>">[/CODE] |
| | Re: sql update query Try something like this: [CODE]UPDATE installment_scheme_customer SET today_date = REPLACE(today_date,substring(today_date,3,4),'/04/') WHERE substring(today_date,4,2)='06' AND substring(doj_date,4,2)='04'[/CODE] And use Date for date type. It's much easier to work with. |
| | Check Codeigniter. It's small, light and fast to learn. |
| | [CODE] table properties id name table vals id item_id property_id value[/CODE] To get all poperties for item: Then use this to get all properties for particular item: [CODE]SELECT * FROM vals v RIGHT JOIN properties p ON v.property_id = p.id WHERE item_id = 123 ORDER BY p.id[/CODE] |
| | Prepare two images and replace the text with the appropriate image in the code. |
| | Check this short tutorial for a starter: [url]http://blog.nodejitsu.com/jsdom-jquery-in-5-lines-on-nodejs[/url] |
| | Check if executing: [CODE]SET names utf8[/CODE] after connecting to the database will fix the problem. |
| | In [B]system/application/config/config.php[/B] set: [CODE]$config['index_page'] = "";[/CODE] |
 | Can't you do it in the database? Search for events in the following range: x >= posx-spread x <= posx+spread y >= posy-spread y <= posy+spread Then you can also use your distance function on the returned subset. |
| | Copy from Word; Paste into notepad; Copy from notepad; Paste wherever you want. |
| | Re: redirect problem Use session_start(); before assigning the value to $_SESSION; Also not that IE doesn't play nice with setting session before header redirects. Instead use <meta http-equiv="refresh" content="2; url=http://webpage/"> |
| | The SQL should be [CODE]SELECT id FROM users WHERE date = '0000-00-00' OR date <= CURRENT_DATE() - INTERVAL 30 days ORDER BY rand() LIMIT 3;[/CODE] If you also want to update the dates with the same query use: [CODE]UPDATE users SET date = CURRENT_DATE() WHERE id IN ( SELECT id … |
The End.