[mysql] Forum Topics

Hi, I am using Cerberus ticketing system Recently I have started getting lots of junk email with the subject line containing non0latin characters. The Subject & Content looks like this: [CODE] <br> antivirus Äú=ºÃ£º<br /> <br /> &nbsp;&nbsp;&nbsp;&nbsp;ÖйúÉÌÒµÊý¾Ý¿ª·¢×é֯ΪÄúÌṩ±ãÀû¶øÇ¿¾¢µÄ£¬<br /> ¡ï£µ£°£°£°£°£°£°ÖÁ¡ï£µ£°£°£°£°£°£°£°ÉÌÎñµç×ÓÐÅ<br /> º¯±¬·¢Í¶·Å·þÎñ£¬È·±£ÄúµÄ²úÆ·(ºÍ·þÎñ)µÃµ½¼«´óÊý<br /> Á¿Ïû·ÑÕߵĹØ×¢ÓëÇàíù£¬²»³îÄúµÄÉúÒâûÓÐת»ú£¬´ø<br /> À´È«ÐÂÈ«·½Î»´ó¸²¸ÇÂʵÄÉÌ»ú£¬Ç§Íò¼¶µÄÊг¡ÄúÒ²ÄÜ<br /> Ó®µÃ£¬Ê÷Æ·ÅÆ´òÊг¡µÚһѡÔñ£¡<br /> <br …

[B]Hi! I make nws CMS for self. I added search function too. But I have problem. I save data with html at DB Sample: [ICODE]<font color=red>Some text</font>[/ICODE] When I search for string "some" I get this row. But when I search for string "font" , I also get this row …

[code=sql] CREATE TABLE users ( user_id int(10) unsigned NOT NULL auto_increment, username varchar(20) NOT NULL default '', password varchar(20) NOT NULL default '', PRIMARY KEY (user_id) ) TYPE=MyISAM; [/code] [COLOR="Red"][U]Questions:[/U][/COLOR] 1. What is the purpose of MyISAM? 2. What happen if I created the above table without MyISAM.

I Started Installing it and i am getting this error Step 2) Connect to the database Attempting to attach to database Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/www/tropical4.freefronthost.com/Vb/Vb/includes/db_mysql.php on line 140 The database has failed to connect because you do not have permission to connect …

I have a problem with a query and an insert. I have a database that maybe isn't the best design - it includes a field "Former Names" which is varchar 255. It contains a list of names separated by commas. e.g.: "Svea Jarl, Apollo III " I would like to …

Hi there I'm setting up twp table that are linked with a foreign key. members customer_id (primary) fobnumber ZERO FILLED firstname lastname emailaddress access_id (foreign) userAccess access_id (primary) username password (engine: InnoDB) I have created recreated these tables, when both tables seem to linked. Data will go in to one …

hi all, i have two tables, table1(id, name, address) and table2(id, phone, email, status). now i want to fetch data from both tables and display in a table. what i want is data must be fetched from table1 and table2 when the status in table2 is 1. if status in …

i have been getting this problem n this is getting into my nerves.. it works fine on the web.. but i need to present it on the intranet tomorrow "sunday" it gives this damn error. of mysql_fetch_array.. can u plz help me CODE: <div id="right_nav"> <div id="cga_events"> <div id="navtop" align="center"> …

Hi! I have a problem with this line: GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, LOCK TABLE ON test.* TO user1@localhost IDENTIFIED BY "abcdef"; Here is what I do: [CODE=SQL] >mysql -h localhost -u root -p Enter password: ******* Welcome to the MySQL monitor. Commands end with ; or \g. Your …

Hello experts could someone tell me how can i combine multiple records into one value. Sample in MS Access: (Lastname & "" & "," & " " & Firstname) AS Name How can i do this in MySQL?..tnx in advance

Ok, I've had enough of looking at the same piece of code now. Someone please enlighten me as to what simple bloody thing it is I'm missing: [code=php] $pp2 = $_REQUEST["pp"]; $io2 = $_REQUEST["io"]; $sn2 = $_REQUEST["sn"]; $re2 = $_REQUEST["re"]; $sd2 = $_REQUEST["sd"]; $ed2 = $_REQUEST["ed"]; $dp2 = $_REQUEST["dp"]; $rn2 …

