[am i doing this mysql_query incorrectly?]

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

[am i doing this mysql_query incorrectly?]

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

[am i doing this mysql_query incorrectly?]

What's with all the  ?

 

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());

[am i doing this mysql_query incorrectly?]

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

[anyone know how to use onfocus?]

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!!!

[anyone know how to use onfocus?]

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!!!

[cannot edit joomla templates in photoshop CS3]

PLEASE HELPP!!!!

[cannot edit joomla templates in photoshop CS3]

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

[how can i get ffmpeg on windows 2003 server?]

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!!!

[Anyone know a good tutorial to install Apache2.2, PHP5, MYSQL]

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?

[Anyone know a good tutorial to install Apache2.2, PHP5, MYSQL]

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!

[Anyone know a good tutorial to install Apache2.2, PHP5, MYSQL]

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!!

[Anyone know a good tutorial to install Apache2.2, PHP5, MYSQL]

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!

[Anyone know a good tutorial to install Apache2.2, PHP5, MYSQL]

Hrmmm I doubt there is a tutorial then....  It's pretty easy to install Apache/PHP/MySQL on Windows.  I would just install Apache using the .exe (or maybe .msi) installer available for download from http://httpd.apache.org/, then I would download and install MySQL (using the .exe installer).  Then, I would download the .zip PHP package, and I would add it to Apache as a module.  You might want to change DirectoryIndex in httpd.conf to have index.php too.

 

 

 

As for what would be needed in httpd.conf for PHP to be loaded, you could use something like:

 

PHPIniDir "/path/to/php/folder/"
LoadModule php5_module "/path/to/php/folder/php5apache2_2.dll"
AddType application/x-httpd-php .php

 

 

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

 

[Anyone know a good tutorial to install Apache2.2, PHP5, MYSQL]

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

[Anyone know a good tutorial to install Apache2.2, PHP5, MYSQL]

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

[[SOLVED] how do i call specifc values with out using while()]

thanks so much!!!

[[SOLVED] how do i call specifc values with out using while()]

Well here you are: $user_id_cookie is empty.

 

 

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?

[[SOLVED] how do i call specifc values with out using while()]

Change

$query_private = mysql_query("SELECT private_email FROM user WHERE id = $user_id_cookie");

to

$sql = "SELECT private_email FROM user WHERE id = $user_id_cookie";
$query_private = mysql_query($sql) or die(mysql_error().": $sql");

 

 

 

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 =

[[SOLVED] Problem with ECHO code]

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

[Curl Phpbb Login help?]

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

[[SOLVED] how do i call specifc values with out using while()]

 

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);

 

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

 

 

[[SOLVED] how do i call specifc values with out using while()]

you have to use mysql_fetch_array on $query_private to get an array from result.

 

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>";
}

[[SOLVED] how do i call specifc values with out using while()]

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>";
				}

[what do you recommend on this topic?]

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!!!