AyKay47

the very first line that you posted is where you set $weeknr $weeknr = get_league_weeknr($league); so, either $league does not coincide with the function correctly, or something is going awry in the function itself. Can you post both the contents of the function and the value of $league ok thanks for that - how would i go about correcting that then?? im lost on it tbf been trying to figure it out for 3-4 days now lol any help is appreciated

$emails holds the value of $info['email'], which is a string, implodes()'s second parameter requires an array. what you can do, if you want to implode only the emails field, is something like this. $emails_arr = array(); while ($info = mysql_fetch_array($runGetPilots)) { $emails_arr[] = $info['email']; } $to = implode(', ', $emails_arr);

okay, I see the issue now. Here in your SQL SELECT league_id, hometeam_id, awayteam_id, game_id, week_nr FROM fixtures_result WHERE home_result IS NULL AND league_id='premiership' [b]AND week_nr < AND [/b]fixture_ignore='no' ORDER BY week_nr week_nr < AND is obviously not valid, and indicates that the $weeknr variable has not been assigned a value.

a. use mysql's IN clause, e.g. select column from table where upc IN (100,150,200,300,400); b. why would you need a self join with only one variable?

did you not read my post at all?

echo $sql and post the results please.

post the error that you are receiving

the alternative is editing the image itself with an image editor software.

1. just to make a pointer, the html layout was poorly thought out, why are you using a combination of tables and lists, normally its one or the other, there is no need for a list inside of a table column that only has one list item inside. 2. you can use the background-size: property for this, but i would recommend editing the image itself, since using background-size will distort the image.

well, i have never known of an image3000 x 4000px being 20MB, but i could be wrong. anyway, their are a few php.ini directives that will need to be changed from their default values to be able to upload a file of that size. post_max_size upload_max_filesize memory_limit (should never really need to change this one, if your code is written correctly and optimized)

if the parameter given is a viable URL, this will work.

dataBase::_dbConnect(); Here in your function, reading your entire code, it seems that both functions are in the database class, so you can use self::_dbConnect(); This code is pretty basic, and looks like it should work as expected, in theory. Your function should return a resource that you can use to get row values via a mysql_fetch function. Where does $pages come from in your function declaration?

background: rgba(127,127,127,0.25) Of course it's valid CSS, and it is a good solution, while it is not compatible with older browsers yes, most modern browsers support it. For the older browsers, you can set a Fallback bg color. There are a couple opacity hacks and such, But they are sloppy and should be avoided.

what exactly is the point of this thread? Are you having an issue? The only way that I can think of as to why this little snippet of code would not work is if your PHP settings has the "short_tags" directive disabled

what are the SMTP settings in the php.ini file of the clients server? also, as the manual states.

I was not exactly sure of your logic for storing all of the database values into an array and them comparing them to a value, so I did not want to simply suggest that you add an additional where clause to your query, which is of course the most efficient suggestion if you are aiming to filter your results based on the value that you are comparing the result set to. you should almost never have a loop within another loop, especially involving queries, is this still the case with the updated code?

to explain this post further so you understand why it is not correct, when you set the variable $four100wattreg = $_POST["four100wattreg"]; and then again $four100wattreg=2.39; you are overwriting the first value that you set $four100wattreg to with the new value (2.39). You should be using unique variable names for each unique value that you want PHP to remember. if (!isset($_POST['checkbox']) { //checkbox not checked $four100wattreg = 0; } where is $_POST['checkbox'] being passed to the server?

why not store the result set values into an array inside of the while loop? $arr = array(); while ($list = mysql_fetch_array($save_planet2)) { $saver_id = $list['saver_id']; $arr[] = $saver_id; } print_r($arr); Edit: you can also use in_array to check for the value existence.

if you have a large result set, my assumption would be that the query is taking so long because it has to cast two fields every iteration, why no set scheduledate and record_date to the DATE format in your db table, which is a good practice anyway, that will eliminate the need to cast them entirely.

click the SQL button on the top nav of the interface, and paste your query in it.. this may not be a query issue, what other code do you have on the page in question?

1. what is the point of using the LIKE clause if you aren't using a wildcard? why not just use = 2. yes, you can use a self join, I will post skeleton code that you can use to get the idea. SELECT records1.upc as group1, records2.upc as group2 FROM records records1 JOIN records records2 ON records2.upc = '001' WHERE records1.upc = '003'

have you tried running this in your servers phpmyadmin? what error(s) exactly do you receive?

you will want to use an UPDATE query, I have linked you to the documentation on the subject. http://dev.mysql.com/doc/refman/5.0/en/update.html

with some items, cheap is the way to go, domains/hosting is not one of those items. How much research did you do on the host before purchasing? Instead of posting a thread complaining about your hosting provider, you could/should have posted a thread a couple of days ago that asked us which hosting companies we'd recommend.

possibly because that where clause is narrowing the results further. How many rows are you actually expecting, please give us some more information on the subject.