surfsup

Can someone help me with commands to dump an entire DB schema with only one row of data to an sql file THanks Much appreciated

Sorry yeah thats is a different issue try http://www.dyer-smith.com/villasites/examples.php I have checked on another IE6 and still same problem Just don't get it . Help

Failry simple navigation bar created buthaving issues in that it does not show in IE6 Look at www.villasites.com in FF the about option has a dropdown... not in IE6 but no error showing Here is nav bar code <ul id="navbar"> <li><a href="#"><img src="images/about_top.gif" alt="about" width="85" height="11" border="0" /></a><ul> <li><a href="index.php">Home</a></li> <li><a href="whatwedo.php">What We Do</a></li> <li><a href="packages.php">Packages</a></li> <li><a href="gobespoke.php">Go Bespoke</a></li> <li><a href="whoarewe.php">Who Are We</a></li></ul></li> <li><a href="examples.php"><img src="images/examples.gif" alt="examples" width="110" height="11" border="0" /></a></li> <li><a href="prices.php"><img src="images/prices.gif" alt="prices" width="84" height="11" border="0" /></a></li> <li><a href="contact.php"><img src="images/contact.gif" alt="contact" width="94" height="11" border="0" /></a></li> </li> </ul> and this is relevant CSS #navbar { margin: 0; padding: 0; height: 1em; } #navbar li { list-style: none; float: left; } #navbar li a { display: block; padding: 0px 0px; background-color: #5e8ce9; color: #fff; text-decoration: none; } #navbar li ul { display: none; width: 8em; /* Width to help Opera out */ background-color: #BEE1E1; font-family: Georgia, "Times New Roman", Times, serif; font-size: 12px; color: #666; } #navbar li:hover ul { display: block; position: absolute; margin: 0; padding: 5px; } #navbar li:hover li { float: none; } #navbar li:hover li a { background-color: #BEE1E1; border-bottom: 1px solid #fff; color: #000; padding: 5; } #navbar li li a:hover { background-color: #8db3ff; } Thanks ???

Excellent thanks worked a treat

OK this is a bit basic probably BUT I have 2 recordsetsRS1 RS2 RS1 has one record with column Food1 conataing cheese,ham,toast RS2 also has column Food2 but with only one food type. I want to filter RS2 so it only shows those records have one of the comma seperate values in it's Food Column Does that make sense Thanks

Yes you are correct. I switeched that but still get this error Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\home\Default\fireflylodges.com\htdocs\property.php on line 17 line 17 being

Newbie so bare with me. trying to filter a recordset with 2 variables submitted from a form. i.e. If user selects dropdown the results will be filtered by that value alone. If user selects value from both results filtered by both values This works fine for one <?php $colname_rs_Results = "%"; if (isset($_GET['v_sleeps'])) { $colname_rs_Results = $_GET['v_sleeps']; } $colname2_rs_Results = "%"; if (isset($_GET['v_location'])) { $colname2_rs_Results = $_GET['v_location']; }?> <?php mysql_select_db($database_FireFly, $FireFly); $result = mysql_query("SELECT * FROM ff_villas WHERE v_sleeps = $colname_rs_Results"); while($row = mysql_fetch_array($result)) { echo $row['v_name'] ; echo "<br />"; } ?> but this gives me errors <?php $colname_rs_Results = "%"; if (isset($_GET['v_sleeps'])) { $colname_rs_Results = $_GET['v_sleeps']; } $colname2_rs_Results = "%"; if (isset($_GET['v_location'])) { $colname2_rs_Results = $_GET['v_location']; }?> <?php mysql_select_db($database_FireFly, $FireFly); $result = mysql_query("SELECT * FROM ff_villas WHERE v_sleeps = $colname_rs_Results AND v_country = $colname_rs_Results"); while($row = mysql_fetch_array($result)) { echo $row['v_name'] ; echo "<br />"; } ?> I hope that makes sense if not the greates tbit of coding ever seen

Great thanks... me being very slow

This is a bit of a js question but the relevant bit am stugglling with is PHP I am using the following to create some clocks on a site that relational to the server clock time. THe script etc are here http://www.6times9.com/javascript/cheatclock/ The script essential takes the time from php and then adds 1 sec every sec. I can get it to work but it always starts from 12.00. The support files say "the start time is specified using PHP (or similar) " How do I specify the time through php. I know how to get the time using php but don't know how i integrate it into this script I hope that makes sense THanks

This is a bit of a js question but the relevant bit am stugglling with is PHP I am using the following to create some clocks on a site that relational to the server clock time. THe script etc are here http://www.6times9.com/javascript/cheatclock/ The script essential takes the time from php and then adds 1 sec every sec. I can get it to work but it always starts from 12.00. The support files say "the start time is specified using PHP (or similar) " How do I specify the time through php. I know how to get the time using php but don't know how i integrate it into this script I hope that makes sense THanks

First time attempting to do this ie create a dynamic rss feed. Hoping someone can have a look at the below. I just can't seem to get it to work. Specifically i get a parse error on line 35 when in FF. When i check url in a reader it shows no items <?php header("Content-type: text/xml"); echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>"; // Set RSS version. echo " <rss version=\"2.0\"> "; // Start the XML. echo " <channel> <title>Caravanorcamper.com News</title> <description>Caravan or Camper is a drectory and networking site of rental firms and indivduals across the globe.</description> <link>http://www.caravanorcamper.com/</link>"; // Create a connection to your database. require("includes/connect.php"); // Query database and select the last 10 entries. $data = mysql_query("SELECT * FROM web_rss_items ORDER BY id DESC LIMIT 10"); while($row = mysql_fetch_array($data)) { // Convert database images data into actual image link. $row[description] = str_replace("images/", "http://www.caravanorcamper.com.au/images/", $row[description]); // Continue with the 10 items to be included in the <item> section of the XML. echo " <item> <link>http://www.caravanorcamper.com/article.php?id=".$row[id]."</link> <guid isPermaLink=\"true\">http://www.caravanorcamper.com/article.php?id=".$row[id]."</guid> <title>".$row[Title]."</title> <description>".$row[description]."</description> </item>"; } // substr can limit the number of characters. First number is starting point while the second number is number of // otherwise just use $row[description]. // <guid> is an optional sub-element of <item> but recommended if you don’t want to receive a echo " </channel> </rss>"; ?>

Perfect thanks

I have a form form which users are inputting data in to my Database. They often input pieces of text that contain " marks. This causes a problem as it seem to terminate the input a that point. How can I deal with this.? Can I somehow replace the " on input with say ' ? (not ideal) THanks

Ok VARCHAR made no difference. however... I have never had issues with charac set beofre but ultimately you were right meta's charset was UTF-8 whilst the character set of the database was set to Latin1 So problem solved . thanks

Pardon my ignorance. A little bit of a novice here.. Right well the mysql_real_escape_string does a good deal as you say . However the one thing it doesn't seem to to effect is this � The second point I can't quite work out what to do here. I have tried attaching the SendStringParametersAsUnicode=true in the connection string but it is giving me errors <?php # FileName="Connection_php_mysql.htm" # Type="MYSQL" # HTTP="true" $hostname_Surgical = "IP"; $database_Surgical = "DB"; $username_Surgical = "US"; $password_Surgical = "PS"; SendStringParametersAsUnicode=true; $Surgical = mysql_pconnect($hostname_Surgical, $username_Surgical, $password_Surgical) or trigger_error(mysql_error(),E_USER_ERROR); ?> Could this be that I am inputting the information into a long text field