barnamos

We build linux based POS systems with PHP/MySQL. We plug a good USB scanner (try cobra) and it reads the barcode and translates to text. There's not a script side parsing from code39 to text that you have to do, that's what the reader does. If your reader sends delimiters, …

Pass the current row count as a variable to the query. At each result row add <? $goin_back = $row_num - 1; $goin_ahead = $row_num + 1; ?> <a href="?row_num=<? echo $goin_back;?>">Back</a> || <a href="?row_num=<? echo $goin_ahead;?>">Forward</a> Then your query does a: SELECT * FROM table LIMIT $row_num , 1 …

Is this a new install? ie can you wipe and start over or are you trying to upgrade? When my old machines give me this its usually some bad areas on the drive and I just reformat and reinstall.

Try writing one yourself. They aren't too tricky. 1) use mysql_num_rows to get the number of rows. 2) in your while loop put a counter that only echos results within the range you want. 1-10, 11-20, 21-30 etc 3) pass the "starting" count in each pagination link Here some code …

sure sounds like your previous install left tables sitting around and now you can't set up the default tables that mysql needs for your new install. I'd start over and find where your tables are hanging out /var/lib/mysql maybe? Make sure you have no tables when you install again. [QUOTE=riscphree] …

Means the page can't find a function you are trying to use. The function called has to be in the page or in an included file to be used. That make sense??

Database is really made for this but if you have no db, you can get pretty creative and use fopen & fwrite to write a text file to your server. The password dealy mentioned above would help as a simple authentication, nothing happens if password isn't right. So if you …

header stuff has to come out before anything else is printed to the screen. Try splitting the code in two. Put the header at the top and then move your image code to where you need it.

Hard to tell unless you include the actual function as well -> display_dl_menu However you might just add a slash to the single quote and see if that fixes it. So Jill's becomes Jill's

Sounds like you need to post your form values to a page that searches on those values and creates another form? Basic queries using php would do the trick. Use the while loop to write your option tags. So Page 1's form has this: <select name=type1><option value=a>Option A</option> <option value=b>Option …

The easiest way to get this going is to use a database to store the information on each trainer, including newsletters etc. Php is often used to present results pulled from SQL databases (MySQL, Postgre, etc.) Many web hosting outfits give you access to a database as well as part …

You are using name[] as the variable name. Leave those []'s off and use just name. But you probably want to clean up that text field before using it. However, that's for another post.

Also, plan on having the store access the same database as the website. That way you can keep info in real time and not mess with dumping data and importing on some schedule.

from mysql docs under the SELECT syntax: SELECT a,b,a+b INTO OUTFILE '/tmp/result.txt' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM test_table; Then you can use the LOAD DATA syntax: LOAD DATA INFILE 'data.txt' INTO TABLE tbl_name FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED …

Hey Dani, also try logging slow queries. This is a great way to see where you may have some indexes not being used or other bottlenecks.

You can try the "Create database books" and see what happens. Either from command line or through your mysql client. phpMyAdmin is great BTW. If not, just create new tables within your existing database and use a prefix to sort them out. like bb_table_a, bb_table_b. You can set up table …

No to be silly but "No database selected" means "no database selected". You need a mysql_select_db($database_name,$listing); :-)

mysql is simply a database. It doesn't use and isn't a webserver. You use a scripting language like PHP to write SQL commands that mysql can understand. PHP can format the data in such a way as let a webserver present the information within a webpage. This is different than …

Not completely sure I understand your application but.... 1) you'll need to have variables that have at least one alphanumeric character in them. You can use $1 for a variable but you can use $val1. 2) To increment the value of a variable, you can just: $val1 = $val1 + …

Seems like you could build your query according to what it entered. I take it you are having trouble because field 7 might be blank and you don't want to search for a blank field 7, you want to ignore field 7? So just do a: if ($_POST["gender"]) $qry.="gender='". $_POST["gender"]."',"; …

lol, I think you'll need to provide a LOT more information to get a useable reply. There are a myriad of ways to do logins depending on your database structure and what you want them to be able to do. I can only guess that you want artists to be …

Settings/Configure Toolbars and you can go crazy. All available choices are there and you can move them around as you need. Mine is so tailored to how I work that I can hardly work on any other machine. My favorite part of konqueror is using it as a sftp client …

