11,093 Topics

Member Avatar for
Member Avatar for dr_dumb99

Hi ! When I want to display following code by assigning it to $res["description"] , in the following mentioned way, it works fine and displays properly. The code is : /************START CODE*****************/ <script language=\"javascript\"> var uri = 'http://impgb.tradedoubler.com/imp/img/16173558/1014659?' + new String (Math.random()).substring (2, 11); document.write('<a href=\"http://clkuk.tradedoubler.com/click?p=37983&a=1014659&g=16173558&epi=$_SESSION[UID]\" target=\"_blank\"><img src=\"'+uri+'\" border=0></a>'); </script> …

Member Avatar for Mr Violent
0
155
Member Avatar for wayotins

Hello, I Am having problems with a simple script i wrote to login a username and password from a mysql database. i get the error **Warning**: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in **H:\steadyology\steadyology\account.php** on line **21 I ran the script on my localhost where i …

Member Avatar for psalzmann
0
185
Member Avatar for ashwinperti

Sir, I had mysql file ss.sql. Now I want upload the file in the Database. Is there any way to do the same. Kindly help me in the matter. Ashwin Perti

Member Avatar for timmay
0
178
Member Avatar for Vote4WillFree

I have a table with three columns that I want to group. The columns are driver, passenger and date. Basically what I want is something like... SELECT COUNT(*) FROM TABLE GROUP BY driver,passenger,date; However what can happen is that the driver and passenger can be the opposite on the same …

0
72
Member Avatar for uma

hi,everyone my name uma,I use powerbuilder with mysql and have some problem.I have a table that have 2 primary key first a character and second a numeric.I create a datawindow that has 2 argument(primary key) for retrieve data.if second argument(numeric) has value more than 9 the datawindow can't retrieve data.I …

Member Avatar for last
0
888
Member Avatar for <?php?>

Hi all, does anyone know if it affects the way google ranks a page if most of the data in php pages is drawn from MySQL? For example - a simple [B]About Us[/B] page... One page in php with all body text drawn from MySQL, versus, one page in php …

Member Avatar for newonlineinfo
0
121
Member Avatar for katharnakh

I'm having problem in inserting into table. I'm inserting data from one table into another [I]insert into table1 select * from table2 where condition = expression[/I] I have 962 records in table2 for specified condition, but only 105 rows are getting inserted. Both tables are in same database. What could …

Member Avatar for Vote4WillFree
0
94
Member Avatar for Vote4WillFree

I have a serious problem. I am trying to update an entry in a parent table which has three children tables which are coupled in such a way that either on delete or update they are affected. What I want is to know if there is a way to update …

0
57
Member Avatar for bagnallc

Hi,I can provide all the code etc if you like but this is a very general query and therefore im hopeful someone can answer without too much inconvenience caused.My position and steps so far are basically this - I built a database full of information in MS Access.I duplicated it …

Member Avatar for barnamos
0
89
Member Avatar for puddin

Thanks so much Can anyone please tell me. I have Mysql 4.0 my users are listed by auto increment not null On the site I offer you a form to send a member a message you fill out the form. The form inputs are named = message from and user_id, …

0
65
Member Avatar for shaocpa

how deposit a picture to MYSQL database below is the code : <?php $id=$_POST; $photo=$_POST; if ($photo<>""){ $fp=fopen($photo,"r"); $data=addslashes(fread($fp,filesize($photo))); } $sql="insert into product(id,pic) values('$id','$data')"; mysql_query($sql,$conn) or die ("插入数据失败: ".mysql_error()); ?> but always unsuccessful! why? plz help me!

Member Avatar for noppid
0
221
Member Avatar for puddin

Hello Pro Programmers! Can you help me, Please!!! What I want to do is let my users message each other, I have my form and message page setup I love it! It’s working the messages are going in the right ID’S in the Mysql database, BUT! It is overwriting as …

Member Avatar for b225ccc
0
271
Member Avatar for Alex Matulich

I need to set ft_min_word_length=3, so that my users can perform boolean fulltext searches for words of three characters instead of four. However, I share the MySQL server with other customers of my ISP. My ISP's administrator is willing to change this system variable, [B]provided[/B] I can show him an …

0
101
Member Avatar for kuubay

hi...is there anybody who has the right software for converting MSSQL to MYSQL?maybe u can share with me? please help coz im still very new to these fields.

Member Avatar for nagramana
0
97
Member Avatar for omesa

Hello, I get the error bolow on my page, could anyone with an idea tell me how to go around it? mysql_num_rows(): supplied argument is not a valid MySQL result Regards, omesa

Member Avatar for omesa
0
70
Member Avatar for ShazB2K

Hi, Um new to php... kindly help me on the following... <?php $action = $_SERVER; ?> <?php //if(!$_POST=='result') //{echo "<p style=' font-family: arial; color: blue; font-size: 14px;'>You are not authorized!</p>"; return false;} //$choice=$_POST; $name=$_POST; $link=mysql_connect("localhost", "root", "") or die("<p class='texxt'>Can't connect to server: ".mysql_error()); mysql_select_db("test",$link); $query="SELECT * FROM saudi_journal WHERE …

