phpstan

well i have info from a DB however for some reason i can't use some variables... or use other variables within the while loop!!!! here's my code: [CODE]function SeasonPrice($roomName) { require("dbCon.php"); mysql_select_db($database); $res = mysql_query("select * from room where RoomName = '".$roomName."'"); $row = mysql_fetch_assoc($res); $Booked_month = date('F'); if($Booked_month <= …

I have a HTML form Having two fields [B][I]From:[/I][/B] and [B][I]To:[/I][/B] both are [I][U]text[/U][/I] fields(to genereate a report).I want to use these data to query on two tables based on the date specified(DD-MM-YYYY) i.e from and to and using these to select values from the two tables visitor_in and visitor_out …

Briefcase application Access 2003 two way replication Are there any open source databases that allow two way replication exactly the way Access 2003 handles it? I have a desktop app that I would also like to have live on the web but I have to use Open Source software like …

Im having problems with this script. Right now it adds everthing to the database if I take this out [php] <p><b>Genre:</b> <p><input type="radio" name="genre" value="existing" /> Existing => <select name="existing"> <option>Select One</option> <?php // Retrieve all the artists and add to the pull-down menu. $query = "SELECT genre_id, (genre_name) AS …

If I am violating a rule please delete this thread. I posted this question in the Linux forms. [url]http://www.daniweb.com/forums/thread298067.html[/url] I have a screwed MySql install in Linux, I assume someone will have the answer to this over here as the Linux forums seem dry.

Hi, Trying to run this script via MySQL workbench. Can anyone see anything wrong with it? I suspect the foreign keys are not defined properly? Thanks [CODE]USE streamlibrary; DROP TABLE IF EXISTS streamlibrary.FileProperties ; CREATE TABLE IF NOT EXISTS streamlibrary.FileProperties( PK_fileName VARCHAR(50) NOT NULL, extension VARCHAR(4) NOT NULL , sizeMB …

When I upgraded to Ubuntu 10.4 the pop-up windows for my Evolution Calendar Alarms quit working. I would get a small icon on my task bar that let me know I had a calendar event to look at, but the alarm window no longer was shown.

I am trying to convert my CMS to SQLite for easy and quicker deploy-ability. Performance wise, I heard that SQLite might be the way to go. At any rate, I am having the hardest time with trying to convert my mysql database to a SQLite database. Having reviewed and downloaded …

My web host has closed off port 25 to user code as it was being used by other users to send spam. Unfortunately, I have the following code which I use to validate email addresses: [code=php]function fixed_gethostbyname ($host) { // Try the lookup as normal... $ip = gethostbyname($host); // ...but …

What I want to do is to rename a particalar file that is ftp'd to the server into a certain folder which I will call "raw" and have that file renamed to "image.jpg" in the folder "webcam" but the file uploaded by the webcam is different every time because the …

Really hope you can help with this one I have a problem whereby i cant get all my data (over 1million and different csv files) to map and import properly, so i thought it would be better to create new tables with all the information seperate (which i can do …

Hi Normally I would use the mysql_fetch_array command to get vallues from a DB array to print in seperate tables like below: [code=php] echo "<table width=\"100%\" border=\"1\"body bgcolor=\"#ffffff\"align=\"center\"text=\"#ffffff\">"; echo "<th>THUMBNAIL</th><th>NAME</th><th>SIZE</th><th>LOCATION</th>"; while($r = mysql_fetch_array($TagSearch)) { $Code = $r["Code"]; $Name = $r["Name"]; $Size = $r["Size"]; $ImgPath = $r["ImgPath"]; $PurchaseDate = $r["PurchaseDate"]; $StartCycle …