8,966 Posted Topics
Re: It means you query failed. Add after line 11: [code] if (!$query) die(mysql_error()); [/code] Let us know if there is an error. | |
Re: Hard to say what the problem is from a single line of code. | |
Re: You need to create the [iCODE]media[/iCODE] namespace. See [URL="http://php.net/manual/en/domdocument.createelementns.php"]the manual[/URL]. | |
Re: If every blog entry has a creation date in datetime format, you can build your archive on that with a simple query. From that mysql can easily extract the month and year, and sort on it. | |
![]() | Re: I think you'll have to do some kind of shared token exchange. I have been working on it, but due to lack of time it isn't finished yet. Basically, using a timestamp and a shared and private key, you can authenticate your request. This of course has to be generated … ![]() |
Re: phorce is right. This is the quote from [URL="http://php.net/mysql_error"]the manual[/URL]: "mysql_error() Returns the text of the error message from [B]previous MySQL operation[/B]". The previous being [iCODE]mysql_fetch_array[/iCODE]. This logic would make more sense: [CODE] $result = mysql_query("SELECT * FROM users WHERE uname = '$username' AND password = '$pass'"); if ($result) { … ![]() | |
Re: Yes, you can give it a value. Unless perhaps he's on an older version. | |
Re: Depending on what you have installed, you can use the GD library or ImageMagick. You can search this forum for examples. | |
Re: Perhaps [URL="http://sourceforge.net/projects/simpleauction/"]this script[/URL] is a good place to start. An example database model can be found [URL="http://www.databaseanswers.org/data_models/auction/index.htm"]here[/URL]. | |
Re: The flow I'd use would be: 1. Let Javascript validate if everything has been answered. 2. Post the form to a PHP page. 3. Determine the best match (with a query). 4. Send the e-mail. 5. Redirect to the selected team page. | |
Re: [url]http://www.janrain.com/products/engage[/url] | |
Re: Are you sure they are not received ? They are not in your 'Junk' folder perhaps ? | |
Re: Your syntax is way off: [CODE] $sql = 'select * from main'; $result = mysql_query($sql); $counter = mysql_num_rows($sql); $i = 1; while ($row = mysql_fetch_array($result)) { $all .= 'Select * From ' . $row['topic']; if ($i < $counter) { $all .= ' UNION ALL '; } else { $all .= … | |
Re: Not entirely sure if this is the cause, but [iCODE]$browse_script_name[/iCODE] does not have a value at the start. | |
Re: The only thing I can think of with such a long query is that you have used the same alias name twice. There is no logical reason that mysql does not return or show a single column. Apart from this, I'd like to advise you to create a view with … | |
Re: If you have a look at [URL="http://php.net/mysql_query"]the documentation[/URL] you'll see that your first parameter ($db) should be removed. | |
Re: Start with reading the [URL="http://www.daniweb.com/web-development/php/threads/191031"]sticky thread[/URL] at the top of this forum. It will explain to you how you can determine what's causing this. | |
Re: Your query fails. Mode is not UP or DOWN, but ASC or DESC. | |
Re: What kind of information are you looking for ? | |
Re: I can recommend [URL="http://highslide.com/"]HighSlide[/URL]. | |
Re: Am not quite sure what you want to see, but you can output anything as a comment. 'View source' is a browser thing, showing the page, is does not get information from the server. Can you give a short example? | |
Re: Yes, on all pages, no, it won't reset. You may want to read [URL="http://php.net/session_start"]the manual[/URL]. [quote]session_start() creates a session or resumes the current one based on a session identifier passed via a GET or POST request, or passed via a cookie.[/quote] [quote]To use cookie-based sessions, session_start() must be called before … | |
Re: I think your best bet would be to debug the [iCODE]fPublicSearchCase[/iCODE] function. If that executes the actual query, you may want to start with checking what is actually in the query. | |
Re: I've used this one: [url]http://openidenabled.com/php-openid/[/url] As far as I remember, it worked out-of-the-box. I have a working copy of it on my server. | |
Re: What do you need help with ? | |
Re: It could be that your browser if caching your page. If you do a hard refresh (CTRL+F5 or CTRL+R), is it still a problem ? Apart from that it could be a number of things, but hard to guess without seeing some code. | |
Re: Then your database name is incorrect, or you do not have rights to it. Next time, start a new thread, instead of replying to a 3-year old post. | |
Re: Can you specify a little clearer what your 'things' are ? This is a little vague. A specific example will get more specific code. Perhaps you can show what your database tables look like. | |
Re: Works fine for me. What version of PHP are you using. What happens when you try this: [CODE] $mapbeschrijving = preg_replace('/-|[^a-zA-Z0-9 .,]/', '', $_POST['expl']); [/CODE] | |
Re: [url]http://dev.mysql.com/doc/refman/5.0/en/innodb-error-codes.html[/url] Foreign key problem, as described in the first bullet point. | |
Re: [URL="http://dev.mysql.com/doc/refman/5.1/en/alter-table-examples.html"]3rd example in the manual[/URL]. | |
Re: The single quote in [iCODE]the web's marketing[/iCODE] is not escaped. | |
Re: Add them manually before the while loop: [CODE] print '<tr><th>Your field name here</th></tr>'; [/CODE] | |
Re: You are badly mixing PHP code in a Javascript function. | |
Re: In one of the user comments on [URL="http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html"]this page[/URL] it is suggested to drop your auto-inc column, and re-add it. I'm not sure how you recreated your database, but if you did it with an sql dump, the original auto-inc may have been in the create table query. Depending on … | |
Re: I've heard good things about eSyndiCat, but I've never used it myself. | |
Re: [QUOTE=veedeoo;1733214]Have you set the mercury as mail service?[/QUOTE] He's not sending through localhost, but directly to GMail. Are you sure that Mercury is necessary ? Is there perhaps anything else that could slow it down, like your firewall on your PC or router ? | |
Re: Line 38 in the last code: [iCODE]$obj->update_content_form($_POST);[/iCODE] Here you pass the entire POST array, instead of just an id. | |
Re: [iCODE]$row[/iCODE] is an array, which is your single variable. Am not sure what jpgraph expects, can you show part of that ? (Please use code tags for readability.) | |
| |
Re: [url]http://dev.mysql.com/doc/refman/5.6/en/identifiers.html[/url] Try with backticks. The topic may not end with a space. | |
| |
Re: It looks okay. If you want more info write a log-file. | |
Re: Documented as problematic, see [URL="http://stackoverflow.com/questions/3078370/how-to-find-least-non-null-column-in-one-particular-row-in-sql"]SO[/URL]. I suggest you use an [ICODE]IF[/ICODE] on all columns to return a very large value when [ICODE]NULL[/ICODE]. [CODE] SELECT LEAST( IFNULL(col1, CAST(-1 AS UNSIGNED)), IFNULL(col2, CAST(-1 AS UNSIGNED)), IFNULL(col3, CAST(-1 AS UNSIGNED)), IFNULL(col4, CAST(-1 AS UNSIGNED)) ) AS `price` from `test` [/CODE] |
The End.