Member Avatar for Puckdropper
0
119
Member Avatar for blue25

ok, im not too sure how to explain this, but ill try... i have a website that a friend hosts for me on his server. it is an oscommerce website that seems to run fine. i felt that working from the webserver was a little slow for all the images …

0
103
Member Avatar for puddin

Hello Pro Programmers! Can you help me, Please!!! What I want to do is let my users message each other, I have my form and message page setup I love it! It’s working the messages are going in the right ID’S in the Mysql database, BUT! It is overwriting as …

Member Avatar for Dani
0
84
Member Avatar for Viji

I am using MS Excel 2003, Win XP, MyODBC driver 3.51.12.This problem is associated with the use of MS Excel with Mysql Connector/ODBC3.51.12 . Connector/ODBC was installed and tested successfully.However,I tried to import data to Excel from the MySQL database that resulted in error message "[MySQL][ODBC 3.51 Driver]User cancelled. Procedure …

0
113
Member Avatar for Megy

[LEFT]Hi. I hope I put this in the right spot, I have this friend that is making a game and now hes on the client; hes finnished the login server, char server, world server and some packets folder but when he runs it and clicks on a monster nothing happends …

0
18
Member Avatar for freemag

I have a txt file (log) that an application writes to regularly that I want to automate import into a MySql table. I intially thought about using LOAD DATA INFILE but can not use this in a stored procedure. Any thoughts or suggestions? Thanks in advance... Greg

0
67
Member Avatar for animatronico

I just got this [B]Error Returned when i tryied Type the url of my site [/B] mySQL query error: SELECT e.*,b.blog_name, b.blog_friendly_url FROM ibf_blog_entries e,ibf_blog_blogs b LEFT JOIN ibf_blog_categories bc ON ( e.blog_id=bc.blog_id and e.category_id=bc.category_id ) WHERE e.entry_status='published' AND (b.blog_private=0 or b.blog_id = 1) AND ((bc.blog_id IS NULL) or (b.blog_id …

0
88
Member Avatar for Dani

I am currently running one script between two databases. This means that halfway through the script, I need to run [inlinecode]mysql_select_db()[/inlinecode] and then farther down in the code, run it again to switch back to the original database. My question, essentially, is if the overhead in doing this is hideously …

0
87
Member Avatar for ep2002

Hi everyone, I hope you are all doing well :) Ok, questions... I finally found a new hosting company that I want to sign up with & now there seems to be problems with them understanding what I need. On my current hosting company I can store my manuals & …

Member Avatar for shamancatfish
0
189
Member Avatar for Horst Azeglio

I'm trying to do a MySQL Query but it doesn't work. MySQL version: 4.0.26 When I put only one argument in MATCH, it shows no error but doesn't return anything [quote] SELECT * FROM item WHERE MATCH (nom) against ('Huile');[/quote] or [quote]SELECT * FROM item WHERE MATCH (nom_en) against ('Huile');[/quote] …

Member Avatar for Dani
0
112
Member Avatar for explorefreedom

Hi, I'm new to this forum and hope I'm posting in the right section! I hope someone can help. I am trying to upload a website but have been advised I need to edit the includes/config.inc file. I've to edit the database name, username and password which is fine but …

Member Avatar for trafficman
0
94
Member Avatar for aarya

i want to learn asp . can i use mysql database with asp.how to connect to mysql database. will u tell me the basic asp tutorials for beginners.

Member Avatar for oscarsierra
0
269
Member Avatar for naramis

hello there, im doing a program of consolidate database. however, my scope is to do it automatically. so far, i have designed a timer and also codes to insert the data from excel file into MySQL database. then, my idea is whenever there is an error occured in a particular …

Member Avatar for Comatose
0
162
Member Avatar for Shaftcmu

I need to "clean" the database so I only have data starting from 1-1-06. Can anyone help? Thanks.:)

Member Avatar for pty
0
130
Member Avatar for Joncamp

I would like to know if anyone has bench marked MySQL server, compared to Oracle. I have developed a database that will sort 1,000,000 records in less then 22 seconds (100 byte record sorting on 2 fields, and 1.3Ghz cpu).

Member Avatar for d66
0
96
Member Avatar for nagramana

Hi, How to insert blob into MySQL using ODBC in C#. My application is windows application. Thanks Ramana

Member Avatar for nagramana
0
119
Member Avatar for nzdatezone

Big hello to all We run two website site with some stiff competition Website 1 [URL="http://www.swapshop.co.nz"]http://www.swapshop.co.nz[/URL] Website 2 [URL="http://www.nzdatezone.com"]http://www.nzdatezone.com[/URL] Website one has been promoted and SEO for 6months-1 year and we average 1000-4500 hits a day but 90% are SE. Yahoo is well the worst. We need advice on how …

0
34
Member Avatar for sam1

hi, i am using elcipse in suse linux, but cant connect to mysql. if anyone uses eclipse ide in linux can you please help me to get it connected. thanks

Member Avatar for Phaelax
0
611
Member Avatar for rubiton

