Monday, June 16, 2008

I already own my Domain- which I have purchased from GoDaddy.com
Are there any free hosting companies who would be willing to host it free? I need it to have FTP- cPanel- and MySQL databases. Thank you!

Im trying to build my own web server for my forum and i plan to use SMF for the forum engine. I know that it requires apache+php+mysql and i already got the installer. from this point i dont have a clue how to set the server up. do i just install them or i need to do something else to get it working? do i need phpmyadmin? im using windows xp. (dont suggest using Wamp5)

Whats it called when you store more than one page in PHP and how do I do it?
example: instead of having around 6000 html/php pages in a website- could I use one php page (pages.php?examplepagename- or pages.php?view?examplepagename)- If I could- can you please send me some tutorial links (free ones only) or some code snippets that will help me.
Thanks oh- and I dont like MySQL or PHPmyadmin.

I have 2 tables. One has some items (fields: id- title ...) and one has pictures for the items (id- itemid- pic). I need to create a list with the items and the first pic of each one.

If i do a

SELECT items.*-pics.pic FROM items-pics WHERE items.id=pics.itemid

I only get the items that have pictures. I need to fetch all the items- even those that don t have pictures. Which is the best way to do it?

I though about fetching the items first and then doing another query to fetch the pictures for the items I had fetched before- but it seem like a hack.

Which would be the most elegant solution?

I wish to modify records in a mysql db by running a php script...
if the script is physically located on same server- how do i instruct it to execute?

can i run a php script on a server to modify mysql records located on the same server?

No comments: