#mysql
27 October 2007
Total 16 pages. You are browsing page 1/16.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
--- Log opened Sat Oct 27 00:00:41 2007
--- Day changed Sat Oct 27 2007
00:00 <****> Hello
00:00 <****> i am having a problem trying to impliment a search ability on my website
00:01 <****> http://phpfi.com/271761
00:01 <****> can anyone help me with this
00:02 <****> Im thinking you might need {} around your php var
00:03 <****> wait nevermind I was looking at your array below
00:03 <****> what do you mean
00:03 <****> ok
00:03 <****> what error are you getting?
00:03 <****> regrethedays what is the problem
00:03 <****> !man match
00:03 <****> (Full-Text Search Functions) : http://dev.mysql.com/doc/mysql/en/fulltext-search.html
00:04 <****> im not getting an error
00:04 <****> !man profiling
00:04 <****> and it doesnt seem to send any information back to me
00:04 <****> Nothing found.
00:04 <****> but if i use phpmyadmin sql and try the code it returns one row
00:04 <****> but when i actually try it nothing comes back
00:05 <****> so you know your PHP is bad
00:05 <****> how?
00:05 <****> so use what you used in phpmyadmin
00:05 <****> http://phpfi.com/271761
00:05 <****> i did and it didnt work
00:05 <****> regrethedays, are you sure you have everything in dbcon.php that needs to be there?
00:05 <****> who knows ?
00:06 <****> yeah else it would error back
00:06 <****> examine the actual output
00:06 <****> how might i do that
00:06 <****> still learning this
00:10 <****> Is it possible to check if a value is in table and if not add it all in one query (and atomically)?
00:10 <****> in a table*
00:11 <****> you mean like insert...on dublicate key update?
00:13 <****> not sure what you mean 'duplicate key update'. imagine a table w/ two cols a key, and an int. I want to check if the int is in another table row and if not add it
00:14 <****> http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html
00:15 <****> ok i got it to return vlaues but it doesnt order by anything
00:15 <****> the code im using is
00:15 <****> SELECT *,
00:15 <****> MATCH(city,state,hotel) AGAINST('$searchword') AS score
00:15 <****> FROM databasehotel
00:15 <****> I am a newbie how can i connect to a mysql database using mysql query browser
00:15 <****> is there a certain column type that i need to hold news articles, something that will keep the formatting of text that is entered into a textarea field
00:15 <****> how would i impliment an order by score
00:16 <****> regrethedays: select * from tablename order by score;
00:16 <****> regrethedays, i thought you had that in you code already
00:16 <****> the first one you posted
00:16 <****> ty
00:16 <****> yeah i did but it didnt work
00:16 <****> and now i made it off self post
00:16 <****> aamof, you had ...by score desc
00:17 <****> how does one connect to a mysql database using the mysql query browser GUI
00:17 <****> search for phpmyadmin
00:17 <****> and i made it post to another page
00:17 <****> and it worked
00:17 <****> fuck if i know how that worked but it did
00:17 <****> mike-ekim, i think text does that
00:17 <****> beebum: no this is not what I had in mind
00:18 <****> hm
00:18 <****> and it still didnt order it
00:18 <****> i do have column type text
00:18 <****> ORDER BY score DESC didnt work
00:18 <****> Select * from csm where Rep Like 'jm' Status IN('Closed', 'Active', 'Scheduled') order by Rep, CSM_ID ASC Limit 100 ??? anyone see the error ?
00:19 <****> but why would it return two values when i search lakeside when only one row contains lakeside
00:19 <****> mike-ekim, you may need to look into htmlentities and such
00:19 <****> beebum: imagine u are making a dictionary (which I am not) and you put words in a table like (wordid(KEY), word) and then u want to check if a word is in the table and if not add w/ a new key.
00:20 <****> raden_work you need and/or in there
00:20 <****> alright, thanks.
00:20 <****> you could do a select ... where word = 'bla' and if that doesnt return anything then do an INSER
00:20 <****> beebum, thanks bro : )
00:21 <****> ;-)
00:21 <****> INSERT. The question is it possible to fo the logic on the server side, for performance and atomicity???
00:22 <****> beebum can i open chat window with you so i can seperate our convo from rest
00:22 <****> man, i'm having enough trouble keeping up with one window
00:22 <****> ok, understand
00:23 <****> banick, depending on how you structure your table, INSERT ... ON DUPLICATE KEY UPDATE will do what you want
00:25 <****> well, anyway, i've had enough fun in here. you guys are wearing me out
00:25 <****> Can I merge results from two different Group_concats ?
00:25 <****> hm, not quite what I am after but thx anyway.
00:25 <****> DanMan010, why not?
00:26 <****> Is there a function to do this in mysql?
00:26 <****> Concat(GROUP_CONCAT(..), GROUP_CONCAT(...))?
00:27 <****> hmm
00:27 <****> DanMan010, select concat((select...),(select ....))
00:28 <****> does anyone know a better way to write this string
00:28 <****> SELECT *,
00:28 <****> MATCH(city,state,hotel) AGAINST('$searchword') AS score
00:28 <****> FROM databasehotel ORDER BY score DESC
00:28 <****> for some reason my ORDER BY doesnt work
00:28 <****> Any Mac users here have a nice DB Design tool similar to Visio?
00:29 <****> I am having problems, I want to save a new page on the server but this has to have the ID of the row I just added. If I have 198 rows and I add another row 199, I want to be able to have that ID as the name of my file that is uploaded to the server. The problem is that I am not able to select that ID properly, how do I do this as I am doing: insert_page.cfm?pageID=163&PageTitle=YoYo&d=d= yet the ID is 164.
00:29 <****> any ideas?
00:31 <****> http://pastebin.ca/750953
00:31 <****> How can I match those two group_concats
00:31 <****> to where they pair up in order
00:32 <****> where 1=1. 7=3
00:32 <****> If I cant do that I will have to loop over two different results
00:33 <****> via php
00:33 <****> Looking for some help with setting up a trigger. I am a very newb on triggers as it probably shows in my code. Can someone please take a look & tell me what I'm doing wrong? Here is the code: http://pastebin.com/d758c8f22
00:34 <****> DanMan010, i think you need to reverse a bit, and tell us what the schema is and what you want your ouptup to be. these 2 group_concats bay be a red herring
Total 16 pages. You are browsing page 1/16.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last