Thanks, close enough... Fixed it to be
SELECT videos.name, videos.name, category.name
FROM videos, category
WHERE videos.cat =1
AND category.id = videos.cat
and that got me what I needed. I was close before just missed it a bit.
Again thanks.
Bret Lanius
http://bretlanius.com
I'm a bit rusty at hand coding a query
What I want to do is select all fields form table 'videos' where cat=1
but I want the an additional field that shows the cat name instead of the id from cat. The field cat in the table videos corresponds to the id field in the category table.
Bret...
I guess I wasn't that clear. I can figure out how to display a list of dir but what I want to do is to get allow the user to select a filename and the filename is put into the textfield.
I suppose this might end up being more of a javascript question.
Bret Lanius
http://bretlanius.com
I want to allow a user to browse a directory and select a file that then is put into a textfield, Any ideas on an approach to this in PHP?
Bret Lanius
http://bretlanius.com
In case anyone is interested they have to be in the same directory and then you only use the full path on the href link.
<embed src="mycover.jpg" href="./videos/myvideo.mp4" AutoStart="true" type="video/x-m4v" target="myself" scale="1">
where mycover.jpg and myvideo are in the same directory...
I'm building a Ipod/Iphone webapp and all is well but the QT embed is not working as expected...
I'm using
<embed src="mycover.jpg" href="./videos/myvideo.mp4" AutoStart="true" type="video/x-m4v" target="myself" scale="1">
and this works but the cover image has to be in the root like this if I...
There are several plugIns for Firefox to do just that...
https://addons.mozilla.org/en-US/firefox/search?q=flash&status=4
Bret Lanius
http://bretlanius.com
On the server the directories are case senestive. Is there an easy way to handle a user entering in say an all lowercase name like mysub and it take them to mySub anyway?
Bret Lanius
http://bretlanius.com
Don't let the name Ajax scare you... It's just javascript accessing PHP code on the server to do exactly what you want.
Bret Lanius
http://bretlanius.com
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.