Jago6060

Hi all, I'm looking to basically put together a website for myself to act as a resume. The actual info is easy, but I'm stuck on the design. I want to do something professional yet cutting edge. Something to really hightlight my coding skills. I've see some really nice looking sites with overlapping divs/images and the like. I'd like to do something like that but I'm not sure where to begin other than with some sketches. Any help from the pro-designers would be greatly appreciated!

Ok Just one quick question...the table that I'm importing a CSV into has some 20+ columns/fields but I need to copy csvfile.column1 into table.column18. Via your provided link, I can't see a way to delineate what columns of the CSV file go into what columns of the table.

Hi all, I've spent some time googling trying to find a tut to show me how to load data into a postgresql database but haven't found anything that great. Can anyone point me in the direction of a good one?

Ok I'll give this a shot...Just let me know if I'm correct SELECT project_status_id, CASE WHEN id = 96 THEN 'ThisIsMyLabel' ELSE originalLabel END AS originalLabel FROM im_project_types; Am I close? I interpret this statement as "select project_status_id, when the id is 96, change the label to ThisIsMyLabel, else leave the original label; do this is the im_project_types view". Am I correct in my translation?

Yeah I need to edit some of the values. As I said, I'm not well versed in MySQL so I'm not really sure how to implement the query your provided. Here is the view in question... View:im_project_types project_type_id | project_type -----------------+------------------------- 85 | Unknown 86 | Other 2501 | Consulting Project 97 | Strategic Consulting 98 | Software Maintenance 99 | Software Development 4300 | Bug Tracker Container 4305 | Bug Tracker Task 10000012 | Directory 92 | Technology 2500 | Translation Project 90 | Linguistic Validation 91 | Localization 93 | Trans Only 95 | Proof Only 94 | Trans + Int. Spotcheck 2503 | Trans Only (Dynamic WF) 89 | Trans + Edit + Proof 88 | Edit Only 87 | Trans + Edit 96 | Glossary Compilation 100 | Task 10000006 | Implementation 10000007 | Optimization 10000008 | Monthly Bill Review 10000009 | TestCategory 10000010 | Administration 10000011 | Monthly Review (28 rows) Lets say I want to change the project_type where project_type_id=96. Could you give me an example of how I would use the actual view data to replace the foo,bar, and label variables in your above statement?

That renames the column...is there a way to rename a field entry? Ex: change label1 where id=1; ???

I don't have a script to create the values in the view, I have to do it manually. Can I do something like... ALTER VIEW view1 REPLACE label1 WITH newLabel WHERE label_id=1;(I'm not well versed in MySQL btw :-P)

Hi all! I have a view in a postgresql database that I need to change. It only has 2 columns, col1 being an autogenerated INT, col2 being a string. The values in col2 are basically just labels that need to be changed to something else. How do I change the values in col2?

Not quite. I'm looking for something like what MSAccess does. Where it shows your tables and puts a line between related fields. Basically a database map... TableA.field1-------TableB.field1 | ------TableC.field1 Not the best representation, but it illustrates my point.

Hi all. I have a database that I didn't create, it was made by the developers of an open source program that my company uses. I haven't been able to find a data model for the DB, so I was wondering if there was some sort of tool that will visually show the relationships in a DB. Or a program that will allow me to upload a DB, and it will show me the visual representation. Any ideas?

TableA: native data TableB: client data TableA.fields!=TableB.fields Is there a way(on import) to change the field names of TableB to match those in TableA? Something like... INSERT INTO TableA(project_id)VALUES('project_id="TableB.Project ID"') FROM FILE project.csv;

It was the PHP version causing the problem. I contacted the hosting company and had them update the PHP version to PHP5 and now it works. Lesson learned

I think the trouble may be with the version of PHP. The software works on my server which has teh following... root@supermicro:~# php --version PHP 5.2.6-3ubuntu4.1 with Suhosin-Patch 0.9.6.2 (cli) (built: Apr 23 2009 14:37:14) Copyright (c) 1997-2008 The PHP Group Zend Engine v2.2.0, Copyright (c) 1998-2008 Zend Technologies The software was copied over to the hosting provider from the server mentioned above.

Something else I should mention is that this function is a small part of a larger encompassing function. Idk if that makes a difference but I thought it might be something to note.

People on this forum should be smart enough to not do the assignment then post it for him, in which case, you really have nothing to worry about. This site helped me through all of my programming courses without anyone ever doing my assignment FOR me, only showing me where to find what I needed. So in short, post specific questions and you'll get help

Ok I have to append info to this since I apparently cannot edit my post more than twice... The PHP version listed above, is what the host company tells me the PHP version is, but I uploaded a script with just phpinfo() in it, and the version listed by that is 4.4.9. So I'm assuming that 4.4.9 is the actual PHP version.

