| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10
Comments:
<0> you are a heathen.. lol <1> how can i turn "parent" into a variable here ?? thanks <2> you can't, since you don't have an object for the parent cl***. <1> http://pastebin.com/644466 <3> hello, i have a php related question. <3> http://pastebin.com/644499 <3> how come when i run the query from mysql it works fine <3> but when i use it on php it doesnt work <4> ggggggg gunit! <4> 'sup, k|ow? <3> lols, how did you know? :)) <3> ouch in my info. hehehe <4> ;) <4> how come you keep hidin', sahn? <3> nothing much, right here still alive. how bout you? <3> they might kick hehehe
<4> doing good. so what's the problem with your query? why do you say it doesn't work in PHP? <4> can you pastebin it within the context of your php script? <3> i tried applying it in my program and it doesnt work the way it should <3> ok wait <3> http://pastebin.com/644513 <3> im trying to select records with no particular order <4> hmm <4> and if you echo $get_provider_s; it looks right? <3> yeap, the result would be the first one i pasted <4> i don't usually use sprintf(), so i can verify that your syntax is correct there. <4> s/can/can't <4> hmm <4> and what happens that makes you think it didn't work right within your script? <4> rows aren't random or it returns nothing at all? <3> i returns records, but its not randomize. <3> and im not sure if using ORDER BY RAND() is the right way to do it. <4> so if you paste that query directly into mysql, it returns rows sorted randomly, but in the php script it doesn't? <4> weird <3> yeap <4> i dunno, man. i think the order by rand() is correct... <5> echo the query <4> you don't sort the mysql result set after you run the query or anything do you? <5> do echo ("query"); instead of mysql_query("query"); <4> he did. that was the first paste <5> (im not into the thread too much tho, i read 2l ast lines) <3> nope i didnt sorted it after the query <5> kikiam: try strisplashes() it before <5> im not sure how does it take | <5> besides, limit 1,10 <5> from what i remember mysql returs data from 1 not from 0 <5> yugh <5> strislashes <5> addslashes ? <5> gee i havent used it a long time <6> What was the question? <5> "who are you?" <3> i tried using stropslashes but the results are the same <6> kikiam, what are you trying to do? <3> im trying to select records with no particular ordering <5> kikiam: ! do you have db selected ? <6> Within the query or after you run the query? <3> within the query <3> yes @pieg <6> Ok, and is it not working? <6> Do you get any results? <5> okay, do you have any rows returned ? <3> yes i got results but its not randomize <3> i tried this query http://pastebin.com/644499 in mysql it worked fine <6> So the results you're getting are not random. <3> but when i used it on php its not randomize <3> yes <5> did you try db.table, instead of mysql_select_db <6> kikiam, your last query that you just showed us looks fine. Those should be random <6> How many rows of data do you have in your table? <3> about 100 <6> And you're wanting 10 rows at random, correct? <3> yes <6> select * from provider_info where location like '%|1|%' and categories like '%|1|%' and active = 1 ORDER BY RAND() limit 0,10 - I can tell you one thing wrong with this then. <6> You're telling it to start at record/row 0 <6> SELECT * FROM provider_info WHERE location LIKE '%|1|%' AND categories LIKE '%|1|%' AND active='1' ORDER BY RAND() limit 10 <6> Try that
<5> or 1,10 like i said <3> the result are the same @dinux <6> Is it returning the first 10 rows within the table? <5> kikiam: it has to be PEBKAC <3> yes @ dinux <3> what is PEBKAC @ pieg? <6> Yeah, then there is something wrong with your MySQL setup. <5> Problem Exists Between Keyboard And Chair <3> hehehe, maybe! <3> but im doing it right by using ORDER BY RAND(), right? <6> kikiam, can you pastebin all of your code? <3> ok just a sec <3> http://pastebin.com/644554 <6> Ok, hold on. <6> kikiam, just something really simply and easy, try this and tell me what you get: http://pastebin.com/644565 <3> ok just a sec <3> it worked!, ill just modify my paging. thank you :) <6> No problem <6> kikiam, do you see the major differences? That is my style of coding. Clean, cut, dry and to the point. Don't try using functions that are not needed. <3> i just made that functions for sql injections <7> anyone know how to change courier-imap connection timeout? <8> in the courier-imap config file? <7> FireStorm| that's a terrific, and logical guess, but I don't see it <6> |ww, try #linux or #linuxhelp <6> Or, try using something better like, oh Dovecot and Postfix. <7> heh <7> dinux_work thanks.. <7> i've never had a problem with courier-imap.. i'm having a problem with a stupid asp component not properly disconnecting <9> hey guys can someone help me figure out why this is not uploading the file: http://pastebin.com/644693 I get this error: Could Not Save file as <10> try move_uploaded_file instead of copy <9> killfrAWY - just a blank screen now <9> no error messages or anything <10> check the return of is_uploaded_file and move_uploaded_file seperately <10> and echo the array to see if ur actually getting a file <9> killfrAWY - how? <10> print_r($_FILES); <9> killfrAWY - my errro age message <9> Fatal error: Call to undefined function: move_upload_file() in /home/gerbitzo/public_html/test/upload_new.php on line 14 <10> *move_uploaded_file <10> u have a typo <9> http://pastebin.com/644709 <9> new error message <11> Gerbitz: you are a retard <11> php.net/move_uploaded_file <12> you are just realizing this? <11> It might tell you that your function doesn't exist becuause it doesn't exist <12> like your brain. <11> DEWEZ: I ignore him 99% of the time, so yeah <12> Call to undefined brain <11> stat: file not found /dev/brain <9> fixed you all <9> thanks <10> thanks for fixing us :) <8> didn't know i needed fixing <8> now he gone time for a little bit of help :p <4> lolz php <8> http://firestorm.ath.cx/test1.phps - I'm having trouble here. I'm making a fixture list and the info is stored in a sql table, i'm formatting it via a array. Now i want to p*** the info into a table layout by per month. E.G row 1 = month name row 2 = next fixture. <8> but the echo of the row 1 = month is being displayed in the array which is echoing it out for each value in that array. <8> e.g http://firestorm.ath.cx <8> e.g http://firestorm.ath.cx/test1.php <13> hi <4> um. hi. <4> what's up, poot? <13> aint no poot :) <14> it dark, cold and i think the wolves are at the door. <8> go let them in for a beer then <11> (_(_)======[jjj======D <8> http://firestorm.ath.cx/test1.phps - I'm having trouble here. I'm making a fixture list and the info is stored in a sql table, i'm formatting it via a array. Now i want to p*** the info into a table layout by per month. E.G row 1 = month name row 2 = next fixture. <8> but the echo of the row 1 = month is being displayed in the array which is echoing it out for each value in that array. <8> e.g http://firestorm.ath.cx/test1.php <14> sounds like you want GROUP BY month in your query <8> well it's displaying the fixtures ok <8> but it's just echoing the month for each fixture stored in the array <14> so dont echo the month?
Return to
#php or Go to some related
logs:
inferno fedora permission denied #london #php kiprea #linuxhelp #linuxhelp how to stop duplicate entries in php #MissKitten #linuxhelp #linux
|
|