hitman6003

That error means there is something wrong with your query. change this line: [code]$sql = mysql_query("SELECT * FROM users ORDER BY id DESC");[/code] to: [code]$sql = mysql_query("SELECT * FROM users ORDER BY id DESC") or die(mysql_error());[/code] then let us know what the error is.

In your included files, for example gallery.php, make sure that you have the full path to the file to be included from gallery.php. Meaning use: [code]include("/includes/somefile.php");[/code] not just: [code]include("includes/somefile.php");[/code] You shouldn't have to put the full path to the file from the file system (/usr/username/... or c:\www\files\includes...) just from the document root should be fine.

127.0.0.1 is the loop back address...in other words, your computer is looking to itself for the files. Unless your computer is also the server, it will fail. Even if your computer is the server, it may fail...I've never tried using 127.0.0.1. Change it to the server name rather than that IP address.

The php manual has a pretty indepth look at handling file uploads. [a href=\"http://us3.php.net/manual/en/features.file-upload.php\" target=\"_blank\"]http://us3.php.net/manual/en/features.file-upload.php[/a] It includes limiting the file size. Limiting dimensions can be done using getimagesize (http://www.php.net/getimagesize), which returns, among other things, the height and width of the image.

[a href=\"http://www.php.net/mysql_real_escape_string\" target=\"_blank\"]http://www.php.net/mysql_real_escape_string[/a]

[!--quoteo(post=355172:date=Mar 14 2006, 08:17 PM:name=PupChow)--][div class=\'quotetop\']QUOTE(PupChow @ Mar 14 2006, 08:17 PM) [snapback]355172[/snapback][/div][div class=\'quotemain\'][!--quotec--] do I also just join the table first if I want to delete a record? [/quote] No, you'll have to delete each of them.

There's nothing about it that's hard to manage...every time a record is inserted into the db, it assigns it the next incremental id. Potential table structure: [code] person     ID     Name     Address     Phone workinfo     ID     personID     Salary[/code] sample query: [!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] Name, Address, Phone, Salary [color=green]FROM[/color] [color=orange]person[/color] [color=green]LEFT[/color] [color=green]JOIN[/color] workinfo ON person.ID [color=orange]=[/color] workinfo.personID [color=green]WHERE[/color] Name [color=orange]=[/color] [color=red]'Some Name'[/color] [!--sql2--][/div][!--sql3--]

Why were you told not to use auto-increment?

[!--quoteo(post=355154:date=Mar 14 2006, 07:26 PM:name=Steveo31)--][div class=\'quotetop\']QUOTE(Steveo31 @ Mar 14 2006, 07:26 PM) [snapback]355154[/snapback][/div][div class=\'quotemain\'][!--quotec--] The spaces between "f" and "write", etc are synatx errors. [/quote] Yeah, the forum is acting funny...it won't let you post without the spaces there...gives an error...at least for me. Hopefully, he knows to remove them.

Don't redirect anywhere to add the new table rows. Use js to create them when the button is pressed. [code]<script type="text/javascript">     function addrow() {         var t = document.getElementById('testtable');         var newrow = document.createElement("tr");         var newrtd = document.createElement("td");         var newltd = document.createElement("td");                  newrtd.appendChild(document.createTextNode("test row 2"));         newltd.appendChild(document.createTextNode("test row 2"));         newrow.appendChild(newltd);         newrow.appendChild(newrtd);                  t.appendChild(newrow);     } </script> <form name="testform" id="testform"> <table id="testtable">     <tr>         <td>sample row</td>         <td>sample row</td>     </tr> </table> <input type="button" value="add row" onclick="addrow();"> </form> [/code] Not exactly what your asking for, but you get the idea.

I would use javascript for this. You can create the table and form elements as you go along, then when the submit button is pressed, the page is sent on. Then you aren't constantly going to the server for, really, no reason.

This should help. [code]if ($handle = opendir("/home/mysite/public_html/Store/{$thestore}/Images/")) {     while ($file = readdir($handle)) {         if (strlen($file) >3){             $files[] = $file;         }     }     closedir($handle);          sort($files);     foreach ($files as $file) {         echo "<OPTION value=\"Store/{$thestore}/Images/{$file}\">$file</OPTION>";     } } if ($handle = opendir("/home/mysite/public_html/Images/Backgrounds/")) {     ...same as above... }[/code]

[!--quoteo(post=355142:date=Mar 14 2006, 07:03 PM:name=brown2005)--][div class=\'quotetop\']QUOTE(brown2005 @ Mar 14 2006, 07:03 PM) [snapback]355142[/snapback][/div][div class=\'quotemain\'][!--quotec--] can i do the following:- [/quote] Yes. [code]header("location: $config");[/code]

That is without a doubt, the messiest code I have ever seen. It just makes no sense at all. Please clean up your code.

The only way to ensure that everything works correctly and user security (account numbers/passwords) remains intact, is to go through the company itself. If their website isn't clear, then contact them by phone if necessary. Otherwise, you run the risk of inadvertantly exposing your users information.

Crazy forum software...caused a double post.

The forums are acting funny today, so I'll do what I can: [code]$ name = "path/to/f ile.txt"; $ type = m ime_content_type($name); $ size = f ilesize($name); h eader("C ontent-length: $size"); h eader("C ontent-type: $type"); h eader("C ontent-Disposition: attachment; f ilename=$ name"); echo f ile_get_contents($ file);[/code] remove the random spaces I've put throughout

[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]Incorrect integer value:"for column 'q1' at row 1[/quote] My guess would be that you are trying to insert an incorrect integer value into the q1 field for your table. Check the data type of that field...if it's supposed to be an INT, then make sure you are trying to insert an INT, if it's not supposed to be an INT, then change it. echo out your query if needed to check that it is correct as well.

Change: [code]$real_name = mysql_result($result,0,"real_name"); //$one = mysql_result($result,0,"one"); print "&real_name=$real_name"; //print "&one=$one";[/code] to: [code]for ($i = 0; $i < mysql_num_rows($result); $i++) {   print "&real_name=" . mysql_result($result,$i,"real_name"); }[/code] You may have to add in a "\n" or something along those lines for flash to intrepret each one seperatly.

Why are you supressing errors on your query when it's giving you problems? change it to: [code]$res = mysql_query($qu) or die(mysql_error());[/code]

As pulled from this (http://us3.php.net/manual/en/language.expressions.php) page in the manual: [!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--] There is one more expression that may seem odd if you haven't seen it in other languages, the ternary conditional operator: [code]<?php $first ? $second : $third ?>[/code] If the value of the first subexpression is TRUE (non-zero), then the second subexpression is evaluated, and that is the result of the conditional expression. Otherwise, the third subexpression is evaluated, and that is the value.[/quote] EDIT: Also, see this page: [a href=\"http://us3.php.net/manual/en/language.operators.comparison.php#language.operators.comparison.ternary\" target=\"_blank\"]http://us3.php.net/manual/en/language.oper...parison.ternary[/a]

If you want to remove the $_SESSION['some_array'] totally, use [code]unset($_SESSION['some_array']);[/code] If you want to set it to a blank array: [code]$_SESSION['some_array'] = array();[/code] Set it to a blank string: [code]$_SESSION['some_array'] = "";[/code] If you want to remove a single element of the array $_SESSION['some_array']: [code]unset($_SESSION['some_array']['some_value']); or $_SESSION['some_array']['some_value'] = "";[/code]

Change: [code]for($n=$start_yr;$n<=$start_yr+5;$n++)[/code] to: [code]//for descending years for($n=$start_yr;$n>=$start_yr-50;$n--) //for ascending years: for($n=$start_yr-50;$n>=$start_yr;$n++)[/code]

Two ways: Select all the addresses out of the db, then loop through them to create a long $to variable for your mail() function, then send a single email. The down side of this, is that all of your subscribers will see the other's email addresses. Select all the addresses, then loop through and send an email to each one. It means a lot more emails, which your host may not appreciate, but the recipients will not be able to see anyone's address but their own.

Your missing the variable delimiter ($) before your array variable: '[!--coloro:#FF0000--][span style=\"color:#FF0000\"][!--/coloro--]$[!--colorc--][/span][!--/colorc--]qid[0]','[!--coloro:#FF0000--][span style=\"color:#FF0000\"][!--/coloro--]$[!--colorc--][/span][!--/colorc--]qid[1]','[!--coloro:#FF0000--][span style=\"color:#FF0000\"][!--/coloro--]$[!--colorc--][/span][!--/colorc--]qid[2]','[!--coloro:#FF0000--][span style=\"color:#FF0000\"][!--/coloro--]$[!--colorc--][/span][!--/colorc--]qid[3]','[!--coloro:#FF0000--][span style=\"color:#FF0000\"][!--/coloro--]$[!--colorc--][/span][!--/colorc--]qid[4]','[!--coloro:#FF0000--][span style=\"color:#FF0000\"][!--/coloro--]$[!--colorc--][/span][!--/colorc--]qid[5]','[!--coloro:#FF0000--][span style=\"color:#FF0000\"][!--/coloro--]$[!--colorc--][/span][!--/colorc--]qid[6]','[!--coloro:#FF0000--][span style=\"color:#FF0000\"][!--/coloro--]$[!--colorc--][/span][!--/colorc--]qid[7]','[!--coloro:#FF0000--][span style=\"color:#FF0000\"][!--/coloro--]$[!--colorc--][/span][!--/colorc--]qid[8]','[!--coloro:#FF0000--][span style=\"color:#FF0000\"][!--/coloro--]$[!--colorc--][/span][!--/colorc--]qid[9]'