beav33

Ok, then you store the picture file on the server. Is there a tutorial on how to do this and retrieve the pic anywhere?

It's not? Using phpmyadmin 2.6.3. I have a table that stores some info from users. Can I make a colmn to store pictures and if so, how or what is the sql. Beter?

Know this prob stupid, but having trouble. I want to allow a user to upload a picture of their house for my real estate site. How do I design the colmn in the table with the rest of the house info. I have no clue, and no clue how to put conditions on the size. Thank you beav33

You Rock, Thank You Beav33

Ok on a new mission. Killed the time issue and will address it later, but I still want the date to be on central U.S. Yahoo goes off international Greenwich. So how do I subtract 6 hours with this code. <?php echo date('M d, Y');?> Thanks Beav33

I'm not even sure what time zone the codes going off of if its showing the 4 of feb already. So lets say central U.S., thats where I reside.

Need Help. Now on my website my echo date is showing it as the 4 of feb. I was wondering is there anyway to make it per time zone for different customers areas. code <?php echo date('M d, Y');?>Please help if possible thank you beav33

What I was afraid of. I will generate a random Thank you for your help beav33

Heres the prob. I have a forgot password page, and I am being lazy. I dont want to generate a new password, I just want to send them their original one. How do I unconvert the md5. [color=red]$email=$row_Recordset1['email']; $password=$row_Recordset1['password']; $toaddress = $email; $subject ='bla'; $mesg ="bla"; $fromaddress ='bla'; mail($toaddress, $subject, $mesg, $fromaddress);[/color] This sends an email with the password in md5, so how do I change it back to original form? Thank You for help beav33

My question is does it matter which one you us if your search form is short. Meaning, the search form I am using is no where near 8192characters, but the results from the db will be in the thousands. So can I still use GET or do I have to use POST. Might be stupid question, but it is stumping me bad, lol. Thank you

I have a page that is restricted to logged in users. What I need is a way to prevent the user from using the back button after submitting a form, so he doesnt resend it. Can someone help me please. Thank you.

Try new example for some help I have a search page for houses Using city, state OR zip Also property type and price range. Now if somebody leaves property type OPTION open And price range OPTION open how do I run a wildcat search with the city, state OR zip selected, and these open, for that location With the city, state I using a query of = for state and LIKE for city. For the zip I use the = When I ad OR for property type it works but for all locations, not the state or zip selected. ex: Select * FROM houselisting WHERE (`state` = colstate OR `city` LIKE %colcity%) OR `zip` = colzip OR `propertytype` = colproperty

Thank you I worked it out, but when I run a search with 2 or more varibles is there some way to run a wildcat. Meaning if someone doesnt type in a varible in say "city" for the search, then my search doesnt work. I figured out the "=" for exact and "LIKE" for something close. If its blank the search shows nothing, even if there is something for the other varible, for instance "state". Can you do something with "OR" to solve this problem or do I have to make multiple search forms to get around this. Hope this makes sense Thank you beav33 $query_Recordset1 = sprintf("SELECT propertytype, squarefootage, askingprice, `city`, `state`, zip FROM houselisting WHERE `state` = %s AND `city` LIKE CONCAT('%%', %s, '%%')"

I created a db and added content to it. Now I want to get it out. I created a recordset for a simple search for houses buy state. It works fine in the test, but when I add the dynamic table I get this on the page Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\wamp\www\offers4house\results.php on line 12 I have followed every help page and still cant figure it out. Line 12 is the next to last line of this code for the dynamic table <table border="1" cellpadding="1" cellspacing="1"> <tr> <td>state</td> </tr> <?php do { ?> <tr> <td><?php echo $row_Recordset1['state']; ?></td> </tr> <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?> </table> I can include the rest of the dreamweaver php for the recordset and query if needed. Please Please Please! Help beav33

[b]In my site I set up a search page to probe the db. In dreamweaver I used a recordset, then to display the info, I used a dynamic table. Every test works fine but when uploaded the results page shows an error coming I think from the dynamic table code from this. [/b] <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?> [b]Whole code for table is [/b] <?php mysql_free_results($Recordset1); ?> <table border="1" cellpadding="1"> <tr> <td>state</td> </tr> <?php do { ?> <tr> <td><?php echo $row_Recordset1['state']; ?> </td> </tr> <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?> </table [b]ERROR on page[/b] Warning: mysql_fetch_assoc(): is not a valid MySQL result resource in C:\wamp\www\offers\results.php on line 68 [b]Has anyone had this problem, or knows what this function is or why I am getting it. Any help Please Thank you beav33[/b]