8,968 Posted Topics
 | > I'm having hard time trying to insert data Do you get an error? What is happening? The following is wrong, as you are mixing PDO and MySQL here. PDO raises exceptions on errors. $query = $pdo->prepare("INSERT INTO accounts(acc_number, cust_name, cust_tel, cust_address, cust_opendate, cust_openamount, cust_balance, cust_message, cust_openby) VALUE(?,?,?,?,?,?,?,?,?)" ) or … |
| | *"Do not ask anyone (member or moderator) for help by email or private message"* http://www.daniweb.com/community/rules  |
| | You can use `setInterval` if you create a function of the above first. function switchImage() { // your code } setInterval(switchImage, 5000); |
| | |
 | The following code snippet shows how you can parse a DSN (Data Source Name). Why is it useful? You can now pass a single DSN parameter to your database wrapper class' constructor (instead of five separate parameters), and tear it apart into the components you need. The password and port … |
| | |
| | From what I've read you need the URL to be the full path to the file. ftp://ftp.example.com/path/file.ext or even: ftp://user:password@ftp.example.com/path/file.ext |
 | Switch to [MySQLi](http://php.net/manual/en/mysqli-stmt.bind-param.php) or [PDO](http://php.net/manual/en/pdostatement.bindvalue.php) and use bound values. |
 | Can't you just replace that value with a sub-select? and bsd.BSD_Date_Modified = (SELECT MAX(BSD_Date_Modified) FROM dbo.tblBank_Source_Data) |
 | Perhaps unknown to you, MySQL has the following construct: INSERT INTO ... ON DUPLICATE KEY UPDATE ... Technically it makes it possible to use a single query for both the insert and the update. It tries to insert, if the PK exists it does an update.  |
 | |
| | |
| | You may want to read [this](http://www.daniweb.com/community-center/daniweb-community-feedback/threads/452623/new-forum-topic-idea). |
 | |
 | Start with this, you just need to select the columns you need: select * from objektet o left join stafi s1 on s1.id = o.id_pergjegjesi left join stafi s2 on s2.id = o.id_punime_civile left join stafi s3 on s3.id = o.id_punime_elektomekanike left join stafi s4 on s4.id = o.id_punime_elektrike |
| | What is the exact error? Most likely, the connection failed, echoed an error, causing the `header` not to function. I think it should be: SET NAMES 'utf8' Single quotes, not double.  |
 | Only sometimes if you are friends with someone. This is to protect the privacy, so not just anybody can get a person's full details. |
 | |
 | |
| | Those are [HTTP status codes](http://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html).  |
 | > everything works fine except for the resume download What's not working? Did you use [this one](http://www.richnetapps.com/php-download-script-with-resume-option/)? |
 | Something like [this](http://stackoverflow.com/questions/5877323/intercept-named-anchor-in-javascript)? Not sure if the scrollTo can be used relative (never used it). |
| | You should use `==` for comparison. `=` means assignment. |
 | |
| | You can only do this when you concat strings to build the query, and then execute it with `sp_executesql` |
 | Do you get "error" or "successful" ?  |
| | My guess is [magic quotes](http://php.net/manual/en/security.magicquotes.php). |
| | Did you connect? |
| | |
 | Do you have this online somewhere to view? My guess is that the path to the CSS is incorrect. |
| | Dani, if I get the following URL: http://www.daniweb.com/api/articles?page=1&orderby=firstpost&access_token=MY_TOKEN it returns the attached JSON result, which fails to `json_decode()`. Can you have a look please? |
| | Not sure if you can get this to work asynchronously. Can you show some code? |
| | Re: Please help > I want to decrypt my code i don't know how it can be done for both codes Your code? If you created this, you must have the original. Looks very suspicious/illegal to me. |
| | Re: Avatar Trend It's based on the email address, but I can't remember the name. It's similar to what SO uses as default. |
| | Your update query runs on ALL records, so you'll have to add a WHERE so it runs on only one at a time. |
| | |
| | I suggest you talk to a lawyer. If you don't have access to his website anymore, blocking is impossible. If you have a contract, a lawyer is your best option.  |
 | How about the [cycle plugin](http://jquery.malsup.com/cycle/int2.html). Last demo on the page. |
| | Since the start is always constant, I suggest you store it in a variable and then you can just do a `str_replace` |
| | The error means your query failed. I suggest you add error checking to find out why: $results = mysql_query($query) or die(mysql_error() . '<br/>' . $query); |
| | What are the requirements? |
| | |
| | In MySQL you can use [DATEDIFF](http://www.http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_datediff), [MSSQL](http://msdn.microsoft.com/en-us/library/ms189794.aspx) supports it too. |
| | `ucwords` is a PHP function, it will not work in an SQL query. I don't think you need it, unless your database is configured to be case-sensitive. |
 | 1. If you give the dropdown values the ID of the category, then you can use that directly from the POST array. 2. Not sure what you mean, can you explain? |
| | If they provide the regular OAuth, then the Facebook library should work. It should follow the same logic. |
| | Welcome to DaniWeb. Click the Code button (3rd button in the editor's toolbar) and paste your code there. |
| | Are you sure all columns are of type string ? We could be of more help if you post the table structure. Have you tried: [code] mysql_query(...) or die(mysql_error()); [/code] to see if there is an error ?  |
| | |
| | The backtick is something from MySQL. Is it placed around column names? |
The End.