Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[Storytella]

dave you have done it again!! thanks allot for the help. all i gotta do now is get the size under control and all will be good.

[Danny696]

meh, could and should be alot simpler.

[winfidel]

Thank You this is exactly what I have been searching for!

QUERY ERROR: Column count doesn't match value count at row 1
Query was INSERT INTO inventory VALUES('',36,1,1,0,0) 

I somehow had those two zeros in staff_jobs give item insert code... Thanks to you guys helping me out on other things I spotted this error...

[winfidel]

In my dream I was told to change socks to 2 and put a 1 before dumbass

[Danny696]

Can you please wrap the code in [code] and [/code] tags please

[JoshuaDams]

A much simpler way to do this is add an itempic table to your SQL database.

Then add the Form to UPLOAD the itemimage from your staff panel.

When the image is Uploaded it is given a name, that is inserted into the database for that type of item.

Then where you display it just run the $db->query to fetch the URL for signed image.

Saves a lot of coding and is much much neater.

[Danny696]

An even simpler way than that josh would be to just use the item id

Much neater, less db space used, and simpler.

[JoshuaDams]

That's kind of the object isnt it?

Upon New item creation there is an upload picture form and in the same table insert the link for the image with the item

then on the output just do the itempic call.

Simple, straighforward and very little database strain