I'm trying to use a program called GLPI via my company's website and I've run into some issues. It appears to be a problem with the code. MySQL v5.0.81 PHP 5.2.6-3Ubuntu4.1 Here is the error... Parse error: syntax error, unexpected T_STRING, expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or '}' in /homepages/18/d258816375/htdocs/glpi/inc/dbmysql.class.php on line 334 Here is the corresponding code at the given line number... public function request ($tableorsql, $crit="") { return new DBmysqlIterator ($this, $tableorsql, $crit); }

After much communication with the host site tech support, they've determined that the issue is with Adobe's software and not them....

An upload with the updated code still gives the same error. "Document is damaged and cannot be repaired". I DO greatly appreciate the updated code you provided. I guess I'll need to contact the host provider and see if they can tell me anything. I'll be sure to update when I find out what's going on.

I didn't specify encoding in the script as it was working up until recently. The form... <? session_start(); if (isset($_SESSION[user])){ echo " <h2>Upload a Newsletter</h2> <form enctype=multipart/form-data action=upload_news.php method=POST> <input type=hidden name=MAX_FILE_SIZE value=2097152 /> Choose a file to upload: <input name=uploadedfile type=file /><br /> Select the corresponding month: <select name=month> <option>January</option> <option>February</option> <option>March</option> <option>April</option> <option>May</option> <option>June</option> <option>July</option> <option>August</option> <option>September</option> <option>October</option> <option>November</option> <option>December</option> </select><br> Please select a day: <select name=day> <option>1</option> <option>2</option> <option>3</option> <option>4</option> <option>5</option> <option>6</option> <option>7</option> <option>8</option> <option>9</option> <option>10</option> <option>11</option> <option>12</option> <option>13</option> <option>14</option> <option>15</option> <option>16</option> <option>17</option> <option>18</option> <option>19</option> <option>20</option> <option>21</option> <option>22</option> <option>23</option> <option>24</option> <option>25</option> <option>26</option> <option>27</option> <option>28</option> <option>29</option> <option>30</option> <option>31</option> </select> <br> <input type=submit value=Upload File /> </form> "; }else{ header ('Location: index.php'); exit; } ?> The upload script... <? session_start(); if (!isset($_SESSION[user])){ header ('Location: index.php'); } include 'connect.php'; $month = $_POST[month]; $day = $_POST[day]; // Where the file is going to be placed $target_path = "./uploads/news/"; /* Add the original filename to our target path. Result is "/uploads/news/filename.extension" */ $target_path = $target_path . basename( $_FILES['uploadedfile']['name']); $_FILES['uploadedfile']['tmp_name']; if(move_uploaded_file($_FILES['uploadedfile']['tmp_name'], $target_path)) { @mysql_select_db($database) or die( "Unable to select database"); $delete_record = "DELETE FROM crc_news WHERE news_id=1"; $delete_record_result=mysql_query($delete_record); addcslashes($target_path, ' '); $sql = "INSERT INTO crc_news (news_id,news_dir,month,day)values('1','$target_path','$month','$day')"; $result=mysql_query($sql); mysql_close(); header ('Location: logout.php'); }else{ echo "There was an error uploading the file, please try again!<br>"; echo "<a href=upload_news_form.php>Back</a>"; } ?> </body> </html> P.S. I missed your question about storage limit earlier. I'm not over the storage limit, and just for reference, the file size is 51KB

That was a way drawn out anwser, haha. Tried the ASCII mode in gFTP and it worked. So now my problem is, how do I apply that with PHP? I don't really understand what gFTP is doing when it uses ASCII mode for the file transfer. My thought would be that its changed the file encoding. Is this a safe assumption? P.S. The default transfer mode is Binary

Just a quick question. I've heard of a "PHP_SELF" function/action. What would be the difference between just leaving action blank and using the "PHP_SELF" action?

If you're just looking to essentially serve webpages with PHP/MySQL, just download WAMPServer or XAMPP for Windows. Both of those programs handle the Apache web server, PHP, MySQL, and some extras. You'll probably need to though. Its definitely not complicated though, 5 minute setup for both programs. Keep in mind... "Linux:In a world without walls, who needs Windows?"

Did you try that? Gave the direct ftp a shot, no dice...I used gFTP to do the transfer. Ftp-ed the pdf over to the host service, tried opening up the pdf in the file manager and it gave the same error. Mention was made to using UTF-8 encoding, I don't see anywhere in gFTP to change that, but there is a check box labeled "Transfer files in ASCII mode". Will this fix the corruption issue?

~Bump~