I would like to learn how to update code for alot of the old vb3 code. Learning the sql read, write, fetch, array code is very important, since alot of the call function's seem to have changed.


so how do you know which query call to use........there seems to be so many at this point? and there are a bunch more........

I think the above post is awesome and wish there was an area that actually shown the break down of coding php/mysql in laymens terms...

I have a piece of code i have been working on and i am stuck.....i have no idea if it is a query issue, a call issue or what.......This is just a brief piece of the code i have been working with: which is a piece of code that still works in vb3.0 external.php......but with all of the changing software knowledge, and it is changing quickly, it's hard to learn. Just when you think you are starting to get a fair understanding of what's happening, bam........it's changed to a new and better version.

__________________
owner of www.insanemustangs.com and a bunch of ford mustangs.

Read:
Write:
A read query which only uses one line in the db:
E.G.

so this line: should be: And correct me if I am wrong but I can't find where the variable $post came from for this: perhaps you meant: And then for this you can't use "!=" in a query but you can do "<>" so you need: That's what immiediatly strikes me.

oh, there is alot more to the code, i was just sharing a brief synopsis of the file...........and dang man, that was a super fast response....thank you very much.

I try my best

I know ya do, that's what i love about this site........

Very helpful.

k, so if i have a query set up like this: Where my information is going, basically like the vbpost query, in order to read and write from there, i would have to change This is the file i am trying to work with:

in external.php version vb3.0 Which i changed to:

which should lead to these settings too in external.php:
old settings:
and

old version:
which i changed to:

what i have done so far, tries to work, but it just isn't pulling the information like it should.

Just to add, once i run the above script, i should get:

As you can see, i falsely stuck 44 into the catagory amount, just to show what it should look like after it has preformed the learner information.

but instead i get:

o.o this'll take some time to read through.

can you put your code in php tags please as that will work with my quotes.

I don't know if you can do this: in the external file so it was probably best to put that back to Also this is a read query not a write query so you need: not: And then: You have specified the post id and then added it again on the end. Perhaps you meant: and the second script looks ok but as far as I can see that is not supposed to add catergories that is just displaying posts....

__________________
vB Nova - Great vBulletin Help, Mods & Skins | PicoSphere - Free Image Hosting with No Pop-Ups
---------

k, So if i understand this, query_write, sends the post information to the database? query_read, read's and pulls the information from the database?

Is it possible to use something like:

Instead of:

?

That way, it would do the write or read request without having to specify the exact call?