Jump to content

gple

Members
  • Posts

    166
  • Joined

  • Last visited

Everything posted by gple

  1. Does this look ok? $query="select *, (pts/gp) as ppg from ostats JOIN teams on ostats.tid=teams.tid JOIN players on players.id=ostats.id where teams.year='$season' and gp>3 and order by ppg desc";
  2. Thanks but what if I needed to pull out more info from another table table1 (team, year) table2 (player, team) table3 (player, stat) how do I join all three so I can see the stat from table3 by plugging in the year?
  3. Here are three tables and a column associated with that table table1 (year) table2 (year,name) table3 (name, id) How do I create a select statement to pull out information in table3 according to the year that is entered.
  4. I am using a free host that has been upgraded to PHP5 called 65gb.com. Has anyone used this host and noticed that when I try this on one page: <a href=prod.php?sub=beef>Beef</a> which creates a link and when I click on the link I am supposed to see "Beef". The php script on the prod.php page is: echo $sub; I dont see me doing anything wrong. Any suggestions.
  5. I have the following code: $myFile = "testFile.doc"; $fh = fopen($myFile, 'r'); $theData = fread($fh, 5); fclose($fh); echo $theData; but it outputs some weird stuff as below: ÐÏࡱá����������������>��þÿ ���������������*����������,������þÿÿÿ����)���ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿì¥Á�q` ��ð¿������������� ���bjbjqPqP������������������ �.��:�:� �������������������������������ÿÿ���������ÿÿ���������ÿÿ�����������������¤�����¤������¤��¤������¤������¤������¤������¤�������������¸������Ü������Ü������Ü������Ü�����è�����¸������÷��¶�����������������������������������������������������������v�����x������x������x������x������x������x��$���­��h����Ž���œ���������������������¤���������������������������������������������������������œ��������������¤������¤����������������������������±�����R������R������R���������"���¤�������������¤�������������v��������������R�������������������������������������������������������������v��������������R��������������R������¤������¤��������������������������������������������������������������R�������������ô����� ‹ªm‰¹Ç��������Ü������"�� ���R��������������v������Ç��0���÷������R������£������,�����£������R������������������������������������������������������������������������������£��������������¤������R��$�����������������R�������������������������������������������������������������������������œ������œ��������������������������������������<����������������������������������������������������������÷������������������������������������������¸������¸������¸��$���Ü������¸������¸������¸������Ü������¸������¸������¸������¤������¤������¤������¤������¤������¤������ÿÿÿÿ�����������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������This
  6. If I have a word such as (c_text) in a variable $p. How do I output just text. I know to use the substring function but the text will vary and the amount of characters will vary.
  7. Actually I need this online so someone can see the work that is being done. So I need a web host
  8. Does anyone know a web host that uses PHP5 on their server but is free. I just want to do some testing.
  9. This needs php 5. my server is only 4. Anyway around this?
  10. Is there any way to output a list of directories from a folder?
  11. That works but the values have two words (ie Baseball Cards) and only Baseball is outputted. HOw do I get around this?
  12. If I have a list in which I can choose multiple values (ie) echo "<form action=edit_prod.php?enter=4 method=post>"; echo "<select name=type_size size=6 multiple>"; for ($i=0;$i<$num;$i++) { $type_size=mysql_result($result,$i,"type_size"); echo "<option value=".$type_size.">".$type_size."</option>"; } echo "</select>"; echo "<input type=submit name=submit value=Update></form>"; How do I bring all the values over so I can insert all the values into a table?
  13. echo "<A HREF=javascript:popUp('image_up.php?image=".$image."')>Open the Popup Window</A>"; the problem here is that the image is something like (new image1.jpg). It only reads new and ignores after the space. Any idea.
  14. Anyone know of a way in pHp in order for this: Click on a thumbnail image and a new screen pops up but only as the size of the image. I have found some java script stuff but it doesnt seem to be working with my php coding. Any way to do this without java script and with php.
  15. If I have the URL to an image in my directory. How can I use PHP to delete that file?
  16. I am trying to output an image with text coming from a database" $image=mysql_result($result,$i,"image"); trying to output it like this: <img src=../prod_images/" . $image . " height=90> problem is that some images have a space in the text like "image 1". When it is outputted onto the screen, the browser does not read anything after the space. How can I get around this?
  17. Is there any way to pause inside a loop? If I want to pause for 1 second between each output, is that possible
  18. I am using the array_diff function and the code is below: $result_e = array_diff($team_list, $list); print_r($result_e); When I output the result of this function, it looks like this: Array ( [4] => Astoria A [5] => NAK B [10] => NAK C ) How can I make the output just look like this: Astoria A NAK B NAK C
  19. NO i am not using that. This started happening last night. I run the website and database off the website host.
  20. Occasionally on my website I will get this message appearing "Too many connections" where there is php code. On all of my php pages I am accessing a db but I dont have the mysql_close syntax. Is this causing this message?
  21. Sorry not in the subject. I mean in the body of the page.
  22. I am using php mail to send email out to a list of people. In the suject I have a link but when receiving the email, the link is just text and not a hyperlink to click on. HOw can I format this in the PHP mail function to do this.
  23. This is only supposed to work when sending email from an aol account. I am not trying to do that, I am trying to send out a mass email from a PHP form. I tried doing this from an AOL account as well and it tells me that AOL does not support this and to use the BCC line.
  24. NO I am pulling all of the addresses into that variable.
  25. I have a table full of email addresses and I concatenate the addresses into one variable separating each email address with a comma so the variable is like this: email1@hotmail.com, email2@hotmail.com, email3@aol.com I set up my function to send an email with these addresses in the BCC line. the email goes to the hotmail addresses but not to the aol address. If I put this in the to line the email goes to all the addresses. I basically want to send out an email to multiple addresses without each person seeing the other addresses I sent it to. I know it sounds like Spam but this is a mailing list.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.