arwebdesign

Hi, thanks for all the replies! I've now got the system working: when I email that email address with: blah blah blah Name: Bob Blah Blah Blah it inserts "Bob" into the database. My last hurdle here is how to deal with attachments. As I understand it, attachments are stored as a MIME string in the actual MIME data. How can I parse the data out of the raw MIME data that is sent to the PHP file, and then decode the attachment and save it to my server? Thanks!

I have found a tutorial that does what I was looking for (here: http://www.devarticles.com/c/a/PHP/Incoming-Mail-and-PHP/1/ if anyone's interested), but I have one last question: the script provided in the tutorial saves the contents of the body of the email in the variable $message . How can I use PHP to parse $message so that the text after the word "Name: " (that is "name" and then a colon, and then a space), but on the same line as "Name: " is saved into the variable $name ? For instance, if the email was: "Hello, blah blah blah. Name: Example Name Blah Blah Blah" then the PHP script would save the text "Example Name" into the variable $name . Alternatively, if this is not possible, could I make the script parse the $message variable and simply save the first line of the variable into $name ? Thanks, ARWebDesign

Yes, it's true that a web form would be easier, but most of the info will be sent by email and it'd be a lot easier to be able to quickly format the email, and then forward it to a "listener" email address, especially because the emails will include attachments (and it's a lot easier to forward an attachment than to download then re-upload). Can this be done with PHP? How would I direct the PHP to "listen" to the inbox of an email address? Thanks again.

Hi. I'm not so sure if this falls into the category of php (since I'm not even remotely sure how to do this), but I'd like to set up an email address, that, when it receives an email, automatically inserts the contents of that email into a database (for example, if the email is: name: Bob phone: 5556667777 Then it would enter "Bob" into the "name" column of a new row, and "5556667777" into the "phone" column of that same row. Does anybody know how I can go about doing this (php or not), or if it's possible at all? Thanks, ARWebDesign

Thanks, that's great!

I would just use it to limit the number of items that load into the homepage since the games section is of a fixed height.

Thanks so much, this works awesome! Just one quick last question: how can I limit the number of rows? I saw there's a maximum columns variable, but is it possible to make a maximum rows one too? Thanks again!

It's not making the grid in HTML that I'm having trouble with, it's integrating it with PHP. Can anyone lead me in the right direction? Here's my grid code in HTML: <div id="grid"> <table width="875" border="0" cellspacing="10" cellpadding="0"> <tr> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> <td> </td> </tr> </table> </div> <!----end grid----> </div> But obviously, it's empty. How do I fill it dynamically with the data from the database with the highest ID going in the top left cell, and then in descending order by ID. (i.e. the newest game is first, 2nd newst game is second, etc.). -Thanks

Sorry for not being clear before. I think the confusion may be that, in practice, what I'm calling a "grid" would be coded just like a table. However, there would be several more columns and rows, because each cell would hold a thumbnail and a link. Instead of a table with labels across the top (e.g. "Name," "Category," etc.) what I'm looking for has no labels, and is of a set width and height (again, let's say a width of 5 x height of 10). So, that's 50 cells. Each cell has the thumbnail of a game in it, and the link to the game below it. Here's the diagram again of what I'm trying to get: http://dl.dropbox.com/u/6776265/grid_example.png Thanks so much again, Leon

Hey there. Thanks so much for your help so far. I tried the script you gave me and it works well, but it's not a grid like I envisioned, but a simple table. Here's a rough diagram of what I'm trying to achieve: [link=http://dl.dropbox.com/u/6776265/grid_example.png]Example[/link]. Any idea on how to modify the script to get this? Thanks again!

@Alt_F4 Yes, I'm using PhpMyAdmin. And I'm asking how to make a database of games set up the way I described display in a formatted grid. That being said, if there's an easier way to make an easy dynamic portion of the site that displays games, I'd love to know! @Yesideez Thanks so much! I'm going to try it right now and report back!

Hi guys. I'm trying to build a games site for a friend. Currently, the front-end (HTML/CSS) of the site is done. Now, I want to make a way for him to easily add games to the site. Ideally, I'd like to make a database with the following columns: ID, Name, Category, Link, Thumbnail_Link. So, those would be the ID, name of the game, the category, a link to the game, and a link to the 50x50 thumbnail image respectively. Then, using PHP, I'd like to call the first x number (not sure what it will be yet, let's say 50) and make format it as a grid in the following way: There's the thumbnail image followed by the game name, and they're all a clickable link to the game URL. Is this possible? How would I go about doing this? I've already set up a database for a login module to the site, so each page has already opened a connection to the MySQL database. However, I've only ever done basic PHP for mail forms and am otherwise extremely new to it, and am especially new to MySQL. Could anyone walk me through how to do this or even give me a quick example script to work off of? Thanks, any of your time is greatly appreciated!