For those new to message boards please try to follow a few simple rules when posting your question.
Choose the correct forum for your message. Posting a VB.NET question in the C++ forum will end in tears.
Be specific! Don't ask "can someone send me the code to create an application that does 'X'. Pinpoint exactly what it is you need help with.
Keep the subject line brief, but descriptive. eg "File Serialization problem"
Keep the question as brief as possible. If you have to include code, include the smallest snippet of code you can.
Be careful when including code that you haven't made a typo. Typing mistakes can become the focal point instead of the actual question you asked.
Do not remove or empty a message if others have replied. Keep the thread intact and available for others to search and read. If your problem was answered then edit your message and add "[Solved]" to the subject line of the original post, and cast an approval vote to the one or several answers that really helped you.
If you are posting source code with your question, place it inside <pre></pre> tags. We advise you also check the "Encode "<" (and other HTML) characters when pasting" checkbox before pasting anything inside the PRE block, and make sure "Use HTML in this post" check box is checked.
Be courteous and DON'T SHOUT. Everyone here helps because they enjoy helping others, not because it's their job.
Please do not post links to your question into an unrelated forum such as the lounge. It will be deleted. Likewise, do not post the same question in more than one forum.
Do not be abusive, offensive, inappropriate or harass anyone on the boards. Doing so will get you kicked off and banned. Play nice.
If you have a school or university assignment, assume that your teacher or lecturer is also reading these forums.
No advertising or soliciting.
We reserve the right to move your posts to a more appropriate forum or to delete anything deemed inappropriate or illegal.
yes i am trying .i followed w3schools.but I observed most people save image name in database not the image can you guide me if we will save a image name in database than how will we retrieve those images?
0) File system - Store image location in database, image in server. Later, load image from server using the path stored in database.
1) Database - Store image as blob in database. Later, load blob as image in page.
Check the advantages & disadvantages of these two ways here. Clickety[^]
I didn't understood it.
Are you expecting someone to come forward and teach you over this forum (or over the proper forum) about PHP, MySQL and what in-between?
It's unlikely to happen - you are in a site for those who code, not for those who not...Until know you are not!
If you have a task, first learn, than make an attempt, than come to us here - with! your attempt...
I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)
I have a normal HTML/CSS w/some JScript thrown-in webpage, with > 50 individual blog pages that are indexed from the main index.html file.
On my wishlist are two things:
-would like to add a Search Box. Not one that depends on an external search engine. I want to roll my own, so to speak. I want to have all my pages accessible - so that I can search through the pages and then display the results to a user after a search. I'm thinking that the pages need to be put into a database for this(?)
-Would like to add a 'prev' and a 'next' function to the bottom of each sub-webpage. The user should not always have to navigate back to the index to see another page. Would like one function that takes an argument - prev or next. Or two separate functions are ok. What I want to avoid is having to hardcode "num of next page", and "num of prev page" on every subpage. Can be very error-prone.
What language(s), DBs would be best for this? I worked as a professional programmer in the past, so complexity of code is not a problem.
A language that works good with a DB (if needed), and one where the functions work in Windows and in Linux is important. Also, a great debugger is paramount, as I anticipate using it a lot when first starting out.
God Bless... Feedscrn
| The screen is hungry, Feed It! |
SELECT ord.orderid,cus.custid,cus.custname,cat.catid,cat.catname,pro.proid,pro.proname from `order` as ord inner join`customer` as cus on cus.custid=ord.custid inner join `category` as cat on cat.catid=ord.catid inner join `product` as pro on pro.proid=ord.proid
there is no error in this query bt still it select no record i dnt know y:(
If no error & no data again your query, there's no matching records for your query(criterias).
You have to check the query on all ways.
First with out any criteria/JOINs ( SELECT * FROM Table )
And add a criteria/JOIN ( SELECT * FROM Table WHERE Column1 = 'Value1' )
And add ...... ( SELECT * FROM Table WHERE Column1 = 'Value1' AND Column2 = 'Value2' )
Try it yourself.
Code converters | Education Needed
No thanks, I am all stocked up. - Luc Pattyn
When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is - Henry Minute
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 'order set custid='4',catid='1', proid='2',quantity='14',totalbill='1400', ' at line 1]
insert into order set custid='$custid',catid='$catid',
SELECT ord.orderid,cus.custid,cus.custname,cat.catid,cat.catname,pro.proid,pro.proname from 'order' as ord inner join 'customer' as cus on cus.custid=ord.custid inner join 'category' as cat on cat.catid=ord.catid inner join 'product' as pro on pro.proid=ord.proid
#1064 - 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 ''order' as ord inner join 'customer' as cus on cus.custid=ord.custid inner join' at line 1
you cannot use 'order' as table name as it is a reserved word in mysql. But you can try using backticks ` to enclose it like these `order`, the backtick can be found on the top left hand side of your 101 keyboard. Do the same for the other tables.
Last Visit: 31-Dec-99 18:00 Last Update: 13-Mar-14 19:47