10,940 Topics

Member Avatar for
Member Avatar for u8sand

Hello, I have my own website where I make programs and put them up on my web page, it has info on the programs ext.. I also allow other people to put up they just have to e-mail me with a specified template. But I want to make this easier …

Member Avatar for diafol
0
263
Member Avatar for manilaguy

Hi guys! I'm designing my first site and i've stumbled on huge block. Problem I'm having is that Ajax doesn't seem to update my MYSQL table in firefox. I have two forms and two functions (each initiating a XMLHttpRequest). First is to display a MYSQL query using PHP and second …

Member Avatar for essential
0
95
Member Avatar for jjtao

Please help me, I am getting the following error; There was an error with SQL: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND visible=1' at line 1 Not sure what is …

Member Avatar for jjtao
0
99
Member Avatar for joshfolgado

Hi, I need to compare MySQL, MS SQL 2008 and Oracle. Do you know of any link where this comparison takes place? I found a few comparign MySQL and MS SQL 2000 but not with MS SQL 2008 and Oracle too. Can you please help? Thanks Josh

Member Avatar for joshfolgado
0
140
Member Avatar for Newbi

Hi i am fairly new to php and am trying to make an application where some1 enters a unique id which brings up a form with data in it retrieved from the database. the user should then be able to edit the information and submit & the details changed in …

Member Avatar for Newbi
0
199
Member Avatar for zachabesh

Hey all, Here's my problem: php/mysql noob here. I have an admin section on the website, and I have successfully password protected all the php pages in that directory using sessions. I have included code like this on the top of each of my pages: [code=php]<?php include('login.php'); if (checkLogin() != …

Member Avatar for zachabesh
0
148
Member Avatar for desiguru

I have a database with about 150 tables in it. Now I wanted to copy all of the tables with something like [COLOR="red"]tablename[/COLOR]_copy at the end of each table. Also the data that will go in each of the table will be the same.

Member Avatar for iamthwee
0
64
Member Avatar for angryfans

I'm trying to display a certain amount of words on one page from a database entry. For ex., on my main page I want to display the first 50 words of a story then a link will lead you to the rest of the story. I kind of know what …

Member Avatar for iamthwee
0
124
Member Avatar for papermusic

