Volunteers??

[dar-k]

BandWidth, read this first: http://hotwired.lycos.com/webmonkey/programming/php/tutorials/tutorial4.html

[BandWitch]

i DON'T KNOW AHT THE LINK YOU AHVE ME CAN HELP me?

[BandWitch]

A frine dof me said that the cost must be float an dnot int!

[TheDefender]

First, just to make sure we are on the same page here BandWitch... I wanted to reiterate my stance on some things from my earlier post...

Originally posted by TheDefender

1. There is NO ERROR CHECKING

2. There are a hundred ways to accomplish what you want to do, and this is just a sample.

3. There is no guarantee this will work (and it probably won't) for your particular needs.

4. I am providing absolutely NO support or help with this code. It is only to give a brief demo of what you seek.

5. This was only written to show you how you can get started.

6. To the REGS... No code critique here please. I know of the problems with this code.
   [/list=1] [/b]

Now, I will tell you one thing:
// Create your connection to your DB
$connect = mysql_pconnect($localhost, $cobra_search, $*****) or die("Could not connect: ".mysql_error());

mysql_select_db($cobra_search, $connect) or die('Unusable database: '.mysql_error());

This will not work, unless you are predefining your connection variables before you define your connection... (Your connection should look more like:

// Create your connection to your DB
$connect = mysql_pconnect("localhost", "cobra_search", "*****") or die("Could not connect: ".mysql_error());

mysql_select_db("cobra_search", $connect) or die('Unusable database: '.mysql_error());

I did the variables thing, because I practice safe coding by coding my connection info into a separate include file rather than hard-coding it onto an easily exposed php page... I highly recommend you do some learning before trying some coding... and forget that I posted that code to begin with. I forgot, you don't know how to modify code to your own needs.

This really only accents a point I keep trying to make here. YOU have NO clue what you are doing. You are trying to jump into the deep end of the pool, and you can't even swim. Well, the lifeguards are off duty here.

i DON'T KNOW AHT THE LINK YOU AHVE ME CAN HELP me?

dar-k was trying to point you in the direction of learning some basics before you try your hand at this kind of coding.
Maybe, you will find this link to be of more use to you.

[planetsim]

I suggest before anyone helps in his coding he gets some english lessons and learns about netiquette

[dnast]

Originally posted by TheDefender
Maybe, you will find this link to be of more use to you.

😃

Off topic: It's good to see that I'm not the only who prefers that site to the other, more popular one (not to spoil your post).

[BandWitch]

I think teh error is
the:
pconnect(
isn't it without th "P"?

[dar-k]

i DON'T KNOW AHT THE LINK YOU AHVE ME CAN HELP me?

Did you read it at all?

I think teh error is
the:
pconnect(
isn't it without th "P"?

http://nl.php.net/manual/en/function.mysql-pconnect.php

[TheDefender]

Oh yeah, you are absolutely right... Change the PHP Function from a persistent connection type (pconnect) to a non-persistent type (connect) and ALL of the rest of the script will function without fail. {That was sarcasm by the way}

Glad to see my point wasn't missed on you..

RTFM!!!

In case you don't know where they are, here are links to the PHP Manual and MySQL Manual.

Try opening them and reading them... Oh, a word of caution though, they are the English versions.

[BandWitch]

ok,
i fix it and it works i know hav eproblem adding the values!

[Sgarissta]

I sincerely hope this is a joke. But I fear that our friend "BandWitch" is actually in need of more help than we could ever possibly provide on an internet message board.

[BandWitch]

i hope i will get teh spririt of teh forums os i create abit the code

<?php
//sindesi sto db
$connect = mysql_pconnect("localhost", "cobra_search", "****") or die("Could not connect: ".mysql_error()); 
mysql_select_db("cobra_search", $connect) or die('Unusable database: '.mysql_error()); 

"sql"=INSERT INTO myTable 
(column1, column2, column3) 
VALUES 
('value1', 'value2', 'value3'); 

?>

Shouldn't be like that?

[TheDefender]

I'll play along (for a bit longer)

$sql="INSERT INTO myTable (column1, column2, column3) VALUES ('value1', 'value2', 'value3')";

[Sgarissta]

$sql="INSERT INTO myTable (column1, column2, column3) VALUES ('value1', 'value2', 'value3')";

Forgot the quotes on your code.

[BuzzLY]

Try to ease up just a tad... I know our friend here is a bit slow with the PHP, but I'm also sensing that English may be a second language for him. Sometimes, people just need a little extra help. At least he seems to be trying 🙂

[bubblenut]

Originally posted by BandWitch

"sql"=INSERT INTO myTable
(column1, column2, column3)
VALUES
('value1', 'value2', 'value3');
[/code]

And, lo, the piss was taken.

You know damned well that's wrong. You've assigned stings to variables just a few posts back.

[BuzzLY]

I am willing to bet that he didn't write the original script, but copied it from elsewhere. BandWitch is in serious need of basic PHP lessons, but doesn't seem to want to acknowledge this small fact.

I'm beginning to believe BW is some member of the site playing a bit of a joke. This can't be real...

[TheDefender]

Originally posted by BuzzLY
Try to ease up just a tad... I know our friend here is a bit slow with the PHP, but I'm also sensing that English may be a second language for him. Sometimes, people just need a little extra help. At least he seems to be trying 🙂

Although I appreciate what you are saying BuzzLy (which is why I am still playing along), I will interject one thing... Refer back to their other posts, and you will see there is VERY LITTLE effort being made (albeit an effort nonetheless), so I will continue to play along.

[BandWitch]

Ok,
i add many values but i keep getting this code:
No Results were found to match your search criteria.
I added teh values from PHPmyAdmin at the end fro more fast!

you can see it here http://www.cogeek.com/search.php

[TheDefender]

The reason is probably because it isn't able to perfectly match the criteria specified... Like I told you before, the script I provided won't work. You have to modify it. I only posted it so you'd have an idea where to begin.

The main problem is how the criteria is concatenated together... You'd actually want to separate that all out into a different table (for proper normalisation). You have a lot of learning to do... Like I told you before, you gotta get in and work on the basics before you try something like this... There is A LOT to this type of search script. My snippet of code only scratches the surface of what you would actually have to do.