You can use CD1 as a boot CD. Press F2 (I think) for options and head to rescue mode. Run /usr/X11R6/bin/xf86config as root and choose minimal resolutions to at least get ya going. [QUOTE=elpablo]Hi, I'm very new to linux and I have some problems installing Mandrake 10 on VMWare 4.5. …

phpbb has its own install scripts that builds the tables. Can you "see" your phpbb install? Are you sure mysql is running? By the way, a very nice interface to mysql is phpmyadmin. Once you set it up (medium skill level) then you can see what you've got. [QUOTE=Amunra]I am …

Hard to tell much with this info. There are special kinds of drives, but most machines for the past years use IDE drives. Look at the ribbon cable that comes out of the existing hard drive, is there another connector on it? Will it fit the new drive? If so, …

I would guess it may be that you are running a query on newsletter but your database is called user_newsletter. :) add or die(mysql_error()); onto all of your mysql_query($q) lines and see if that doesn't tell you whats up.

[QUOTE=nizzy1115].., but then it stops with a floppy disk prompt [A:/] [/QUOTE] Are you seeing a message regarding "additional drivers" floppy?

yikes thats a lot of code! Does the autoresponder have a database on its back end? Can't you just poke it into the database yourself?

Well as a webmaster you will still be writing HTML even with PHP :) PHP will allow you to manage your websites way easier as you can write pieces of HTML and then "include" them into your html for instance. the php.net website is a great resource once you get …

Try rolling your own. You don't need anything super fancy, a basic MySQL/PHP on a rented box would work fine. I've got old 400mhz boxes purring along with a million mysql records in them and they search and display fine. What you WILL want is a USB barcode reader (like …

what does the mysql_error tell you is happening?

make sure your entire page uses a style sheet, then create different style sheets for each skin you want. Say you have style sheets named fishy.css and aqua.css Then you can set the skins using a cookie and use the cookie to load the associated style sheet. So you have …

[QUOTE=venetian_jigsaw] (1) Allows a user to enter a temperature and based on a selection from a radio button, converts the temperature to either celcius or fahrenheit. (2) Writes the output to another php page. My problem lies when selecting either the celcius or fahrenheit radio button. How do I get …

what is linear text? can you give an example/illustration?

Easiest thing to do is to alter your table to have a default value of "blank" rather than NULL. Then you don't have the problem. However, I don't see that you would have a problem unless you are using if's on the results. If your while loop is something like …

you are looking for php and mysql. You would have one page that receives a variable for the unique id for each row in your table and presents the dude's data. The bioform shoves the data into the database and sends you an email saying "Relax, I took care of …

[QUOTE=jeisma]Should be a PDC, DHCP, LTSP in our LAN. Or I should have asked were there any features stripped from the downloadable version?[/QUOTE] Nothing is stripped, there are 6 cd's worth of love for the taking. I currently use Mandrake for kiosks, workstations, POS systems, web/database servers, mail servers, laptops, …

> Example: > > I am trying to make this an instant quote forum based on what I assign each item its price. Basically, say a person selects one item per field and it adds it calculates the total instantly including any setup fees. If you aren't heading back to …

[QUOTE=tony27]I need help. Does anyone have a script that will take info from a booking form that is used to select a particular course at a particular time on a partiular day and send it to the administrator as a text file and notify the administrator by email. Does anyone …

[QUOTE] I'll step through row 2's calculation for example; I need to subtract row 2's average from row 1's average (40.0625 - 39.7500 = 0.3125), and multiply that by row 2's games played (0.3125 * 16 = 5), and add that value to row 1's average (5 + 40.0625 = …

[QUOTE=lady][COLOR=DarkSlateBlue][FONT=Tahoma]Hi, The problem is when I select all the students by using while loop and they displayed in the page, each student has a tick mark beside it to let the instructor select his name [/FONT] [/COLOR][/QUOTE] I'm guessing you have a "key" for each student record in the database? …

I don't know of a way to hand off an email to an outside SMTP server. If this was possible the SPAMMER knuckleheads would be in heaven. Better to figure out what's up with your own machine and get it going from there. Postfix is pretty standard and has gotten …

you've got plenty of resources for the job! I've got manny running on an iMac, a compaq laptop, a few dell boxes, and some home built machines. Lately I've been letting Linux Raid do the raid rather than a controller, seems fine. Run with the defaults first, its a pain …