[CODE] <?php include 'dbc.php'; $query = "SELECT * FROM em.tutor"; $result = mysql_query($query); while($row = mysql_fetch_array($result, MYSQL_NUM)) { echo "Name :{$row[0]} <br>" . "Subject : {$row[1]} <br>" . "Message : {$row[2]} <br><br>". "Message1 : {$row[3]} <br><br>". "Message2 : {$row[4]} <br><br>". "Message3 : {$row[5]} <br><br>". "Message : {$row[6]} <br><br>". "Message : …

Member Avatar for buddylee17
0
208
Member Avatar for papermusic

test_imagedb_create.php [CODE] <? $dbserver = "localhost"; $dbuser = "root"; $dbpass = ""; $dbname = "em"; $dbconn = @mysql_connect($dbserver,$dbuser,$dbpass) or exit("SERVER Unavailable"); @mysql_select_db($dbname,$dbconn) or exit("DB Unavailable"); $sql = "SELECT image_type,image FROM em.testblob WHERE id =". $_GET["id"]; $result = @mysql_query($sql,$dbconn) or exit("QUERY FAILED!"); $contenttype = @mysql_result($result,0,"imgtype"); $image = @mysql_result($result,0,"imgdata"); header("Content-type: $contenttype"); echo …

Member Avatar for papermusic
0
695
Member Avatar for loligator

Hi all, I want to store the hours of restaurants in a database (sounds simple, right?). I don't want a text field where hours are entered as a lump of data, but was thinking of making a column for each day of the week and filling in the hours this …

Member Avatar for loligator
0
188
Member Avatar for tanha

Hi. Suppose I have a list box, which is filled out from mysql, and I have a text box and a submit button. I want to add the text box data into list box and at the same time I want to have the text box data into mysql as …

Member Avatar for tanha
0
255
Member Avatar for aditi_19

Hi, I have a problem. I am storing projectid (varchar) as a field in this format :- DD-NNN where DD is the last two digits of the year and NNN is the next project number within that year (i.e. 09-500 is the 500th project in year 2009). The user has …

Member Avatar for somedude3488
0
99
Member Avatar for newnetzerouser

I need help on fetching data before inserting. My issue is as follow: My table fields are: serial_start_no - varchar(25) - unique key serial_end_no - varchar(25) - unique key Using JSP user will be allotted the starting number and ending number (i.e. 1. Start number – S001 and End number …

0
50
Member Avatar for rubsay

Hello All. I want to update email in User table from the active directory. For this i am doing the following. 1. Extract all usernames from User table whose emails are not updated SELECT username FROM `mantis_user_table` WHERE email = 'No Email' or email = '' into outfile "C:/temp/test1.txt" 2.Run …

Member Avatar for iamthwee
0
101
Member Avatar for sarithak

Hi frnds... here i am uploading images....i am getting error when i use songle quotes in title(otherwise correct)......plz check this one..[CODE] $gcategory=$_POST['gcategory']; [B]$gname=mysql_real_escape_string($_POST['gname']);[/B] [B]$tmp_name = mysql_real_escape_string($_FILES["gphoto"]["tmp_name"]);[/B] $name = mysql_real_escape_string($_FILES["gphoto"]["name"]); $tname = mysql_real_escape_string($_FILES["tphoto"]["name"]); $ttmp_name = $_FILES["tphoto"]["tmp_name"]; $date=date('y-m-d'); $dir="../../gallery/allgallerys/$gcategory/$gname"; $tdir="../../gallery/allgallerys/$gcategory/$gname/thumb"; if(!file_exists($dir)) mkdir($dir)or die("Filename all ready exits"); if(!file_exists($tdir)) mkdir($tdir)or die("Filename all ready exits"); …

Member Avatar for joe1987
0
142
Member Avatar for barneygurl

I need help!!!!! I would like to know how i can restore my mysql db from one form. I got the backup to work using mysqldymp but when I try to restore the .sql file created, nothing I try works.

Member Avatar for indika75
0
126
Member Avatar for joshfolgado

Hi, We currently use MySQL and need to create a mechanism where we replicate some of our databases in a safe and consistent manner. Lets assume we have a main database which would be replicated onto another database and it is this replicated database the users access for their queries. …

0
40
Member Avatar for joshfolgado

We use poli-morphism with Java classes and I need to duplicate this with a database design... let me explain... Lets assume: - we have customers - customers can either be rich or poor - we want to store different details for rich and poor customers; i.e.for poor customers we may …

0
43
Member Avatar for mvt6204

Hi everyone, I've been a programmer for about 3 years and not so long ago, I decided to switch my interest to web development. For that reason, I've been learning PHP & MySQL for some times. However, I feel a need of direction about what is relevant to the current …

Member Avatar for itisnot_me
0
179
Member Avatar for chrispaul8676

hi there, i would want to change the mysql to mssql. please help [ICODE]<%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.SQLClient" %> <script language="VB" Runat="server"> Dim blHasRows as Boolean Sub doInsert(Source as Object, E as EventArgs) Dim strConn as string = "server=YourServer;uid=YourUID;pwd=YourPWD;database=YourDB" Dim MySQL as string = "Select * from samples …

Member Avatar for chrispaul8676
0
90
Member Avatar for sfrider0

I'm trying to delete rows from my database by using an HTML form. I can retrieve the database and display it nicely in a table using this code: [code] <table width="889" border="1"> <tr> <td width="206" bgcolor="#999999"><div align="center"><strong>Site</strong></div></td> <td width="549" bgcolor="#999999"><div align="center"><strong>Reason</strong></div></td> <td width="112" bgcolor="#999999"><div align="center"><strong>Date Added</strong></div></td> </tr> <?php $row_count = …

0
99
Member Avatar for ramsri05

Dear Friends. :) I am new to this forum and php coding as well. 1. I would like to know whether we can able to [B]import .xls excel[/B] file contents into the [B]mysql database[/B] table using [COLOR="Red"]php[/COLOR].? Objective: User has to browse the excel file from their system and import …

Member Avatar for chrishea
0
563
Member Avatar for Freedom2

This old fart is attempting to get his aged brain wrapped around this mysql/php stuff. Getting my data from Excel into a Mysql db took some doing, but I got it done. Hooray for me! Now I've been trying to get that data into a page using php. I've managed …

0
46
Member Avatar for SKANK!!!!!

i went to tizags ajax mysql tutorial(how to update mysql with ajax) i dont understand it seems like that example is wayyyyy too long i cant comprehend it it makes no sense. does anyone know of a good way to explain to me how to update / insert a value …

Member Avatar for essential
0
146
Member Avatar for ROTC89

ok so i am trying to make a program that is able to viewed on the web using mysql and php together. i have to show a little icon or something saying would you like to view the listing you submitted. this is my program but i keep getting a …

Member Avatar for ROTC89
0
111
Member Avatar for tbolt

I have a problem selecting unique rows from a table where if two specific columns are the same value as another row. Easier if I lay it out: Table Notifications (other columns, but not useful to example) id, profile_id, recipient_id, created, type, type_id, notify I only want to return * …

Member Avatar for stephen84s
0
77
Member Avatar for iwanwh

I have a simple query: [code=php]$query = "SELECT Item_Name, Item_wiki, Item_Website FROM items_list"; $result = mysql_query($query, $db) or die(mysql_error($db)); // loop through the results while ($row = mysql_fetch_assoc($result)) { extract($row);[/code] I want to put another query inside it. I have a second table (item_clip) that holds the photos for each …

Member Avatar for iwanwh
0
67
Member Avatar for grr

[code=sql]SELECT DISTINCT COUNT(*) AS occurences, post_name, post_content FROM wp_posts WHERE ((post_name LIKE '%ihop%' OR post_content LIKE '%ihop%') OR(post_name LIKE '%pancak%' OR post_content LIKE '%pancak%')) ORDER BY occurences DESC[/code] I use wordpress and am writing a script. Here is the table: post_name ihop post_content pancake house Thanks, Ian

Member Avatar for grr
0
110
Member Avatar for josephbarros

Hi i need use this sql on mysql. [code=sql]WITH destinations (departure, arrival, connections, cost) AS (SELECT a.departure, a.arrival, 0, price FROM flights a WHERE a.departure = 'Chicago' OR a.departure = 'New York' UNION ALL SELECT r.departure, b.arrival, r.connections + 1, r.cost + b.price FROM destinations r, flights b WHERE r.arrival …

Member Avatar for josephbarros
0
86

The End.