Anyone good with Php ??

[A face]

Lads, anyone good with Php .... just have a few questions !!

[dahamsta]

Just ask the questions guy, no-one knows if they can answer 'em or not if you don't post 'em!

[sligoman]

PHP is a widely-used general-purpose scripting language that is especially suited for Web development and can be embedded into HTML.

Is this what you're talking about? If so then,

Try here:http://www.php.net/

[A face]

Just ask the questions guy, no-one knows if they can answer 'em or not if you don't post 'em!

When i echo the results of a query onto a results page .... how do i make the foreign key results into hyper links so i can then run another query depending on what it is ..... i.e. the foreign key will be WHERE whatever = {$row['Whatever']}

I know the syntax is wrong there but i dont know how to do it !!

http://www.php.net/

i hear ya .... but what i need isn't specifically in there !!

[paul_oshea]

mate just become a member of experts-exchange.com

you will have an answer in 30 mins at most.

[dahamsta]

Post code face, your query isn't exactly, um, coherent. (No offense like.) What exactly do you mean by forgeign key for example? That's the second time I've seen you use it, and it's looked out of context on both occasions.

Paul has a point though, this is an odd place to ask. Although I used to go to phpbuilder meself, and these days I'd probably head to DevShed. Experts Exchange is a thundering piece of crap I only use via Google. Even then I feel dirty.

adam

[A face]

Post code face, your query isn't exactly, um, coherent. (No offense like.)

None taken sir ... none taken !

What exactly do you mean by forgeign key for example? That's the second time I've seen you use it, and it's looked out of context on both occasions.

(SELECT data1, data2, data3, ForeignKey, data4 FROM table)

so then i echo "Data One: {$row['data1']} <br> "Foreign Key: {$row['ForeignKey']} <br> .....

and the result on the webpage is ....

Data One: the value
Foreign Key: The value

i want

Data One: the value
Foreign Key: The value

So when i click on the link .... it runs a query and displays the results for it, if you know what i mean.

Paul has a point though, this is an odd place to ask. Although I used to go to phpbuilder meself, and these days I'd probably head to DevShed.

Yeah .... i been all over ... i'll keep trying.

Experts Exchange is a thundering piece of crap I only use via Google. Even then I feel dirty.

I haven't ever got one answer there and ignore when i google and i hate pop-ups

[dahamsta]

(SELECT data1, data2, data3, ForeignKey, data4 FROM table)

So you were referring to a column. Now how were we supposed to know that?

i want

Data One: the value
Foreign Key: The value

You'd do something like...

[php]echo "Foreign Key: <a href=\"script.php?action=dosubquery&key={$row['ForeignKey']}\">{$row['ForeignKey']}</a><br>\n";[/php]However you're going to need more code that'll do that query, or even a dedicated script. They don't just magically do themselves!

I'd seriously suggest you spend a little time researching "SQL injection attacks" and "validating user input" before you go any further face. I think you might be getting a little ahead of yourself. Again, no offense intended.

adam