jeger003

thats a good catch but it didnt actually work......and yes they are triggered by 1 and 0.........i cant figure out why it would be doing that or wat could possibly make it do that

i guess you can say it matches all entries live and non live...........so my issue is getting to display only live in the table cls_classifieds

lol idk my code doesnt have that........i think it showed up after i edited it.... here it is again $query_search_exact_match = mysql_query("SELECT title,id,live,description,search_text,image,date,price,location_city FROM cls_classifieds WHERE live = 1 AND search_text LIKE '%$search_words%' OR title LIKE '%$search_words%' OR description LIKE '%$search_words%'") or die(mysql_error());

hello everyone, with the help of users here i created a small search feature for my site (classified site) but when i search for an item i need it to display only "live" listings. it doesnt....it searches and displays all matches my query is here $query_search = mysql_query("SELECT title,id,live,description,search_text,image,date,price,location_city FROM cls_classifieds WHERE live = 1 AND search_text LIKE '%$search_words%' OR title LIKE '%$search_words%' OR description LIKE '%$search_words%'") or die(mysql_error()); what am i doing wrong? by the way it runs without any errors. so it does work. thanks

hey guys, i apologize i have replied my comp been messed up....i just want to take the time and thank you all for the help I greatly appreciate it. @andy-h thank you for the code works GREAT!! thanks again everyone!!!

im trying to create a search field......where it would say "Search...." and when the user clicks the field the "Search..." would disappear and if they clicked out it would return the "Search..." i think there is a way to do it with onfocus....i would appreciate any help or links to help thanks!!!

PLEASE HELPP!!!!

hello, im trying to edit a source file a template. When i open it with photoshop it says PNG contains additional data for adobe fireworks, which will be discarded upon save. then i hit ok but it doesnt show me different objects it displays the entire thing as one image. any help would be great! thanks

Hey you! I want to put a sort of video script on my server at home and it requires ffmpeg.....any ideas how i can set that up? another question. I know i have to open port 80 (thanks to wildteen88 earlier today) but i wanted to know the security risks of having the port open and how i can protect myself....i was thinking of just using an internet security like kaspersky.....any ideas thank soo much!!!

yea i want to serve the website......make it live so i can then get a domain for it and it would be reached by other ppl. not sure if this makes sense.....but what if i installed an internet security software like kaspersky? would that help protect it?

you were right........i did just that....i was able to open up a port specifically to the server and it works great.....but wouldnt this be extremely risky??? isnt it a security risk to have it open? how can i protect myself from hackers?? thanks again......if you werent for you guys i would be running around the net tryna find a tut on this!

OMG! its workS!! you were right as soon as i changed the <Directory> thing it worked..........this is all new to me...so to have it working hahahah ITS AWESOME!! but i thought that once i have it pointed to the wwwroot folder i can just go to my ip(http://ip) and it would run the server........is that right?? like how can i make all this live?? Thanks Again Guys!!

Oh man you guys are AWESOME!!! works GREAT!! now one last issue while we are still on the subject........i am able to change httpd.conf to where i want DocumnentRoot to point to and i want it to point to the servers root which is C:\Inetpub\wwwroot\ when i do that i keep recieving a Forbidden message........i changed the permissions IIS manager but i still cant get access...is there some where else i need to be looking at? by the way guys i just want to create a server to run a small site from home you guys have been a great help!! Thanks!

yup the tutorial i found says to do just that.......problem is i cant find anything to do with php5apache.dll or any .dll files in the php zip this is the tutorial http://www.php-mysql-tutorial.com/wikis/php-tutorial/installing-php-and-mysql.aspx and the guy is on old php and apache if you go down to the installing php part you'll find the php4ts.dll and how to add Loads to httpd.conf of apache

oh sorry........on a windows 2003 server

hello, i've been searching for a tutorial to install the latest versions of apache,php, and mysql and no luck. It seems like the instructions to install these guys on a home server has changed........i would appreciate any help....... oh and i did google it thanks

thanks so much!!!

omg your right.......i was calling user id in cookie.....my cookies dont store user ids.......man i would have been at it all day had you not have caught this... thanks so much... in the future how can i use your technique?? i can just enter $query_private = mysql_query($sql) or die(mysql_error().": $sql"); $sql can be the query to check?

new error says You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1: SELECT private_email FROM user WHERE id =

anytime you echo html you need to change " (double quotes) to ' (single qoute) because echo begins and ends with double quotes............so just change all double qoutes in echo "your html"; to single qoutes and see if that works

how about storing cookies on your server? then delete them once they pass a certain time.

This indicates, that the query failed. Try to display mysql_error your right.........now the error is You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 @dmccabe i tried your code and it gave me same error as above........i dont understand whats going on

i tried that but i keep getting error "Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result on line 173 " line 173 is $fetch_email = mysql_fetch_array($query_private); $user_id_cookie = $_COOKIE['user_id']; $query_private = mysql_query("SELECT private_email FROM user WHERE id = $user_id_cookie"); $fetch_email = mysql_fetch_array($query_private); if(!empty($fetch_email['private_email'])) { $this->body .= "<input type=text name=b[email] value=\"".$fetch_email['private_email']."\" class=details>"; } else { $this->body .= "<input type=text name=b[email] value=\"".$current_email."\" class=details>"; }

hello everyone, im trying to call a value from the database so i can use in an if() statement but i dont want to use while() is there another way to do it? here is what i have but of course it dont work $user_id_cookie = $_COOKIE['user_id']; $query_private = mysql_query("SELECT private_email FROM user WHERE id = $user_id"); //$fetch_email = mysql_fetch_array($query_private) if(!empty($query_private)) { $this->body .= "<input type=text name=b[email] value=\"".$query_private['private_email']."\" class=details>"; } else { $this->body .= "<input type=text name=b[email] value=\"".$current_email."\" class=details>"; }

oh dude this is awesome stuff! i really like the forum you put together lool saw the vid of the get doing the soulja boy hahaah hilarious.... but thanks so much for the help....i really appreciate it!!!