Muddy_Funster

Collages and Universities can help. There is also a huge amount of reasource online. I would suggest getting a good book or two on SQL and database design if you want to make a serious go of it though, but don't have the luxuary of taking classes. It may seem costly to fork out £60 - £80 in literature, but it all depends on how much value you put on the time it will save you. Although TBH, some of the better members on here (of which I assure you, I am not one) could make a killing holding webinars once a month.

Nothing there looks like it could do what you are experiencing. Unless there is some verification on the page that has the actual header info in it that has gone a bit off I'm going to have to confess to being utterly useles on this one

The above was found here: http://www.ustrem.org/en/articles/send-mail-using-phpmailer-en/

you would preffer ...LEFT JOIN table2 ON (table2.table_one_id = table1.id)... ?

what's the code you are using?!?

any chance of seeing profile_lang and any 1 other working script?

I think you actualy want === true for that check

you do know what PHP's full name is right?

Every time you change code could you please upload your up to date code for us to see what changes have been made?

ok, that error relates to 256MB of memory space, so it's likely a buffer issue. I don't know what it would be using anything like that for a 1.7MB file insert though. Check you buffer size settings in your php.ini file and see if thjere is anything in there, be carefull though, you could bugger performance if you set them to crazy sizes.

Why? The problem is that the subquery is returning multiple fields, IN requires that a single field dataset is returned. Don't use Select * in the subquery, only select the fild that you need for the comparison.

That's not enough information. We'll need a full list of fields and estimated lengths. General usage information wouldn't go amiss either.

I am not aware of any file size restrictions on PHPMyAdmin for imports. What's the error you're getting?

Try SELECT Count(table2.id), table1.id, table1.name FROM table1 RIGHT JOIN table2 ON (table1.id = table2.table_one_id) GROUP BY table1.id, table1.name ORDER BY tabkle1.id ASC Let me know how you get on, I hav't tested that at all, and can't remember if it's a count(field) or count(*) that you want.

I always frown upon such replies. They seem to imply that it should not matter, the question being asked, as long as there is some other way around the problem. These posters usually miss unique situations where a specific answer to the question is required. The questioner in this case did have a legitimate need, JSON. I also have one - AJAX. I prefer to to use === instead of == in my JS coding and the result is different if the types are not matched. Seriously? You signed up just to post a critique of someone who has been on here helping people for 5 years? and then missed the point completly? The post starts with the request for the exact issue, what's to frown uppon? It then procieds to comment to the fact that in most normal cases and in PHP only scenarios the requested process is irrelivent. This is done regularaly, whither you like it or not, in order to inform people that what they may think is needed coding could actualy just be an excersise in reinventing the wheel. Again, I fail to see what would be wrong with this, but hey you've got your oppinion and a right to voice it. Incidently, something I frown uppon is the use of operators chosen by prefference rather than practicality...

Watch your quotes, you you havn't ended the href: echo "<a href=\"englishessays.php?id=$id>"; should read echo "<a href=\"englishessays.php?id=$id\">"; also, you don't need to run as many echo's, 1 would do it: echo "<a href=\"englishessays.php?id=$id\">$question</a><br><br>";

but your POST is setting a value to $myemail, the SESSION is using $email

I meen where are you defining the values for your $_SESSION variables. ie where are you telling the script what $_SESSION['email'] is to contain?

use $id = $_GET['id']; this will take the value assigned to id in the URL and assign it to the new variable $id on the englishessays.php page.

where are you actualy populating your $_SESSION variables?

on your embed.php file include a check on the URL using $_SERVER['PHP_SELF'] to make sure the end of the url is as it is supposed to be, and if it's not perform a header redirect to a rebuilt version using substr() to pull out the relevent variables from the url.

How many tables are in your programs database? Do you get the same result specifying a specific table in the GRANT?

this isn't an SQL issue, you need to remember that variable names are case specific: $question is not the same as $QUESTION

change your code to the following: // if successfully updated. if($result){ echo "Successful"; echo "<BR>"; echo "<a href='list_records.php'>View result</a>"; } else { die ("ERROR: <br>".mysql_error()."<br>THIS ERROR OCCURED WHEN RUNNING THE FOLLOWING QUERY:<br><br>$sql"); //--------this is the line that is changed }

couldn't you just do : SELECT * FROM apartments WHERE city_id IN ( 3, 4, 5 ) AND DESCRIPTION ='' AND ID IN (SELECT ID FROM apartments WHERE ID LIKE '%1' OR ID LIKE '%4' OR ID LIKE '%6' OR ID LIKE '%7') Still don't see where your LIMIT statement is that is mentioned in the actual error though.