Jump to content

Lucky_PHP_MAN

Members
  • Posts

    25
  • Joined

  • Last visited

    Never

Everything posted by Lucky_PHP_MAN

  1. Maybe you can show us a little bit of the sql script for the table? 1. Do an "Export" on your tables and post it here? Regards, LPM
  2. You might want to install Firefox with Firebug Add-ons These addons can help you to check the javascript on that page and the proper html tag to use Hope it helps. Regards, LPM
  3. you might want to add this into the very top of your php script <?php // begin code header ("Content-Type: text/xml"); // end code ?> Hope it helps. Regards, LPM
  4. I nvr tried pg_connect() before, but looking at the manual, the correct syntax should be something like this? $dbconn3 = pg_connect("host=localhost port=5432 dbname=mary user=lamb password=foo"); you have to define a "host=localhost" variable inside the connection string for it to connect successfully? Have no idea though. Hope it helps. Regards, LPM
  5. I'm assuming that your (1,52) is a complete sets of card. I would usually do a pre-defined sets of cards in an array. So, let's say 1-13 = Spades 14-26 = Hearts 27-39 = Clubs 40-52 = Diamonds Then check the number of the cards against these array of cards. It's just an opinion. Hope this help Regards, LPM
  6. The footer html looks fine with me. Could it be that you've attached some CSS that makes it all white? Regards, LPM
  7. That would depends on how are you going to query it out from the database. In all my usual projects, I would do a SQL query to the database to save the name of the folder and the name of the file. It would be something like "uploads/my.new.file.name.ext Again, that would depend on how would your flash is going to read this database. Regards, LPM
  8. Maybe you can show a segment of the code that show the whole HTML page with its footer? that will helps a lot Regards, LPM
  9. well, since it is absolute, it would remain there. how about changing position to relative? is it the same result? Regards, LPM
  10. I'm not sure why your footer would not appear. It would be some of the "die()" method in PHP that makes is stop from intepreting the script. That could have stopped your footer from appearing. Regards, LPM
  11. you might want to check this out http://javascript.internet.com/navigation/cascading-menu.html or google it for better results Regards, LPM
  12. Not A Problem Good luck Regards, LPM
  13. Why don't you try out XAMPP? It is a very nice bundle of Apache, MySQL and PHP Worth to give it a try. Regards, LPM
  14. I would assume that all these images are inside "Images/Random/" folder. If so, you might need to add a slash at the end of your $image_folder string. // Change to the location of the folder containing the images $image_folder = "images/random/"; // added a slash at the end The above will point the image to "images/random/{random_number}.gif Hope it helps Regards, LPM
  15. I hope I assumed correctly that you were just trying to list out everything basically whether it has images or no images, if so my solution would be. 1. Take off the "lu.listings_id = l.id" statement. 2. Modify the column inside your DB table which is "thumb_url" in this case to "nopic.jpg" or 3. You might want to let PHP do some checking. IF (thumb_url is empty) img src=nopic.jpg ELSE img src=somepic.jpg Hope this helps Regards, LPM
  16. Yes. For example, the url looks something like this "http://localhost/get_image.php?image_path=http://www.yourdomain.com/resources/private/upload/image010101.jpg" in ur PHP scripts $image_path = $_GET['image_path']; /* the above would return "http://www.yourdomain.com/resources/private/upload/image010101.jpg" */ Hope this helps Regards, LPM
  17. Let me break down the ur query here and see whether the logic of the query is there $query_title = mysql_query("SELECT l.title, l.id, l.image, l.search_text, lu.thumb_url, lu.full_filename, lu.listing_id, lu.image_width, lu.image_height FROM listings l JOIN listings_urls lu ON lu.listing_id = l.id WHERE search_text LIKE '%$value_to_find%' AND live = 1") or die(mysql_error()); 1st part SELECT l.title, l.id, l.image, l.search_text (you wanted to get the title, id, image, search text FROM listings table) 2nd part lu.thumb_url, lu.full_filename, lu.listing_id, lu.image_width, lu.image_height (you wanted to get the thumb_url, full_filename, listing_id, image_width, image_height FROM listings_url table) 3rd part listings l JOIN listing_urls lu (joining the 2 tables in when query is run) 4th part ON lu.listing_id = l.id (Condition on JOIN => lu.listings_id matches l.id) 5th part WHERE search_text LIKE '%$value_to_find%' AND live = 1 (another condition "search_text" LIKE '$value_to_find' AND live is 1) I was wondering where u can use JOIN, ON, "and" WHERE together. That's just my guess. Maybe you might want to take off the WHERE condition to see whether you query has results in it. Regards, LPM
  18. It looks like it is very much Ads-based website. I would assume that this particular PHP-script is designed with "Advertising" in mind. I was wondering if you take note of that. Regards, LPM.
  19. I have yet to try them. But you can specify a GET variables. When you try a URLRequest, you might want to specify some like "http://localhost/example.php?var1=value1&var2=value2" that should work when ur PHP script contains $_GET to get these values. Regards, LPM
  20. It seems the query that you run returned no result. you might want to fix that by breaking down those SQL into different parts and try them 1 by 1. Hope it helps. Regards, LPM
  21. Yes, It is possible to use a file upload. PHP provide function such as $_FILES, which is used to get the file and some of its properties. check out this link http://sg.php.net/manual/en/features.file-upload.post-method.php you can do a query to insert the filename and its path to the database. As for the Flash part, it is possible to generate the XML for the particular image. You just have to echo with "XML" in mind. Here is a short example. // declare XML $xml = "<?xml version=\"1.0\"?>\n"; // insert root node example $xml = "<root></root>"; // insert node example $xml = "<child></child>"; echo $xml; the above will echo out the XML in which in ur flash, you might want to do a URLRequest and URLLoader to load the file above. Flash will read the file header and regard it as XML file. Regards, LPM
  22. The current MySQL that I knew does able to store images, provided you define the "MIME Transformation" in the column of the table that you've created. But it would be very heavy resources if you are handling big big queries. I would recommend inserting the "path/to/the/image" into the database as it will speed up process as MySQL Engine only had to work with text rather than some MIME-type. For the Flash, I used XML to work with because some of the APIs in actionscript that make retrieving data from XML easy. Regards, LPM
  23. What's the error you get? o.O The code looks pretty fine with me. Regards, LPM
  24. I would assume that you are trying to update the record on your database by means of using a form to retrieve the old records and updating its new value. If it is as of above, you can retrieve the old values of the record and populate that into your forms and when the user submit, you can use the UPDATE method in MySQL to update your data. Regards, LPM
×
×
  • 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.