Anyone know where I can get a free MySQL database so I can start the learning process for myself? I saw a post listed here for dbfree.net.. that post is old.. that takes you to IX Webhosting. I signed up for db4free.net but when I goto login it says "Loading" …

Hi there I posted this problem in the php forum thinking the issue was something I had done wrong with my PHP but is now looking like a MySQL or possibly a technical computer error altogether: [url]http://www.daniweb.com/forums/thread108602.html[/url] Could someone please help me out.

Hi guys, I am trying to find a solid optimization technique for my problem. I have two tables that grow quote large: [code] CREATE TABLE `mydb`.`xm_artist` ( `artist_id` int(10) unsigned NOT NULL auto_increment, `artist_name` varchar(255) NOT NULL, PRIMARY KEY (`artist_id`), UNIQUE KEY `index_artist_name` USING BTREE (`artist_name`), FULLTEXT KEY `fulltext_artist_name` (`artist_name`) …

hi i am learning to work with mysql and c. i want to select a particular row from database which must be equal to a variable and the variable should be given by user.the program is in c where i use c api to connect sql database. how to join …

I've got two tables - members and sponsor, their simplified structure below. members: id_num program_id sponsor_program_id sponsor: id_num sponsor Some of the members in members table are sponsors. I need to update the field sponsor_program_id in all records in members table with their sponsors program_id field. Sponsor table tells me …

Hello- I have these two tables: [code] CREATE TABLE ampref ( ampref_id serial NOT NULL, amp_id integer NOT NULL, code character varying(255) NOT NULL, description text ); CREATE TABLE amp ( amp_id serial NOT NULL, name character varying(255) NOT NULL, description character varying(255), url character varying(255) ); [/code] ...and I'm …

I installed script .It was working fine since one month but today this error is coming.Please be advice. Thanks [URL="http://www.marketdayafrica.com"]Link[/URL] [ICODE]SELECT a.*, UNIX_TIMESTAMP(a.createdon) AS timestamp, ct.cityname, COUNT(*) AS piccount, p.picfile, scat.subcatname, cat.catid, cat.catname FROM clf_ads a INNER JOIN clf_cities ct ON a.cityid = ct.cityid INNER JOIN clf_subcats scat ON a.subcatid …

I new to mysql and I need a free mysql developer software ?

Pliz help me for an efficient tagging system such as for images, articles, products etc, so that it could be easy for tag-could and relevancy searching for my web site. (php/mysql)

I've got a Perl script that lets a client of mine dump and restore his inventory database. It has worked fine for years, only I recently noticed strange file results. Instead of dumping the data to the file, I found this (I've munged the db name): -- MySQL dump 10.10 …

Using PHP on my registration page to register users on my site. Everything seems to be working properly from a PHP perspective. It even tells the user that they've been added. But when I view the table it only has one record which is the one that I created when …

I'm Trying to start a Tech forum on my website using phpbb. Can anyone help me get started? Thank you... <SNIPPED>

I am working on a product reviews site using php and mysql, and have a table set up for product data, as well as review data. I am trying to get a list of top rated products within the last 24 hours to show up on the front page. This …

Hello I am really new at this and are having trouble with MySQL updating .php files in the database program I am using. This used to work until I changed some of the .php file. I only changed the front end of these files and cannot see why what used …

Hi all, I want to add a string and a character to two columns of a sql database table. To do that I use a Command object rather to use the same connection on different functions. At the same time used a stored procedure to add data. Hear are some …

I have a standard SELECT query as follows: [code=MySQL]SELECT eid, title, content, thumb_image FROM diary ORDER BY eid DESC LIMIT 3[/code] ...and a SELECT SUBTRING query as follows: [code=MySQL]SELECT SUBSTRING(content, 1, 200) FROM diary[/code] I'd like to combine the two so that it selects the latest 3 entries in the …

Hello all, i have recently finished work on a clients database. they now wish for one field in the database to have 10% taken off for each record. can this be performed soley through an SQL statement on the MYSQL database.

Hi guys and gals Just curious to know if it's possible to select the 3 latest entries in a table. Would be an added bonus to my project. ;)

Hi there What I'd like to do is store a paragraph in a column and pull roughly the first 200 characters of the paragraph and display them on a page as a snippet. Is this possible? If so could someone give me a link or code snippet on how to …