Can someone please write the script for connecting to MySQLdb Also if anyone knows a good tutorial form transfering info from a python module into a MySQL table. Thanks in advance.

Member Avatar for rubiton
0
171
Member Avatar for puddin

Hello, When I select my images they are opening. Only the jpg will not come in clearly. If you know the code to correct this can you please tell me, Thanks puddin Here is my code: <?php include'db.php'; // get the variables from home page $password = $_SESSION['password']; $email_address = …

Member Avatar for digital-ether
0
197
Member Avatar for Zayed

<?php $SearchType = $_POST["SearchPlace"]; $host= 'localhost'; $user= 'user'; $passwd= 'password'; $database= 'dbase'; $table1= 'BUS'; $table2= 'STUDENT'; $connect= mysql_connect($host, $user, $passwd); mysql_select_db($database); $pquery = "select busNo from $table1 where place like '".$SearchType."'"; $squery = "select * from $table2 where busNo like '".$pquery."'"; $run = mysql_query($squery); $num_results = mysql_num_rows($run); if (!$SearchType ) …

Member Avatar for cdwhalley.com
0
175
Member Avatar for Fel

Hey, I've been trying to code my own news/ blogging script, by following a tutorial, but unfortunately I keep getting these mysql errors when I submit an entry, and on the page where I want it to be displayed. And I don't know how to recognize the errors just by …

Member Avatar for Fel
0
215
Member Avatar for naramis

hi there, my task is to do the automation of consolidated database (MySQL). i have to upgrade the previous Consolidated Database (CD)programming. so far, i have already designed a timer. but my problem now is on how to plug in this timer to the previous CD source code. the previous …

Member Avatar for Comatose
0
123
Member Avatar for DieselPower220

I have been trying to learn this database thing for the last 3 months without much success , its understanding the structure that puzzles me the most say for example i want a page listing all types of fruit oranges apples bananas grapes then i would want another page listing …

Member Avatar for VioletSite
0
89
Member Avatar for puddin

Hello and a BIG Thank-You!!! To you who have helped me... This I think will be my last image question. Okay the user uploaded a picture , it went to the (Photos directory) (Name and Type Show) Great!... Next to the (Mysql Database under aphoto_filename) Again with (Name and Type …

Member Avatar for VioletSite
0
149
Member Avatar for ayajhane_dhagz

juz wanna know the syntax for retrieving and storing data from and to mysql database using php....

Member Avatar for ayajhane_dhagz
0
228
Member Avatar for rcasinillo_s

Good day! After upgrading my MySQL to version 5 becoming very slow what's wrong with this? Please any could give advice how to optimise it. Thank you. Roland.

Member Avatar for alpha2006
0
119
Member Avatar for puddin

Hello , If you know the answer please simplify it for me. I am so discouraged trying to figure this out. I'll be very grateful, Thanks ahead a time! When I insert my (2) selected photos in my photo form , they show two pictures but it repeats only (1) …

Member Avatar for alpha2006
0
112
Member Avatar for Brims

hiya in my database i have a users table Create Table Users( user_id INT UNSIGNED NOT NULL AUTO_INCREMENT, email varchar (40) NOT NULL, pass CHAR (40) NOT NULL, first_name varchar (15) NOT NULL, last_name varchar (30) NOT NULL, active CHAR (32), registration_date datertime NOT NULL, PRIMARY KEY(member_id), UNIQUE KEY (email), …

Member Avatar for campkev
0
175
Member Avatar for johnrulz2003200

Hello. People get this error message when they try to sign up at our site. Can anyone tell me what is wrong. Thanks in advance. 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 …

Member Avatar for campkev
0
52
Member Avatar for ashwinperti

Hello As I am new to PHP I would like to know that I am facing problem connecting to the Database. And not able to find the reason of not connecting. I also want to know about the difference between mysql_query, mysql_fetch_row, mysql_fetch_num Ashwin Perti

Member Avatar for Lafinboy
0
110
Member Avatar for lance471

Ok, before I get started I have a few things I need to clear up. 1) I am relatively new to VB, I come from a webdesign background and picked up the basics pretty quick. 2) I dont have an understanding ADO 3) I am not using VB.net, dont judge …

Member Avatar for Comatose
0
128
Member Avatar for ronb722

Hi all, I am seeing the following error in my tomcat log file. Please see the attached file for the full error with stack trace. When I first bounce the server all is ok. After running for some time (I haven't yet been able to determine the exact amount of …

Member Avatar for ronb722
0
315
Member Avatar for naramis

hi there, im new in Visual Basic. currently my task is to create a program that will automatically consolidate database based on the time. for example, the program will executes at 10 pm everyday in which the database will be consolidated in that particular time. the database that im using …

Member Avatar for naramis
0
96
Member Avatar for puddin

Hello. I have an image system kinda working, when it uploads however it is uoloading calling all the images ARRAY.gif or ARRAY.jpg Can you see what I should do that it correctly list the images name. The code is two parts. The preupload form page NEXT To The photos.php page …

Member Avatar for puddin
0
154

The End.