| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
Comments:
<0> and im a professional using php5, its pretty neat
<0> but i agree have fails
<0> but rather jsp than .net
<1> perry: i want that too
<0> perry is your SQL "SELECT * FROM events WHERE ORDER BY date" ?
<1> TheDeathArt: no it is not
<0> it would be ?
<1> TheDeathArt: he produces this with a new file
<0> *could
<0> argh, lol ok
<1> TheDeathArt: he did not add a line to his code wich echoes his $query
<0> perry http://phpfi.com/99600
<0> fix those errors first..
<1> TheDeathArt: he created a new file an echod smothing like echo "SELECT * FROM events $where $year $month $day $cat ORDER BY date";
<0> hehe
<1> perry: but there all ur vars are empty!!!
<0> sounds like a crappy error setting
<1> perry: so add a line echo $query right before the line :
<1> 30.
<1> $result = mysql_query($query) or die('Error : ' .mysql_error());
<1> in ur code.
<0> well, i wouldn't expect the SQL to be a problem yet
<0> his php isen't even proper parsed
<1> perry: did u understand now what to do?
<1> TheDeathArt: php is not known to me very well
<1> TheDeathArt: but we all know how to debug such probs
<2> I'd rather use Python or Ruby, even for web development
<2> Though I don't know much Python, it's certainly a better choice.
<1> TheDeathArt: and perry should lhave learned that now, shouldn't he? perry?
<3> i think my problem's in the php
<1> why
<3> so thanks to TheDeathArt for pointing out those errors. i'm fixing them and going to bed.
<1> perry: can u do me a favour
<0> perry http://phpfi.com/99601
<0> =)
<0> read and learn
<0> btw. your SQL had tons of errors
<0> same had php
<0> now, back to SQL thinking
<1> maybe it is not php, but unix-sh
<1> ;)
<1> what he was trying to do
<0> IF userID isIn chat_ignore WHERE myUserID=aValue Then don't fetch the data
<0> how to i fit that into http://phpfi.com/99603
<0> i think i need a subquery
<0> but i don't have a clue how to design it
<1> TheDeathArt: i ll have a look at it
<1> TheDeathArt: wait a sec
<0> sure sure :)
<1> TheDeathArt: ok i had a look at ur statement
<1> TheDeathArt: what is now ur prob again?
<0> in chat_ignore i have 2 userID's
<1> ok
<0> if one of them is mine, i need NOT to fetch all rows with the opposit userID
<1> opposit?
<0> wait a minute, think i found the solution
<1> TheDeathArt: show me ur result then, plz!
<0> yay, solved it
<0> php makes an array with the not ignored names
<0> and then checks about its legal, or just don't print it
<0> its about the same as a subquery, but 1) i can't figure out subqueryes and 2) i think its not supported on my current mysql
<0> but again, it only works if your the one you have ignored
<0> the person you ignored can still read it
<1> mm so ur prob is not solved?
<0> fixed
<0> changed it to fetch all
<0> but do a check about your the 1 or the other
<0> a bit ugly hack, but it works for now
<1> but there are definatlly ways to do it with sql.
<0> there is, but its a subquery
<1> so show me a pasebin of ur "hack"
<1> pastebin
<0> http://phpfi.com/99605 , line 10->23 and the if() on line 82
<1> ill have a look ...
<1> hui
<1> all these quits
<1> whats going on?
<0> its development code
<0> + you perform 1 query in the second in that chat
<0> if a error occours i don't want it do perform 10000 error queries
<0> before i fix it
<1> ok
<0> so for once, its good code to add it =)
<1> how i understand it u create with the lines 10-23 the ignore list, right?
<0> yes :) an array with ignored users
<0> or users that have ignored you
<1> ok
<1> and how do u use this array now?
<0> line 82 =)
<1> ok
<1> and better would be if line 25ff would do that?
<4> anyone from Sydney floating around? http://mysql.meetup.com/142/
<0> e-PUNK well, yes, but there it would require a subquery
<0> so i think its fine to let php handle it
<4> !man select
<5> (SELECT Syntax) : http://dev.mysql.com/doc/mysql/en/SELECT.html
<6> or is it possible to join on more criteria than one, i think so.
<4> e-pUNK: try same
<1> !man select
<7> yo
<7> what is mysql query browser used for?
<7> exactly
<7> can you edit fields etc? add new fields?
<8> Is it possible to extract data from a database on my local machine that isn't running?
<8> even if i have to copy an entire database in tact, that's fine.
<7> MySQL server has gone away - why not reconnect you mong?
<7> is there something better than this?
<8> I have a dual boot between 2 linux distro's one of which is broken but I'd like to retrieve the data that was in the mysql database
<8> I have no idea how to even go about constructing a google query to find out.
<9> you need to copy the files of the mysql database
<9> and start it up
<8> thanks, I just found the files after a LONG search of my disk for random unique words I remembered from the database and table names. lol
<10> does anyone know of a good mysql frontend with an RPM built for SUSE 10.0?
<11> may someone tell me why EVERYTHING I do MySQL tells me permission denied ?
<11> How do I fix that? How may I load MySQL to defaults ?
<11> I just want a simple db for Amarok
<12> scx, clearly, you lack the proper permissions :p
<12> or privileges :p
<12> so fix it :P
<11> I've use MySQL before
<11> but when I want to access it sais "Access denied"
<11> no matter if I'm root, mysql or another user
<13> how can i have mysqldump give me the data only, without create table statements?
<13> n/mind found it
<14> problem: my slave server dosn't report its changes back to the master
<14> did i understand it right, that changes on the slave get insereted into relay-log and from there transmitted to master?
<15> I have a table with records that I display paginated (with php) is there any way to retrieve the Page where a record is straight from mysql giving the ID of that record ?
<16> redguy__: yeah.. its easy with some simple math if you have a set number of records per page
<15> yes, I have it
<15> let's say.. perpage is 20
<16> redguy__: $current_record_num / 20 + 1
<15> $current_record_num ?
<16> redguy__: difficult part is calculating $current_record_num depends on hwo your data is structured
<15> the post_ids are not consecutive
<15> some are missing
<16> redguy__: then you will have to manually wrote the code to figure out the position
<15> ok.. now, supposing that my data is structured
<15> posts are from 1 to X consecutive
<15> how I would do that
<16> ($post_id - 1)/20 + 1
<15> ok.. the issue now is that the problematic query has WHERE clause in some circumstances
<16> then youll have to do some math to calculate $post_id
<16> redguy__: its just a bunch of simple algebra
<15> ok, thanks
<17> in mysql 4.0, I am unable to start the daemon because it "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
<17> I tried changing the location but no matter where I told him to put the mysql.socket (tried /tmp/, tried home dir) it simply says that it cant connect through the socket
<17> tried giving 777 permission to /var/run/mysql, no dice
<17> tried rebooting, same thing
<18> Athlon did you try to start the server ?
Return to
#mysql
or
Go to some related
logs:
#web
slackware linux-libc-headers
#physics
fix corrupted avi file ubuntu
partial match mysql
http-handle ie7
using Trayer in Xubuntu
#perl
LWP::Parallel::UserAgent script
gentoo vmware dvdrw fstab
|
|